Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

SAP Hana Cloud > 80 Questions > Flashcards

80 Questions Flashcards

1
Q

Why would you create SQL in cal views

A

To implement custom logic

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Which type of join supports a temporal condition in a cal view

A

Inner join

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What can you do with shared hierarchies

A

Enable SQL SELECT statements to access hierarchies, Provide reusable hiearchies for drilldown in a cube without star join

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What options do you have to handle orphan nodes in your hierarchies

A

generates additional root nodes, assign them to a level below the root

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Which privileges would an user require to view US data when querying the cube cal view?

A

A SELECT privilege on the cube cal and an analytic privilege (Country=US) on the dim cal view

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What do you use in the def on a dynamic SQL analytic privilege

A

A procedure that returns the data access condition as an SQL expression

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Which tool generates and executes the SQL for specific node of ur cal view

A

Debug query mode

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

You are managing ur source files using GIT. In which sequence does ur file progress towards a commit

A

Working directory->staging area->local git repository

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

You want to create a star schema using a cal view. The measures are based on columns from two transaction tables. Dimension cal views provide the attributes. What is the correct approach

A

Combine the transaction tables using a join node in a cal view of type Cube with star join. Use a star join node to join the dim to the fact table.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What are some best practices when developing a cal views

A

Include all data flow logic within one cal view?, Avoid defining joins on cal columns

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

In ur cal view, you want to consume a custom data source defined using SQLScript. In which type of object do you write ur code

A

Table function

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What are some of the typical roles in an SAP HANA Cloud implementation

A

Data architect, Modeler

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

In a cal view, the table function node executes a table function that requires input parameters. How can you fill the input parameters of the table function

A

Define constant values, map columns from lower nodes, and create the map an input parameter.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

In DB module, what is the purpose of the .hdiconfig file

A

To specify which HDI plug ins are available

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

You are deploying a new cal view, A, that uses cal view B. When you preview cal view A, the account number is not masked. What could be the reason

A

You didn’t define masking in cal view A

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What are the limitations of using a full outer join in a star join node

A

It must appear in the last dimension in the star join node, it is restricted to one dimension in a star join node

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

You combine two tables in a join node using multiple columns in each table. Why do you enable the dynamic join option

A

To ensure that join execution only uses the joined columns requested in the query, to allow data analysis at different levels of granularity with the same cal view

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

You create a table function to remove historic records, sum the current total weekly working hrs for each employee, and update the personnel table with the results. The deployment of the table function fails. Which of the following could be a valid reason.

A

Your function includes a truncate statement

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Why would you choose an HDI shared service plan instead of a schema service plans

A

You want to use BAS, you want to use containers to isolate objects, and You want to create DB objects using source files

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

You want to ensure that cal view does not give unexpected results for a query that is based on any combination of columns. what is the recommended approach for verifying the results

A

Write and execute a custom SQL query in the SQL console, Select data preview for the cal view

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

You have configured static cache for your cal view and run a query against it, but the cache results are ot being used. What might be the reason for this

A

You did not define any columns in the cache setting

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

At which levels of a project structure can you execute a deploy operation

A

Entire workspace, sub folder of a database module

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

You have imported a new cal view in a folder that contains an .hdinamespace file. This cal view consumes one data source, which is a table. When trying to deploy the cal view, the deployment fails with a namespace-relate issue. What could be the reason?

A

The namespace used within the cal view to reference the table is different from the actual namespace in the identifier of this table, The imported cal view and its data source have different namespaces

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

What is generated when you deploy a cube cal view design time file

A

Cached results to improve read performance, metadata to enable consumption by external tools

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

Why would you enable Debug Query mode in a cal view

A

To identify data sources that are not accessed by a query

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

You define a hierarchy in a cal view. you want to expose the hierarchy to SQL. Which of the following conditions must be met

A

The hierarchy must be exposed by a cal view type Cube with star join, the hierarchy must be a shared hierarchy

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

Why does SAP issue warnings about the use of imperative or procedural SQLScripts statement

A

They introduce potential security risks

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

which components are part of SAP Hana Cloud

A

Data lake, SAP Hana DB

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

What are some of the restrictions that apply when defining parallelization block in calculation view

A

Only one block can be defined across a stack of cal views, The block must star with a node that defines a table as a data source

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

What is a restricted measure

A

A measure that is filtered by one of more attributes values

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

Which calendar types can be selected when creating time-based dimensions.

A

fiscal and gregorian

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

you implement a referential join between table A and Table B, but when you query the calculation view, Table B is not pruned.

A

join cardinality is set o :1, and integrity constrain is set to right

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

you have imported cal views from SAP Hana on premise to SAP Hana cloud. why should you switch cal column expression fro column engine to SQL.

A

To benefits from additional SQL optimizations

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

In a cal view, why would you implement an SQL expression.

A

To define a filter, to generate a restricted column and to generate a cal column.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

You create a user provided service to access tables in external schemas. In which file type do you assign the user provided service to ur DB?

A

yaml

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

Your calculation view consumes one datasource, which includes the following columns: SALES_ORDER_ID, PRODUCT_ID, QUANTITY AND PRICE. Inthe output, you want to see summarized dta by PRODUCT_ID and cal column PRODUCT_TOTAL witht he formula QUANTITY * PRICE. In which type of node do you define the calculation to display the correct result

A

Projection

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

You want to join two tables in a cal view. why do you use a non equi join

A

The join condition is not represented by matching values

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
38
Q

What are possible consequences of improper unfolding

A

SQL compilation time increases, count distinct results are incorrect

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
39
Q

Which of the following are standard options provided to define analytic privileges

A

SQL expression, dynamic and Attributes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
40
Q

You have generated caculation view properties file. What does it contain?

A

Description of all objects defined in a calculation view

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
41
Q

In BAS, you rename a Dimension cal view that is used by a cube cal view. You do not use the option to rename the runtime view and adjust the reference. Afterward, you perform the following deploy operations: Deploy the dimension cal view as a single object. Deploy the entire SAP Hana DB module. What is the outcome of the deploy operations

A

The first deployment is successful. The second deployment is successful.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
42
Q

Which database features are typically not required by analytical applications that run on SAP Hana cloud?

A

Pre-calculated aggregates, indexes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
43
Q

You combine two customer master data tables with a union mode in a cal view. Both master data tables include the same customer name. How do you ensure that each customer name appears only once in the results

A

Add an intersect node above the union node

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
44
Q

Why do you use the hidden columns checkbox in the semantic node of your cal view

A

To ensure specific columns are not exposed to the reporting tool, To remove a column that is also used as a label column

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
45
Q

What is the SQL keyword used to process input parameters defined in a cal view

A

Placeholder

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
46
Q

Two calculation view, A and B are defined. Analytic privilege 1 -> product = P1. Cal View 2: Analytical privilege 2 -> country = US or GE, Product = P2; Analytical privilege 1 -> Country = US. When you preview Cal View A, what data do you see?

A

US for P1 and GE for P1

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
47
Q

In calculation view, why would you choose the DEPRECATED setting

A

To ensure it is not exposed to reporting tools for consumption, To warn developers that the cal view is no longer supported

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
48
Q

You have defined a pruning configuration table in a cal view. What are you attempting to prune from the query execution

A

Filters

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
49
Q

which of the following data sources can you include in a graphical calculation view

A

Table function and row table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
50
Q

Why would you set the ignore multiple outputs for filters property in cal views

A

To force filters to apply at the lowest node

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
51
Q

Why would you use the SQL analyzer

A

To display the execution time of a cal view, to preview data at the node level of a cal view.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
52
Q

In a cal colum, what is the purpose of a variable

A

