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

C_HANAIMP_18 Exam Dumps - SAP Certified Application Associate - SAP HANA 2.0 SPS06

Question # 4

You have made changes to the design-time files of several calculation views in your DEV environment. These calculation views all belong to the same project.Before deploying your calculation views to a PROD environment, which sequence of steps is required in the DEV environment?

A.

Build the project -> Build the HDB module

B.

Export the HDB module -> Export the project

C.

Activate the project -> Build the HDB module

D.

Build the HDB module -> Build the project

Full Access
Question # 5

You implement a referential join between Table A and Table B, but when you query the calculation view, Table B is not pruned.What could be the problem?

Note: There are 2 correct answers to this question.

A.

Join cardinality is set :1.

B.

The Country column is requested.

C.

Integrity constraint is set to RIGHT.

D.

The Keep flag is activated for the Customer column.

Full Access
Question # 6

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 a minus node.

C.

Use an intersect node.

D.

Use an aggregation node.

Full Access
Question # 7

You created a calculation view that combines two tables in a join node. To improve the runtime of your calculation view, you use a referential join to prune data sources.How do you check if pruning occurs?Note: There are 2 correct answers to this question.

A.

Use the SQL Analyzer to identify the tables used

B.

Enable Debug Query mode to identify the columns used

C.

Explore the number of used columns in the Performance Analysis mode

D.

Preview the data results in the calculation view

Full Access
Question # 8

What do you use in the definition of a dynamic SQL analytic privilege?

A.

An organization hierarchy that provides role-based access to data.

B.

A table function that returns a list of allowed values.

C.

A scalar function that returns a list of the allowed values for each attribute.

D.

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

Full Access
Question # 9

In a calculation view, why would you implement an SQL expression?Note: There are 3 correct answers to this question.

A.

To convert currencies

B.

To generate hierarchies

C.

To define a filter

D.

To generate a calculated column

E.

To generate a restricted column

Full Access
Question # 10

What is a restricted measure?

A.

A measure that cannot be referenced by a calculated column.

B.

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

C.

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

D.

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

Full Access
Question # 11

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

A.

Hint

B.

Placeholder

C.

Where

D.

Set

Full Access
Question # 12

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

A.

You selected the wrong parameter mapping TYPE.

B.

Your source calculation view is of type DIMENSION.

C.

The names of the input parameters do not match.

D.

You already mapped the input parameters in another calculation view.

Full Access