SAP C_HANAIMP_18 Exam Practice Test Instant Access

Question 1

How can you define a variable that presents its value help hierarchically?Note: There are 2 correct answers to this question.

ACreate a parent-child hierarchy and assign it to the variable.Ensure the variable's reference column is the parent attribute of the hierarchy.

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

CCreate a parent-child hierarchy and assign it to the variable.Ensure the variable's reference column is the child attribute of the hierarchy.

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

Answer : B, C

Question 2

What is a restricted measure?

AA measure that cannot be referenced by a calculated column.

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

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

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

Answer : C

Question 3

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

ADescriptions of all objects defined in a calculation view

BAll settings defined in a calculation view

CDependencies between calculation views

DDocumentation to support the calculation view

Answer : A

Question 4

Referring to the diagram, which privileges would a user require to view United States data when querying the CUBE calculation view?

AA SELECT privilege on the CUBE calculation view and an Analytic Privilege (Country = United States) on the DIMENSION calculation view

BSELECT privileges and Analytic Privileges (Country = United States) on both views

CA SELECT privilege and an Analytic Privilege (Country = United States) on the DIMENSION calculation view

DA SELECT privilege and an Analytic Privilege (Country = United States) on the CUBE calculation view

Answer : A

Question 5

Which of the following data sources can you include in a graphical calculation view?Note: There are 2 correct answers to this question.

AProcedure

BRow table

CScalar function

DTable function

Answer : B, D

Question 6

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

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

BTo retain the correct aggregation behavior in stacked views

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

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

Answer : C

Question 7

Why would you set the "Ignore multiple outputs for filters" property in a calculation view?

ATo ensure semantic correctness

BTo force filters to apply at the lowest node

CTo hide columns that are not required

DTo avoid duplicate rows in the output

Answer : B

SAP C_HANAIMP_18 SAP Certified Application Associate - SAP HANA 2.0 SPS06 Exam Practice Test