To provide a dynamic value in cal colum

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
53
Q

A new version of SAP Hana Cloud, SAP Hana DB is available from today. If you do not perform the upgrade manually, how much time do you have before your database will be automatically upgrade to the next version.

A

3 months

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
54
Q

Which project structure object correponds to a unique HDI container

A

SRC folder

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
55
Q

You created a procedure to be consumed in an analytic privilege of the type DYNAMIC but it is not working as expected. what could be the reason

A

No input parameter is defined, you defined more than one output parameter

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
56
Q

What can you identify using Performance Analysis mode

A

joins that are defined on calculated columns, and information about join cardinality

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
57
Q

You deleted the design time file of a cal view in your HDB module. what is the recommended way to ensure the corresponding runtime object is also removed from the database

A

Deploy the project that contained the deleted design time file

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
58
Q

Why would you use parameter mapping in a cal view

A

To pass variable values to external value help views, to push down filters to the lowest level cal views

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
59
Q

Why might you use the keep flag property in an aggregation node

A

to include columns that are not requested by a query but are essential for the correct result

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
60
Q

In SAP Hana Cloud, which tasks are handled by the cloud provider

A

Tuning the DB to run optimally on the underlying operating system and hardware, backing up the operating system and the DB software, Installing, configuring and upgrading the operating system

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
61
Q

Why would you create cal view of data category dimension with type time

A

To provide additional time related navigation possibilities

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
62
Q

Why would you use the transparent filter property in a cal view

A

To allow filter pushdown in stacked cal view

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
63
Q

Which of the following approaches might improve the performance of joins in a cube cal view

A

Specify the number of joined columns, limit the number of joined columns.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
64
Q

What are the key steps to implement currency conversion in a cal view?

A

Assign semantic type enable the measure for conversion
Choose client, source, and target currencies
Choose conversion date and rate type

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
65
Q

When is the first column store compression executed

A

When a delta merger is triggered

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
66
Q

Why would an SQL developer work with SQLScript

A

To pass parameters from cal views, to exploit additional data types, to implement conditional logic

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
67
Q

What is the recommended tool for developing cloud foundry applications

A

SAP Hana Cloud Central

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
68
Q

You set the Null Handling property for attribute but do not set a default value. What is displayed when null values are found in a column of data type NVARCHAR

A

Empty string

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
69
Q

What are the consequences of not executing a delta merge

A

Read performance decreases, new records are not read.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
70
Q

Why would you partition a table in an SAP Hana Cloud DB

A

To overcome the 2 billion record limit

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
71
Q

You created a table and inserted data in it using SQL statements inside the SAP Hana Deployment Infrastructure (HDI) container of your project. You add this table as as data source to a cal view and try to deploy it. why do you observe in the SAP Hana DB container

A

The deployment fails and the table is not dropped

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
72
Q

What are some of the typical tasks performed by the SAP Hana Cloud modeler role

A

Create graph workspaces and develop cal views

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
73
Q

Which of the following techniques can you use to improve the performance of the cal views

A

partition large tables and limit the number of stacked cal views

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
74
Q

Using the table in the diagram, you need to create a cube cal view. what is the simplest approach to create output shown in the screen shot.
Table A Output A
Country value France Germany UK
France 100 100 100 200
Germany 100
UK 200

A

Create a restricted column for each country

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
75
Q

a Cal view consumes the data sources shown in the graphic. You want to identify which companies sold products in January and February. what is the optimal way to do this.

Sales Prediction Jan Sales Prediction February
001 X 001 X
002 Y 002 Y
003 004
005

A

use an intersect node

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
76
Q

Which solutions form the SAP BAS platform

A

Analytics and Application Development & Integration

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
77
Q

a Cal view includes a rank node that uses the source data and settings shown in the graphic. How many rows are inthe output query

A

9

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
78
Q

You want to map an input parameter of cal view A to an input parameter of Cal view B using the parameter mapping feature in cal view editor. However, the input parameters of cal view B are not proposed as source parameters. what might be the reason for this?

A

You already mapped the input parameters in another cal view

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
79
Q

What are some best practices for writing SQLScrips for use with cal views

A

Break up large statements by using variables and choose declarative language instead of imperative language

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
80
Q

What are the advantages of column store table compared to row store tables in general terms

A

Higher data compression rates, parallel access is improved and higher performance for query operations.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
81
Q

What is Iot

A

Devices are more intelligent by including CPUs and Internet connectivity built inside.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
82
Q

What are the opportunities for innovation in the digital world?

A

IoT
Increase data volumes
Data Science
New Data Types
Increase of Mobiles devices
The move to the Cloud platforms

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
83
Q

What are the IT challenges on any organisation at the moment?

A
  • Massive increase in data volume
  • Legacy applications are difficult to enhance
  • Users expect innovative apps with great performance
  • IT landscapes have grown too complex
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
84
Q

What is the key driver in the intelligent enterprise?

A

Data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
85
Q

What Intelligence Enterprise is made of?

A
  • Business Processes
  • Applications
  • Technology
  • Infrastructure
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
86
Q

What is SAP BTP comprised of?

A
  • Database & Data Management
  • Analytics
  • Application Development & Integration
  • Intelligent Technologies
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
87
Q

What is SAP Hana Cloud

A

It is fully managed, in memory, cloud database as service (DBaas)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
88
Q

Can SAP Hana Cloud access live data remotely in real time from any system?

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
89
Q

What are the key services of SAP Hana cloud?

A

SAP Hana DB and Data Lake

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
90
Q

What are the two most important aspects of SAP Hana Elasticity:

A

compute (CPU) and data storage

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
91
Q

What is a dimension

A

Analysing the measures is easier if you group attributes together by dimension.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
92
Q

Dimension with associated attributes are

A

Sales Organisation->Country->Region

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
93
Q

A star schema consists of

A

one fact table that references one or several dimension tables.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
94
Q

A hierarchy is

A

a structured representation of an organisation, a list of products, the time dimension, and so on, by levels

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
95
Q

The term semantics is sometimes used to describe what a piece of data means, or relates to. A piece of numeric data that you report can be of different types, here are some examples:

A
  • A monetary value: the total amount of sales orders
  • A number of items: a number of sales orders, or a number of calls to support services
  • A weight, volume, distance or a compound of these measures
  • A percentage
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
96
Q

Default data category is never exposed to client tools. Are this type of views to be exposed to the users?

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
97
Q

Can the default views be used to build other views?

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
98
Q

Is the default view appear as blank in DS?

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
99
Q

In Cube star join: where do the private objects come from?

A

Join of facts tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
100
Q

In Cube star join: where do the shared objects come from

A

Join of dimension tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
101
Q

In How many ways can you determine what type of table is a SAP Hana table

A

3

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
102
Q

What are those ways to determine the SAP Hana table type

A
  • System/View catalog-> check the table icon. Open the table definition
  • Within a node in Information view consuming the table
  • From the SQL console – table M_TABLES:
    SELECT SCHEMA NAME, TABLE NAME, TABLE TYPE FROM M_TABLES
    WHERE SCHEMA_NAME = XXXX
    AND TABLE_NAME = XXXX
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
103
Q

TUFs are used when there is a need for

A

“if…then…else” or loops (for while)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
104
Q

What are the SAP Hana Engines

A
  • Join engine
  • OLAP engine
  • Calculation engine
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
105
Q

What are the two main steps to optimised the cal view when it is queried

A
  • The cal engine generates a single SQL statement, then it is passed to the SQL optimiser, and
  • The SQL optimiser adds additional optimisations and delegates operations to the best DB execution operator
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
106
Q

Standard data preview features In SAP Web IDE, there are two tabs,

