Weekend Special Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: buysanta

Exact2Pass Menu

Question # 4

You are managing your source files using Git. In which sequence does your file progress towards a COMMIT?

A.

Staging area -> Working directory -> Local Git repository

B.

Working directory -> Staging area -> Local Git repository

C.

Working directory -> Local Git repository -> Staging area

D.

Local Git repository -> Staging area -> Working directory

Full Access
Question # 5

In Business Application Studio, you rename a DIMENSION calculation view that is used by a CUBE calculation 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 calculation view as a single object.Deploy the entire SAP HANA database module.What is the outcome of the deploy operations?

A.

The first deployment is successful.The second deployment fails.

B.

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

C.

The first deployment fails.The second deployment fails.

D.

The first deployment fails.The second deployment is successful.

Full Access
Question # 6

In a database module, what is the purpose of the .hdiconfig file?

A.

To specify an external schema in which calculation views will get their data

B.

To specify which HDI plug-ins are available

C.

To specify in which space the container should be deployed

D.

To specify the namespace rules applicable to the name of database objects

Full Access
Question # 7

Why would you use parameter mapping in a calculation view?Note: There are 2 correct answers to this question.

A.

To pass variable values to external value help views

B.

To assign variables to one or more attributes

C.

To push down filters to the lowest level calculation views

D.

To convert the data types of input parameters

Full Access
Question # 8

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

A.

Descriptions of all objects defined in a calculation view

B.

All settings defined in a calculation view

C.

Dependencies between calculation views

D.

Documentation to support the calculation view

Full Access
Question # 9

You want to ensure that your calculation 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.

Set the HIDE property for columns NOT required.

B.

Write and execute a custom SQL query in the SQL Console.

C.

Select Data Preview for the calculation view.

D.

Select and deselect columns from the output mapping.

Full Access
Question # 10

What is the default view node for a cube?

A.

PROJECTION

B.

SEMANTICS

C.

AGGREGATION

D.

UNION

Full Access
Question # 11

Why would you create SQL in calculation views?

A.

To implement custom logic

B.

To provide an alternative to graphical modeling

C.

To fine-tune performance

D.

To enable write capabilities

Full Access
Question # 12

You combine two customer master data tables with a union node in a calculation 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.

Define a restricted column in a union node.

B.

In the union node, map both source customer name columns to one target column.

C.

Add an intersect node above the union node.

D.

Include an aggregation node above the union node.

Full Access
Question # 13

What is a restricted measure?

A.

A measure that can be consumed by a CUBE and not a DIMENSION.

B.

A measure that is filtered by one or more attribute values.

C.

A measure that can only be displayed by those with necessary privileges.

D.

A measure that cannot be referenced by a calculated column.

Full Access
Question # 14

Why would you create calculation views of data category DIMENSION with type TIME?

A.

To provide additional time-related navigation possibilities

B.

To add a temporal condition to a join to find matching records from two tables based on a date

C.

To store historical versions of attributes

D.

To provide the time intervals required by time-dependent parent-child hierarchies

Full Access
Question # 15

What are the limitations of using a full outer join in a star join node?Note: There are 2 correct answers to this question.

A.

It must appear in the last DIMENSION in the star join node.

B.

It is restricted to one DIMENSION in a star join node.

C.

It CANNOT be mixed in the same star join node with other join types.

D.

Only one column can be included in the join condition.

Full Access
Question # 16

What are some of the typical tasks performed by the SAP HANA Cloud modeler role? Note: There are 2 correct answers to this question.

A.

Create graph workspaces

B.

Configure data tiering

C.

Develop calculation views

D.

Develop SAP Fiori apps

Full Access
Question # 17

Why would an SQL developer work with SQLScript?Note: There are 3 correct answers to this question.

A.

To automate the generation of the code

B.

To pass parameters from calculation views

C.

To exploit additional data types

D.

To include ABAP syntax in the code

E.

To implement conditional logic

Full Access
Question # 18

Why might you use the Keep Flag property in an aggregation node?

A.

To ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be overridden by a query

B.

To exclude columns that are NOT requested by a query to avoid incorrect results

C.

To include columns that are NOT requested by a query but are essential for the correct result

D.

To retain the correct aggregation behavior in stacked views

Full Access
Question # 19

A calculation 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?

A.

Use a union node.

B.

Use an intersect node.

C.

Use an aggregation node.

D.

Use a minus node

Full Access
Question # 20

Which calendar types can be selected when creating time-based DIMENSIONS?Note: There are 2 correct answers to this question.

A.

Fiscal

B.

Julian

C.

Gregorian

D.

Factory

Full Access
Question # 21

How can you define a variable that presents its value help hierarchically? Note: There are 2 correct

answers to this question.

A.

Create a level hierarchy and assign it to the variable. Ensure the variable's reference column is the top level of the hierarchy.

B.

Create a parent-child hierarchy and assign it to the variable.

Ensure the variable's reference column is the parent attribute of the hierarchy.

C.

Create a parent-child hierarchy and assign it to the variable.

Ensure the variable's reference column is the child attribute of the hierarchy.

D.

Create a level hierarchy and assign it to the variable.

Ensure the variable's reference column is the leaf level of the hierarchy.

Full Access
Question # 22

Why would you enable Debug Query mode in a calculation view?

A.

To identify data sources that are not accessed by a query

B.

To check which database engines are invoked

C.

To set breakpoints and step through the execution

D.

To understand how tables are partitioned

Full Access
Question # 23

You want to join two tables in a calculation view.Why do you use a non-equi join?

A.

Join columns have different data types.

B.

The number of joined columns is different in each table.

C.

Join columns need to be ignored when NOT requested by the query.

D.

The join condition is not represented by matching values.

Full Access
Question # 24

What are some best practices when developing calculation views? Note: There are 2 correct answers to this question.

A.

Model star schemas using a sequence of join nodes.

B.

Aggregate at the lowest possible node.

C.

Include all data flow logic within one calculation view.

D.

Avoid defining joins on calculated columns.

Full Access
Question # 25

You have imported calculation views from SAP HANA on-premise to SAP HANA Cloud.Why should you switch calculated column expression language from column engine to SQL?

A.

To benefit from additional SQL optimizations

B.

Incorrect aggregations may be generated

C.

Column engine language is not supported.

D.

To define limits for query unfolding

Full Access
Question # 26

Your calculation view consumes one data source, which includes the following columns: SALES_ORDER_ID, PRODUCT_ID, QUANTITY and PRICE.In the output, you want to see summarized data by PRODUCT_ID and a calculated column, PRODUCT_TOTAL, with the formula QUANTITY * PRICE.In which type of node do you define the calculation to display the correct result?

A.

Projection

B.

Join

C.

Union

D.

Aggregation

Full Access