Online Access Free C_HANAIMP_18 Practice Test

What is a restricted measure?

• A.A measure that cannot be referenced by a calculated column.
• B.A measure that can be consumed by a CUBE and not a DIMENSION.
• C.A measure that is filtered by one or more attribute values.
• D.A measure that can only be displayed by those with necessary privileges.

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

• A.To ensure semantic correctness
• B.To force filters to apply at the lowest node
• C.To avoid duplicate rows in the output
• D.To hide columns that are not required

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

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.Integrity constraint is set to RIGHT.
• B.The Country column is requested.
• C.Join cardinality is set :1.
• D.The Keep flag is activated for the Customer column.

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 -> Local Git repository -> Staging area
• C.Working directory -> Staging area -> Local Git repository
• D.Local Git repository -> Staging area -> Working directory