A

Raw data: displays all data
Analysis: Selected attributes and measures in tables or graphs

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
107
Q

Setting a filter in SAP Web Ide is performed under

A

Tool->preference->data preview

It is on: the data preview is not execured immediately

Deferred Default Query execution

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
108
Q

Deferred Default Query execution

A

When the user wants to apply additional criteria
When the user wants to execute a custom query derived from the standard data preview

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
109
Q

What is an inner join

A

The Inner Join is the most basic of the join types. It returns rows when there is at least one match on both sides of the join.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
110
Q

Where is Full Outer Join supported by

A

calculation views only, in the standard and Star Join nodes.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
111
Q

What is a Full Outer Join

A

It combines the behaviours of the Left and Right Outer Joins.
The result set is composed of the following rows:
* Rows from both tables that match on joined columns
* Rows from the left table with no match in the right table
* Rows from the right table with no match in the left table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
112
Q

The type of joins between the fact and dimension tables within the star schema can be defined in the Star Join node. The available joins are

A

1 Referential Join
2 Inner Join
3 Left Outer Join
4 Right Outer Join
5 Full Outer Join, with some specific restrictions (see above)
6 Text Join

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
113
Q

What is the SAP Hana specific joins

A
  1. Referential join
  2. Text join
  3. Temporal join
  4. Star join
  5. Spatial join
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
114
Q

How does the full outer join behave?

A

The behaviour is combining the left and outer joins
* Rows from both tables that match on joined columns
* Rows from the left table with no matching in the right table
* Rows from the right table with no matches in the left table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
115
Q

Where is the Full outer join defined

A

In the standard and star join nodes.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
116
Q

In a star join node a full outer join can be defined on one dimension cal view and this view must appear last in what join

A

the star join node

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
117
Q

A referential join is semantically an inner join that assumes that referential integrity is given,

A

meaning that the left table always has a matching entry in the right table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
118
Q

A referential join is performed only

A

if at least one field from the right table is requested

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
119
Q

If the cardinality is 1..1 or n..1. would the join be executed?

A

the join is not executed

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
120
Q

Text joins act as Left Outer joins and can be used with SAP tables only if

A

The language column - field (SPRAS) is present.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
121
Q

Temporal joins are only supported in the star join of calculation views of the type cube with star join. What should the join be defined as?

A

The join must be defined as inner

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
122
Q

Temporal conditions can be defined on columns of the following data types: 3

A
  • Timestamp
  • Date
  • Integer
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
123
Q

The star join in calculation views of the type Cube with star join is a node type, rather that a join type.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
124
Q

What is Join cardinality

A

The cardinality defines how data from two tables are related

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
125
Q

When does Multi-Join Priority Affect the Join Node Results

A
  • When all joins are Inner Joins, the result set is generally the same regardless of the join execution order.
  • With a mix of Inner and Left Outer Joins, the result set can vary based on the join execution order.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
126
Q

What is non equi join

A

SAP HANA cloud provides a type of join, called Non-Equi Join, where the join condition is not represented by an = (equal) operator

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
127
Q

Non equi join can be defined for the following types of joins

A
  • Inner
  • Left Outer
  • Right Outer
  • Full Outer
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
128
Q

What columns are involved in the Dynamic Join

A

Only the joined columns requested in the query are brought into context and play a part in the join execution

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
129
Q

What happened in a Dynamic Join when none of the joined columns are requested by the client query

A

you get a query runtime error

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
130
Q

Union node can be used to join data set with not matching structures

A

yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
131
Q

How many union approaches exist

A

standard and constant values

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
132
Q

What is standard union:

A

a standard union is where, for each target column in the union, there is always one source column that is mapped

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
133
Q

What is union with constant value

A

A union with constant values is where you provide a fixed value that is used to fill a target column where the data source cannot provide a mapped column.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
134
Q

What is the purpose of an aggregation node

A

The purpose of an Aggregation node is to apply aggregate functions to measures based on one or several attributes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
135
Q

What are the aggregated functions used in the graphical calculation views?

A

SUM (the default function), MIN, MAX, and COUNT.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
136
Q

What are the additional aggregate functions in SAP HANA Cloud that can be applied to the calculation views:

A
  • Average
  • Variance
  • Standard deviation
  • Median
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
137
Q

In an Aggregation node, a calculated column is always computed AFTER the aggregate functions.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
138
Q

What are node features helping to control the aggregation nodes

A
  • Keep Flag
  • Transparent Filter
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
139
Q

Setting the Keep Flag property to true for a source field column forces

A

the calculation to be triggered at the relevant level of granularity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
140
Q

Set transparent filter is needed when

A

When using stacked views where the lower views have distinct count measures.
When queries executed on the upper calculation view contain filters on
columns that are not projected.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
141
Q

What is the purpose of rank node

A

The purpose of the Rank node is to enable the selection, within a data set, of the top or bottom 1, 2, … n values for a defined measure, and to output these measures together with the corresponding attributes and, if needed, other measures.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
142
Q

When there is a need to combine measures from two tables, there is the tendency to create a join. This practise is very expensive. It is more beneficial to use a union node.

A

A union is not a join.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
143
Q

What are the Calculated columns?

A
  • The calculation can be arithmetic or just character string manipulation
  • Cal column also support non measure attributes as part of the calculation
  • It is possible to nest cal columns so that on cal column can be used in other cal columns
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
144
Q

The purpose of these time based dimension cal views

A

is to ease the manipulation of measures across time.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
145
Q

What are the calendars available for time cal views

A
  • Gregorian: This is made up of years, months, and days.
  • Fiscal: this is organised into fiscal years and fiscal periods
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
146
Q

What is the name of the table populated for the Gregorian calendar?

A

M_TIME_DIMENSION

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
147
Q

What is the name of the table populated for the fiscal calendar

A

M_FISCAL_CALENDAR

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
148
Q

Which schema holds the tables M_TIME_DIMENSION and M_FISCAL_CALENDAR

A

_SYS_BI

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
149
Q

Can a table be used several times in a cal view

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
150
Q

Alias name can be generated when adding the same table to a view.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
151
Q

Can the Alias name be modified

A

Yes, on the properties-> alias

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
152
Q

Aggregating data in a dimension calculation view would be like a “Select Distinct Statement”
In cal view measures can originate from several data sources, such as:

A
  • Several tables
  • information views
  • Table functions
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
153
Q

When a report tool request data from cal view, the speed of returning data depend on

A
  • Selected attributes and measures
  • Aggregate functions applied by the client query
  • Ordering defined on one or several columns
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
154
Q

Overview of the possible node types

A

Node type Use case
Projection To filter data or obtain a subset of required columns from a datasource
Aggregation To summarize measures by grouping them together by attribute columns values
Join To query data from two or more data sources
Union To combine the data from two data sources
Star join To join attributes to the very last node of a Cube with star join calculation
Rank To order the data for a set of partition columns and select only the top 3/4/…./n elements

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
155
Q

Can a dynamic join be used on one attribute only

A

No, it must be done in several attributes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
156
Q

Would you receive an error message if the calling query does not request a join dimension. The dynamic join is not activated.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
157
Q

The star join is always deployed with an aggregation node on top of it.
Can the star join in cal views supports the referential join type?

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
158
Q

When can the union node be utilised

A

When the multiple result set have identical structures

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
159
Q

Can the union node be utilised with more than two identical structures

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
160
Q

Standard union can be of two types

A
  • A standard union
  • A union with constant values
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
161
Q

What is a standard union

A

For each target object, there is one source column that is mapped.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
162
Q

Does Standard union must provide provide a source column for all fields

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
163
Q

