Online Access Free C_HANAIMP_18 Practice Test

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

• A.To retain the correct aggregation behavior in stacked views
• B.To ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be overridden by a query
• C.To exclude columns that are NOT requested by a query to avoid incorrect results
• D.To include columns that are NOT requested by a query but are essential for the correct result

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.

In a calculation view, what is the purpose of a variable?

• A.To filter an attribute at run-time based on a user input
• B.To break up complex SQL into smaller steps
• C.To provide a dynamic value in a calculated column
• D.To pass values between procedures and calculation views

Which options do you have to handle orphan nodes in your hierarchy?Note: There are 2 correct answers to this question.

• A.Define an expression to determine a parent.
• B.Assign them to a node at the root level.
• C.Generate additional root nodes.
• D.Assign them to a level below the root.

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.Aggregation
• B.Union
• C.Join
• D.Projection