Note! Following C_HANAIMP_18 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

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?

Build the project -> Build the HDB module

Export the HDB module -> Export the project

Activate the project -> Build the HDB module

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.

Join cardinality is set :1.

The Country column is requested.

Integrity constraint is set to RIGHT.

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?

Use a union node.

Use a minus node.

Use an intersect node.

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.

Use the SQL Analyzer to identify the tables used

Enable Debug Query mode to identify the columns used

Explore the number of used columns in the Performance Analysis mode

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?

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

A table function that returns a list of allowed values.

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

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.

To convert currencies

To generate hierarchies

To define a filter

To generate a calculated column

To generate a restricted column

Full Access

Question # 10

What is a restricted measure?

A measure that cannot be referenced by a calculated column.

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

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

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?

Hint

Placeholder

Where

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?