What is Union with constant values.

A

This is similar to multiprovider in BW

164
Q

What is a standard union with constant values

A

This is when the system provide a constant value for a column with no datasource value.

165
Q

When can the standard union with constant values can be utilised

A

This will depend on the data and the way the uses want to report.

166
Q

When Auto map can be used?

A

when the names of the data sources are similar

167
Q

Selected a data source first before triggering the auto map by name is useful when one or several other data sources have a lot of columns that you do not want to include in the output

A

True

168
Q

When none of the datasources can provide a value, the constant value is achieved by

A

First creating a column I the data target set
Assign a constant value for one data datasource and another value for another datasource. These values will populate the target column of the first step. This column can be used for aggregating, filtering and so on.

169
Q

How to set up the constant value

A

Right click the made column target and choose manage mapping and set the constant value.

170
Q

Empty union Behaviour; This is the case when there is a field from one datasource not used by the other data source. To alter the behaviour, this is the process:

A
  • Add a constant to the union output
  • Provide a constant value for each datasource with a suitable value that help you identify each source
  • Change the property empty union behaviour to “row with constant”
171
Q

Is the empty union behaviour subject to each data source

A

True

172
Q

What are these new nodes? Intersect and minus?

A

These operations are set on fields at runtime.

173
Q

What is the purpose of the aggregation node

A

This is needed for applying aggregate functions to measures based on one or several attributes.

174
Q

To what SQL function the aggregation node can be compared to

A

GROUP BY clause of SQL

175
Q

What functions can the aggregate node support in cal views

A

SUM, MIN, MAX, and COUNT

176
Q

What are the other additional. Functions supported by the aggregation node

A
  • Average
  • Variance
  • Standard Deviation
177
Q

When a cal column is processed in an aggregation node

A

After the aggregation node

178
Q

If there was a need to processed a cal column before aggregation, where should the cal column be processed?

A

In a projection before the aggregation node

179
Q

What features can control the aggregation node?

A

Keep flag and Transparent filter.

180
Q

What is the effect of setting Column – keep the flag = true

A

This forces the calculation to be performed at the lowest level of granularity.

181
Q

Setting the transparent filter = true is important on the following:

A

When using stack view where the lower views have distinct count measures
When queries executed on the upper cal view contain filters on columns that are not projected

182
Q

What are the steps for generating rank – cal view:

A
  1. Partition by column – Country
  2. Sort direction – order by “measure”, and threshold
  3. Generate rank column – “label the column to be produced” (aggregation function, target value and result set direction)
  4. Rank column is generated.
  5. Each row will be related to an individual value
183
Q

The source data set can be partitioned by one or several columns

A

True

184
Q

If you choose the Dynamic Partition Element, the columns listed in the Partition will be ignored if they are not requested by an upper node or top query

A

True

185
Q

What is dynamic partitioning element

A

Define whether the partition can be adjusted automatically based on the columns that are selected by an upper node or an upper view/query that you execute on top of the current one.

186
Q

What are the Rank node Aggregation Functions computing the row numbers?

A
  • Row
  • Rank
  • Dense Rank
187
Q

Does the sum function operate within the sorted columns

A

True

188
Q

What is the data lineage is for

A

This is used to track the origin of a column along the calculation scenario and down to the first node when it appears.

189
Q

The calculation engine pre-optimizes queries before they are worked on by the SQL optimizer.

A

True

190
Q

The calculation engine considers(3)

A

settings in cal views such as dynamic join,
join cardinality and
union node pruning.

191
Q

What happens during the instantiation process(Y)

A

the query and the original calculation model are combined to build the optimized, execution calculation model.

192
Q

What can be done to improve cal view performance

A
  • Break down large models into individual calculation views so that they are easier to understand and also allow you to define reusable components, thus avoiding redundancy and duplicated maintenance as a consequence.
  • Try to develop calculation views in layers so that each layer consumes the lower layers.
193
Q

What is unfolding

A

At run time, your calculation view is analyzed by the SQL processor. A key aim is to convert each calculation view operation into a corresponding SQL operator to convert the complete data flow graph into a single SQL statement.

194
Q

A complete unfolded query access only tables

A

True

195
Q

If a column view is used as a data source instead of a table, then you know this is not an unfolded query as the result has been materialized as an interim view and not read directly from a table.

A

True

196
Q

Switch Calculation View Expressions to SQL.

A

True

197
Q

Why is SQL language preferred to column engine

A

Column Engine language limits query unfolding.

198
Q

Column language is not available in SAP Hana Cloud

A

True

199
Q

Try to avoid filters on cal columns

A

True

200
Q

Calculate as high as you can in the stack so that you avoid calculating on granular data and instead calculate on aggregated data.

A

True

201
Q

There are many reasons for table partitioning, as follows(LbPaPrO)

A

Load balancing in a distributed system.
Parallelization.
Pruning to improve query performance.
Overcoming the size of column store tables

202
Q

Cache can only be used for calculation views that do not check for analytic privileges

A

True

203
Q

In order to use the calculation view static cache there are some important prerequisites that must be met:

A
  • Enable cache is selected
  • Cal view can be unfolded
  • No granularity tracking that prevent cache use
204
Q

What feature can be used with the SQL Analyzer to check if unfolding can occur

A

Explain plan

205
Q

The parallelization block always starts with a node that includes a data source that must be a table.

A

True

206
Q

You can use a table defined in the local container or a synonym which points to an external table. You cannot use another calculation view as the data source or a table function.

A

True

207
Q

What are the prerequisites for join pruning

A
  • No field is requested from the to be prune table.
  • The join type is outer, referential or text.
  • The join cardinality is either “…1” for the to be prune table or only measures with count distinct aggregation or no measures at all requested.
208
Q

When the Optimize Join Columns option is active, pruning of join columns between two data sources, A and B, occurs when all four following conditions are met:

A
  • The join type is Outer, Referential, or Text (actually, the calculation view cannot be built if join type is Inner).
  • Only columns from one join partner, A, are requested.
  • The join column from A is NOT requested by the query.
  • The cardinality on B side (the side of the join partner from which no column is requested) is :1.
209
Q

There are three approaches to implementing pruning rules in unions:

A
  • Two of these approaches are based on column values and
  • One is based on column names.
210
Q

What is explicit pruning

A

Explicit pruning helps performance by avoiding access to data sources that are not needed by the query.

211
Q

What is implicit pruning?

A

Implicit pruning is implemented by defining one or more pruning rules in a dedicated table called the Pruning Configuration Table.

212
Q

Where does the Performance Analysis Mode is activated

A

From within the Cal view

213
Q

What are the artefacts included in the Performance Analysis:

A
  • The type of tables used (row or column)
  • Join types used (inner, outer, and so on)
  • Join cardinality of data sources selected (n:m and so on)
  • Whether tables are partitioned and also how the partitions are defined and how many records each partition contains
214
Q

The Performance Analysis Mode produces the following warnings:

A
  • The size of tables with clear warnings highlighting the very large tables
  • Missing cardinalities or cardinalities that do not align with the current data set
  • Joins based on calculated columns.
  • Restricted columns based on calculated columns.
215
Q

What is the primary objective of join pruning

A

To improve the performance of a calculation view

216
Q

What are union pruning approaches?

A
  • Column based pruning
  • Explicit pruning using constants
  • Implicit pruning with a configuration table
217
Q

It is best practice to avoid stacking calculation views and instead, try to include all logic within one calculation view.

A

True

218
Q

What is the benefit of configuring static cache

A

Improve calculation view performance

219
Q

How many parallelization blocks can you have in a calculation view

A

1

220
Q

To work with calculation view Debug Query Mode, you first need to deploy the calculation view?

A

True

221
Q

The following features are available for each node in the cal views(6)

A

Switching Node Types
Replacing a Data Source
Extract Semantics
Propagate to Semantics
Previewing the Output of Intermediate Nodes
Map Input Parameters between nodes

222
Q

Two features are available in the Business Application Studio to analyze modeling content within a project. These are

A
  • Data lineage
  • Impact analysis
223
Q

What is the purpose of impact analysis:

A

The purpose of impact analysis is to show all the chain of calculation views that depend on a given calculation view

224
Q

The Where-Used feature supports the following objects

A
  • Input Parameters
  • Calculated Columns
  • Restricted Columns
225
Q

What is BAS – work space?

A

A workspace in SAP Business Application Studio is a file structure where you can work on one or several projects. Each user has their own workspace, and can create additional ones if needed

226
Q

Main Database Artifacts Defined in a HDB Module

A
  • Tables
  • Calculation views
  • Functions
  • Procedures
  • Analytic privileges
  • Synonyms
227
Q

What is the structure for naming a calculation view in the HDB

A

<Namespace>::<Runtime>
</Runtime></Namespace>

228
Q

The following 4 rules apply to the namespace:

A
  • The namespace is optional. Some objects can be defined with a namespace in their identifier, and others without.
  • A HDB module can have no namespace defined at all, or can specify any number of different namespaces.
  • The namespace is always identical for all the design-time objects stored in the same folder.
  • The namespace must always be explicitly mentioned inside the design-time files, and must correspond to the namespace defined explicitly in the containing folder, or implicitly cascaded from the parent folder(s).
229
Q

Key Properties of HDI Containers

A
  • A container is created automatically when you deploy your database module for the first time.
  • A container generates a database schema the moment a container is first created.
  • Database objects are deployed into that schema.
  • Source file definitions must be written in a schema-free way.
  • Direct references to objects outside your container are not allowed. You must use synonyms.
230
Q

A deploy operation can be executed at the following levels of a project structure:

A
  • An entire HDB module
  • A sub-folder of the HDB module
  • One or several individual objects
231
Q

Corresponding to the export, you can either import an individual file or a .zip or .tar archive. Three features are available for that:

A
  • Drag and drop from your file system into the Explorer view. Archives such as .zip and .tar files are not extracted. This can be done in command line in a Terminal window.
  • Upload Files (from the File menu) and Explorer view context menu. Archives are not extracted.
  • Import files (from the Welcome page). Archives will be extracted.
232
Q

What are the main Rules for a Consistent Management of Modeling Content Files

A
  • In an entire HDB module, the definition of a given runtime object (<namespace>::<object_name>) cannot be provided more than once.</object_name></namespace>
  • The namespace defined in the design-time file of a database object must correspond to the namespace setting applied to the folder in which it is located
  • A deploy operation always checks the end-to-end dependency between modeling content across all the HDB module, but only deploys the design-time files you have selected for the deploy operation.
  • During a deploy operation, the checks apply to all the runtime objects that are already built, and all the objects included in the deploy scope (that is, in case of a partial deploy, the design-time files you have selected).
233
Q

By default, a container has full access to all the database objects it contains (tables, calculation views, and so on), but has no access at all to other database schemas, whether it is another container’s schema or a classic database schema.

A

True

234
Q

Before we describe the .hdbgrants file, we need to describe two types of user that are referenced in the file.

A
  • Object Owner - when a database artifact is deployed to a database container, it is owned by the technical user of the container and not the developer who created the source file. Only the object owner can alter and drop the object. During deployment, the object owner must have privileges to access any external objects that have been referencing in a calculation view.
  • Application User - Any ‘real’ (not technical) user (for example, a reporting user) who accesses the calculation view must have privileges to also access the external objects that are referenced. These privileges might be different (probably more restricted) than the object owner privileges.
235
Q

When defining a synonym there are three key parameters

A
  • Name of synonym - you will refer to this name whenever you need to access the target object
  • Object - the actual object in the target schema, such as a table name
  • Schema - where the target object is found
236
Q

The SAP HANA Deployment Infrastructure (HDI) relies on a strong isolation of containers and a schema-free definition of all the modeling artifacts.

A

True

237
Q

These are the steps for creating User Provided Service

A

You simply choose the name of the service and a user id and password that has privileges to all external objects that you wish to access through the service.
These privileges in turn will be granted by this service user, to the container’s technical user and application users using a .hdbgrants file.

238
Q

Privileges will be granted to the user via

A

hdbgrants file

239
Q

The Schema Central Master Data contains the table PROSPECTS. What is the process to grant access to objects from another schema?

A

Database Explorer – SQL console

Create user Üser_provided_Service password “Just4fun_135” no force first password change;

Create role “externalaccess_rolefor OO”; Person creating the cal views
Create role “externalaccess_rolefor AP”; - Perso accessing Cal views of the Object owner

Grant select on schema central_master_data to “externalaccess_rolefor_OO WITH GRANT OPTION

Grant select on schema central_master_data to “externalaccess_rolefor_AP WITH GRANT OPTION

240
Q

What are the two types of users

A
  • Object Owner - when a database artifact is deployed to a database container, it is owned by the technical user of the container and not the developer who created the source file. Only the object owner can alter and drop the object. During deployment, the object owner must have privileges to access any external objects that have been referencing in a calculation view.
  • Application User - Any ‘real’ (not technical) user (for example, a reporting user) who accesses the calculation view must have privileges to also access the external objects that are referenced. These privileges might be different (probably more restricted) than the object owner privileges.
241
Q

The user-provided service’s user has all privileges required to access all external objects. Technically, it would be possible to grant all the database privileges of the service user to the object owner and application user.

A

True

242
Q

The final step in the setup of external schema access, is to create synonyms that point to the target objects of the external schema. The synonyms declaration is done in a .hdbsynonym file. This file type can be edited either with the text editor, as in the example below, or a dedicated synonym editor.

A

True

243
Q

There are three key parameters When defining a synonym

A
  • Name of synonym - you will refer to this name whenever you need to access the target object
  • Object - the actual object in the target schema, such as a table name
  • Schema - where the target object is found.
244
Q

When you need to access data from another HDI container, the setup is relatively similar to what you have just learned for an external (classic) database schema. Let’s point out the main differences:

A
  • There is no need for a user-provided service if the external container service is running in the same space as the one your project is assigned to.
    You can add the external HDI container service to your project (which automatically adds it to the mta.yamlfile.
  • You must create roles inside the external container that contain the relevant privileges to all objects that could be accessed by the service.
  • The .hdbgrants file does not refer to database object privileges of the technical user assigned to the user-provided service, but to the dedicated roles created inside the external container (see the previous point).
245
Q

What are the benefits of using GIT - version control system

A
  • Source code backup
  • A complete change history
  • Branching and merging capabilities
  • Traceability (for example, connecting a change to project management software)
246
Q

What is git

A

Git is a Distributed Version Control System (D-VCS) used to manage source code in software development.

247
Q

When you work with files locally in Git, this involves three major “logical” areas.

A
  • The Working Directory
  • The Staging Area, also known as INDEX.
  • The (local) Git Repository
248
Q

What is INDEX - GIT context

A

the staging area is the “virtual” place where you put all the modifications that you want to include in your next commit.

249
Q

What is a branch

A

From a conceptual standpoint, a branch is a series of commits. Technically, a branch is just a pointer that references a particular commit of the project history.

250
Q

What is the name of the default branch

A

master

251
Q

What is PAT

A

Personnel Access Token

252
Q

PAT - Then, for each file, you have the following possibilities

A
  • Stage the modification so that it will be included in the next commit
  • Leave the modification unstaged (it will not be included in the next commit)
  • Discard the change
    Staging or discarding can also be done for the entire set of modifications.
253
Q

You must not amend commits that have been shared with other developers, because this would modify a (shared) history on which others might have already based their work.

A

True

254
Q

Does the developer need to have a developer role in the target space when deploying an application.

A

False

255
Q

What are the steps for importing MTA from Dev to Q/A

A
  1. Build the HDB module(s).
  2. Build the entire Project in order to generate an MTA archive file (.mtar).
  3. Export the MTA archive.
  4. Deploy the MTA archive to the target landscape
256
Q

Why do you set the deprecate flag in a calculation view

A

To provide a warning to the developer suggesting they should not use the calculation view.

257
Q

Which type of semantics can you extract using the optionExtract Semantics

A

Column labels and hierarchies

258
Q

What is the type of file that is generated when you deploy a complete application

A

MTAR

259
Q

The name of the schema that corresponds to a container is generated and cannot be changed.

A

False

260
Q

Which database artifact do you define to access external schema objects

A

Synonym

261
Q

Git is used to automate the deployment of runtime objects in SAP HANA Cloud

A

False

262
Q

A runtime object in a container must always have a corresponding source file

A

True

263
Q

In a project structure, which of these appears directly beneath the project

A

Module

264
Q

What are analytic privileges

A

Analytic privileges are used to enable data access in calculation views, by filtering the data based on the values of one or more attributes.

265
Q

How to create and assign an Analytic Privilege

A
  1. Create a source file with the extension .hdbanalyticprivilege.
  2. Assign the calculation view(s) that you want to secure with this analytic privilege.
  3. Choose the type of restrictions you want to use and define the restrictions.
  4. Set the secured calculation views to check analytic privileges.
  5. Deploy the analytic privilege.
  6. Assign the analytic privilege to a role.
  7. Assign the role to a user.
266
Q

Restriction types in analytical privileges(SDA)

A
  • Attribute
  • SQL expressions
  • Dynamic
267
Q

Only columns of type Attribute (NOT Measure) can be specified in dimension restrictions.

A

True

268
Q

For each calculation view, the following criteria are considered

A
  • Does the user have SELECT privilege on the column view (this is the actual database object generated from a calculation view) in the container schema?
  • Does the calculation view check analytic privileges?
  • Is the user granted analytic privileges for the view?
269
Q

SELECT privilege is only required for the top view of a view hierarchy

A

True

270
Q

The key rules that govern the access to data are, as follows:

A
  • Object privileges
    There is no need to grant SELECT privileges on the underlying views or tables. The end user only needs to be granted SELECT privileges on the top column view of the view hierarchy.
  • Analytic Privileges
    The analytic privileges logic is applied through all the view hierarchy.
    Whenever the view hierarchy contains at least one view that is checked for analytic privileges but for which the end user has no analytic privilege, no data is retrieved (not authorized).
271
Q

Privilege assigns to role or user

A

True

272
Q

User owns an object.

A

True

273
Q

Assigning a privilege directly to a user is not a good practice and creates a lot of maintenance.

A

True

274
Q

Some key points regarding security concepts of SAP HANA Cloud:

A
  • All the privileges granted directly or indirectly to a user are combined.
    Whenever a user tries to access an object, the system performs an authorization check based on the user’s roles and directly allocated privileges (if any).
  • It is not possible to explicitly deny privileges, all privileges grant access.
    The system does not need to check all the users roles. As soon as all the privileges required for a specific operation on a specific object have been found, the system ends the check and allows the operation without checking if the same privileges appears again in another role.
  • Several predefined roles exist in the SAP HANA Cloud database.
    Some of them are templates (and need to be customized), and others can be used as they are.
275
Q

In the SAP HANA Cloud database, there are two ways to create roles:

A
  • As pure run-time objects (with no source file) that are created using SQL or SAP HANA Cockpit. These are called Catalog Roles. You assign privileges to these roles using SQL grant statements.
  • By means of source files that you create in the HDB module of a project. There are called Design-Time Roles and the source file describes the privileges that are immediately granted when the role is deployed.
    The design-time files used to create roles must have the extension .hdbrole in order to be recognized as design-time role files.
276
Q

The design time role(ROSAS - 5) can include

A
  • Role
  • Object privilege
  • Schema privileges
  • Analytic privileges
  • System privileges
277
Q

The .hdbrole file cannot contain references to real schema names, but only logical references to schemas that are resolved in another type of design-time file: the .hdbroleconfig file

A

True

278
Q

When creating calculation views, the main authorization you need is a SELECT privilege on the data sources.

A

True

279
Q

The <filename>.hdbgrants file is structured into three levels</filename>

A
  1. The name of the user-provided service
  2. The users to whom the privileges are granted
    There are two possible “values” for users:
    • object_owner is the technical user that owns all the objects of the container schema.
    • application_user represent the users who are bound to the application modules.
  3. The set of privileges granted
    The syntax of this third level is very similar to the syntax of what you find in a .hdbrole file.
280
Q

A mask expression is defined in a calculation view as follows

A
  1. In the Semantics node choose the Columns tab.
  2. Select a column and choose the Data Masking icon in the toolbar
  3. Define the masking expression using SQL
281
Q

Only columns of certain data types can be masked in a calculation view

A
  • VARCHAR
  • NVARCHAR
  • CHAR
  • SHORTTEXT
282
Q

Masking is supported for both table types (ROW tables and COLUMN tables).

A

True

283
Q

From SAP HANA Cloud QRC 4/2021 onwards, two different mask modes are available

A
  • Default
    Masking is done based on the user calling the calculation view with the masking definition.
  • Session User (new)
    Masking is done based on session user running the SQL query
284
Q

What is a dynamic analytic privilege

A

A reusable analytic privilege that can be used for several users who need to access different data

285
Q

What is data masking

A

Obscuring column values by hiding some or all characters with replacement characters

286
Q

Which approach is recommended to create roles that grant privileges to access local objects generated in your container

A

Design-time Roles

287
Q

Can SAP Hana Cloud support data tiering

A

True

288
Q

Can SAP Hana Cloud be connected to on premise system

A

True

289
Q

What are the use cases of SAP Hana Cloud(4)

A

1 To provide the DB for next generation applications that requires super fast performance
2 To power data warehouse including SAP Data Warehouse Cloud and custom data warehouses
3 To extend the data storage and processing capacities of on premise applications
4 To extend the functionality of existing SAP applications using cloud based services

290
Q

What are the main differences between SAP Hana on-premise and SAP Hana Cloud in terms of infrastructure?

A
  • No software installation, patch, back up, tune monitor, start/stop process
  • No OS selection
  • Hardware
291
Q

Which tools are commonly used in SAP Hana on-premise and SAP Hana Cloud?

A
  • SAP Hana Cockpit
  • SAP Hana Database Explorer
  • SAP Hana Web IDE
292
Q

What is the main tool introduced on SAP Hana Cloud to manage development

A

BAS

293
Q

What are some features not available in SAP Hana Cloud yet present in SAP Hana on-premise?

A
  • SDQ
  • Text Analysis and mining
  • XS- XSA
  • Multitenancy
  • SAP Data Warehousing foundation
  • SAP Streaming Analysis
294
Q

What are the new SAP Hana Cloud data types

A
  • Spatial: floor plans, coordinates, geographic positions, maps and Engineering diagrams
  • Graph: social networks and supply chains, etc
295
Q

Can SAP Hana Cloud managed the following data types:
* Enterprise systems
* Data warehouses
* Archives
* Big data
* Files stores
* DBs
* Social networks

A

True

296
Q

Which types of data can SAP HANA Cloud store and process

A
  • Spatial
  • Text
  • Structured
  • Graph
297
Q

Why can’t IT develop next-generation applications using their existing technology

A
  • It is difficult to manage increasing data growth
  • Legacy applications have become difficult to extend
  • Current landscapes have become too complex
298
Q

What is SAP HANA Cloud

A

A fully-managed, cloud data platform which includes an in-memory database and data lake

299
Q

Which new development approaches are supported by SAP HANA Cloud

A
  • Push-down of data processing to the database
  • No need to calculate and store pre-aggregated data
300
Q

Which recent technology advances present organizations with the opportunity to build innovative applications? 3

A
  • Data science is more accessible
  • New types of data available
  • Cloud computing
301
Q

Why might customers choose to implement SAP HANA Cloud versus SAP HANA on-premise

A
  • Reduced administration effort on customer side
  • Easy to scale
  • Fast deployment
302
Q

When is compression applied to the SAP Hana Cloud DB

A

During delta merger

303
Q

Who is responsible for deployment and monitoring the SAP Hana Cloud service

A

SAP Hana Administrator.

304
Q

What is the main tool used for monitoring the SAP Hana Cloud Db

A

SAP Hana Cockpit

305
Q

What are the key roles of an SAP Hana Cloud Implementation

A
  • The administrator role
  • Modeler role
  • Application Developer role
  • Security Architect role
  • Data Architect role
306
Q

Was SAP Hana Cloud developed from scratch

A

True

307
Q

What were the cloud design principles considered when designing SAP Hana Cloud

A

Elasticity and fast deployment

308
Q

What is dictionary encoding

A

It is a first level compression technique and is applied to all columns of a column store table

309
Q

What does Second compression level include:

A
  • run-length encoding,
  • cluster encoding, and
  • prefix encoding.
310
Q

Is compression relevant to row store tables

A

False

311
Q

What are some benefits of SAP HANA Cloud data compression

A
  • Fit entire enterprise databases into memory and avoid disk access
  • Get more data into CPU cache and therefore reduce main memory access
312
Q

What are advantages of column store tables versus row store tables

A
  • Data footprint is automatically reduced through compression.
  • Only the columns required for processing are actually loaded to memory.
  • Columns can be partitioned to improve performance.
313
Q

What is the purpose of the delta-merge in SAP HANA Cloud

A

To maintain good read performance of column tables following record updates

314
Q

Which hardware technology improvements does SAP HANA Cloud exploit to maximize performance

A
  • Larger memory sizes
  • Multi-core CPUs
315
Q

What is an entitlement

A

The service plan bought

316
Q

What is Quota

A

The size of memory and service attached to the quota

317
Q

At what level the entitlement and quota are bought

A

Global account

318
Q

Are Sub accounts independent from each other

A

True

319
Q

What is provisioning in terms of BTP

A

Creating an SAP Hana Cloud instance

320
Q

What must be created first before creating an SAP Hana Cloud instance

A

Cloud Foundry Space

321
Q

What are the key areas monitored in SAP Hana Cockpit (SMAWTD)

A
  • Services
  • Memory
  • Alerts
  • Workload
  • Table usage
  • Database Configuration
322
Q

What is SAP Hana Cloud Central used for?

A

Provision and manage instances

323
Q

What is key tool used by the administrator of SAP HANA Cloud for monitoring

A

the SAP HANA Cockpit.

324
Q

What are the key areas of SAP HANA Cloud that can be managed and monitored using the SAP HANA Cockpit:

A
  • Services - database services such as indexserver, nameserver.
  • Memory - monitor memory usage and check out-of-memory issues
  • Alerts - be warned of critical situation such as disk becoming full
  • Workload - organise jobs into workloads for better system utilization
  • Table Usage - ensure tables are optimally designed for best performance
  • Database Configuration - manage configuration (*.ini) files that determine database behaviour
  • Manage users and roles
  • Manage SDI
325
Q

Where can the SAP HANA cockpit be accessed from(3)

A

SAP HANA Cloud Central,
SAP BTP Cockpit, or
by using the direct URL

326
Q

Is the SAP HANA Cockpit used to manage only SAP HANA Cloud databases

A

True

327
Q

What are two CLI commands available used with SAP Hana Cloud

A

Setup and administrator

328
Q

What can be created with BTP CLI

A
  • Subaccounts and directories
  • Managing entitlements of global accounts and subaccounts
  • Managing users and their authorizations in global accounts and subaccounts
  • Subscribing to applications
329
Q

What can be performed by CF CLI:

A
  • Create spaces
  • Add organizations members
  • Add Space
  • Create Spaces quota plans
  • Assign Quotas plans to Spaces
330
Q

What is the main use of SAP Hana Database Explorer?

A

It is used for query information about the DB and display info about DB’s catalogue objects of the SAP Hana Db

331
Q

Can the Database Explorer be used with both HDI containers and classic schemas

A

True

332
Q

Where can the SAP HANA Cloud Cockpit be accessed from

A

It is located under Database Administration > HDI Administration.

333
Q

Where can the SAP Hana Db Explorer be accessed from

A

SAP Hana Cockpit or BAS

334
Q

Why the SAP Hana Cloud could be start/stop

A
  • Adding Data Lake
  • Scale up the DB to add more RAM
  • Maintenance or the application that is running on the DB
  • Take the DB offline to prevent unwanted updates
  • Cloud provider support team suggests a restart after troubleshooting
335
Q

What are the functions of SAP Hana Cloud Administrator (WMUSSM)

A
  • Work load management
  • Manage data tiers
  • Utilise resource to fix issues
  • Set up alerts
  • Set up administrative tasks
  • Managing tables
336
Q

What are the security tasks of the SAP Hana Cloud administrator (MDAMM)

A
  • Monitor critical security settings
  • Data encryption
  • Auditing activities
  • Manage certificates & keys
  • Monitors data anonymization
337
Q

What are the administration tasks of the admin person

A
  • Creating users, user groups and assigning roles and privileges
  • Investigating authorization or authentication issues
  • Deactivating users
338
Q

What is the setup sequence for managing users, roles and permissions

A

1 Create privileges (many standard privileges are supplied by SAP)
2 Create roles
3 Assign privileges to roles
4 Create users
5 Create user groups
6 Assign users to user groups
7 Assign users to roles

339
Q

Why do you use SAP HANA Cloud Central tool?

A

To start and stop an SAP HANA Cloud database instance.

340
Q

Before you can create an SAP HANA Cloud database instance, what must you already have done

A
  • Enabled Cloud Foundry environment for the sub account
  • Assigned quota to the sub account
  • Created a Cloud Foundry space in the sub account
341
Q

What are the main types of calculation views

A
  • Dimension
  • Cube
  • Cube with star join
342
Q

What data modeling artifacts can be created in Business Application Studio:

A
  • Calculation Views
  • Procedures
  • Table and Scalar Functions
  • Flowgraphs
  • Analytic Privileges
  • Local and Virtual Tables
  • Replication Tasks
343
Q

In what language are BAS artefacts store and encoded

A

JSON or XML

344
Q

Are table functions read only

A

True

345
Q

Where can a procedure be call

A
  • SQlScript
  • Function, and
  • Another procedure
346
Q

Procedures used within modeling must be set to read-only

A

True

347
Q

What is stateless

A

A procedure set to read only

348
Q

What is stateful

A

A procedure used for update, insert and delete. They cannot be called from a cal view.

349
Q

There are some levels of access to consider when securing Cal Views(4)

A
  • SQL select objects on tables
  • Analytics privileges restricts access to rows
  • Access to specific columns – create views and grant select to the views
  • Masking characters in columns such as telephone, salary figures, etc
350
Q

Can Procedures be used as datasources

A

False

351
Q

Can stateful procedures be call from Cal Views

A

False

352
Q

Can stateful procedures be call from Cal Views

A

False

353
Q

Access to specific rows can be achieved via which security tool

A

Analytic privilege

354
Q

Access to specific tables can be restricted via which artefact

A

Select

355
Q

How to grant access to specific columns

A

By creating a view with a subset of columns and granting SELECT only on this view.

356
Q

Can data masking blur the entire content of a column

A

True

357
Q

What are the data type SAP spatial provide for storing geometrical data

A

Points. Lines and polygons.

358
Q

What spatial query functions are included in SQLScript in SAP Hana Cloud

A

Within
Distance
Crosses

359
Q

SAP Hana Cloud provides two libraries for predictive analysis

A

PAL – Predictive Analysis
APL – Automated Predictive Library

360
Q

Does Pal (Predictive Analysis Library) require special knowledges of algorithms

A

True

361
Q

Does APl (Automated Predictive Library) require special knowledges of algorithms

A

False

362
Q

What are the data mining pre-processing tasks included in PAL

A
  • Sampling
  • Binning
  • Partitioning
363
Q

What are the algorithms for data mining categories included in the PAL (ACCRTN)

A

1 Association
2 Classification
3 Clustering
4 Regression
5 Time Series
6 Neural Networks

364
Q

Why do we model in SAP HANA

A
  • To push data-intensive processing away from the application and to the database.
  • To develop reusable data processing logic in the database.
365
Q

Which type of advanced model should you create if you wanted to explore business entities that are highly networked

A

Graph

366
Q

What are the SAP BTP environments offered to the public

A
  • Cloud Foundry
  • ABAP
  • Kyma
367
Q

Is Cloud Foundry environment open platform as service (PaaS)

A

True

368
Q

What are the benefits of Cloud Foundry(LACO)

A
  • Language independent
  • Administration separation
  • CLI
  • Opensource
369
Q

What is CAPM (TOLALIAP)

A

It is a framework of tools, languages, libraries and APIs that combine open source and SAP provided tools and technologies

370
Q

What are the main elements making up SAP CAPM

A
  • Sap Fiori
  • Java/Node.JS
  • SAP Hana
  • CDS
371
Q

What is CDS used for within the CAP CAPM environment

A

To create physical layer (data types and tables)
To create Virtual layer (view, etc)

372
Q

CAP create native HANA Cloud database artefacts such as tables, views and functions and mix them with CDS artefacts

A

True

373
Q

The recommended tool for developing CAP applications is Business Application Studio

A

True

374
Q

What are the SAP HANA Cloud service plans for managing database artifacts

A
  • Schema service plan
  • HANA Deployment Infrastructure (HDI) Shared service plan
375
Q

What is GIT used for?

A
  • Back up of source code
  • Provide change history of source code
  • Provide branching and merging capabilities
  • Traceability and audit
376
Q

When a developer is satisfied that their content is ready. They commit one but more often multiple relates source files to the git

A

True

377
Q

What are the components of the SAP Hana Database explorer(5):

A
  • A catalog Browser
  • An SQL console
  • An SQL analyser
  • An SQL Analyze
  • An SQL debugger
378
Q

Where can the database explorer be launched

A
  • Business Application Studio
  • SAP HANA Cockpit
  • SAP HANA Cloud Central
  • SAP BTP Cockpit
379
Q

In SAP BTP in CAPM OData services are automatically generated from CDS files that describe the OData model

A

True

380
Q

What is the backbone of SAP Cloud Application Programming Model

A

CDS

381
Q

What are the UI5 versions produced by SAP

A
  • OpenUI5 - Is the open source version, free to use, and released under the Apache 2.0 license. As well as specific SAP UI libraries, OpenUI5 uses many open source libraries. So SAP have chosen to make this version freely available for anyone to use. OpenUI5 can be freely downloaded from Github
  • SAPUI5 - Similar to OpenUI5 but includes many more libraries that render the UI for specific SAP features. SAPUI5 is already integrated with SAP HANA Cloud.
382
Q

What is OData

A

Open Data Protocol (OData) is a widely accepted protocol that is used to perform database-style create, read, update, and delete operations on resources by using HTTP.

383
Q

A development space provides all of the tools and resources needed for developing your application.

A

True

384
Q

Which environments does SAP BTP provided for developing SAP HANA Cloud applications

A
  • ABAP
  • Cloud Foundry
385
Q

What can you develop using SQLScript

A
  • Database functions
  • Stored procedures
386
Q

What is a must when important individual files

A

The command (tar / unzip) must be added.

387
Q

What are the Import files – Options

A
  • Import (Welcome page) Import project (right-click on blank area)
  • File → Upload Files
  • Drag and drop from your file explorer
388
Q

In SAP HANA Cloud, which tool is recommended for data modeling

A
  • BAS
389
Q

In a cube with star join calculation view, the Column tab of the Semantics node separates columns into two categories

A
  • Private, and
  • Shared
390
Q

In shared columns can the name and label be changed in al view

A

True

391
Q

What are the dimension types

A

standard and time

392
Q

What are valid data sources supported in SAP HANA Cloud calculation views.

A
  • Row Table
  • Column Table
  • Virtual Tables
  • Calculation Views
  • SQL Views
  • Table Functions
393
Q

A semantic type describes the specific meaning of each column and this can be helpful to any client that consumes the calculation view by enabling it to then represent the columns in the appropriate format

A

True

394
Q

What are the uses of the Semantics settings

A
  • Assigning a description column to another column - for example, assigning the product id column to a product description column so a user sees a value that is more meaningful.
  • Hiding a column - can be used if a column is only used in a calculation, or is an internal value that should not be shown, for example, hiding the unhelpful product id when we have assigned a description column that should be shown in its place.
  • Assigning a variable - allowing a user to select a filter value at runtime for the attribute
  • Change the aggregation type
395
Q

There are two ways to sort columns automatically

A
  • use the sort direction property (Semantics/Columns) and
  • use the sort result set dialog box (Semantic/column/Icon/ + to add columns and directions.
396
Q

How do you define the Null values

A
  • Select the Semantics node
  • Choose the Columns tab
  • Select a measure or attribute
  • Select the ‘Null Handling’ checkbox
  • Optionally, in the Default Value text field, provide a default value
397
Q

Calculation view properties are organized with four tabs what are they (GASS)

A

General, Advanced, Static Cache and Snapshots.

398
Q

What is the role of a dimension calculation view?

A

To generate a view of master data from one or more tables

399
Q

Which are supported data source types for calculation view consumption?

A
  • Cal Views
  • Virtual tables
  • Column tables
  • Row tables
400
Q

Why do you create a time-based dimension calculation view

A

To automatically generate time-related attributes from a base date

401
Q

What are the benefits of calculation views?

A
  • They calculate live data on-the-fly
  • They adapt automatically to the requesting query
402
Q

Why do you hide columns in a calculation view?

A

When you want to hide a column that is used in a calculation but is not required to display in a report.

403
Q

What is the role of the cube calculation view

A

To aggregate measures without the need for dimensions

404
Q

What is the name of the tool that is launched with Data Preview of a calculation view?

A

SAP HANA Database Explorer

405
Q

What is Projection node used for:

A
  1. To select only the required columns from a data source.
  2. To define calculated columns.
  3. To define parameters that request values at run-time, such as user-prompts.
  4. To apply a filter on the data source

SAP Hana Cloud (1 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions