C-HCMOD-03 Exam Training Practice Tests (SAP Certified Application Associate

Question 1

What can you identify using Performance Analysis mode?Note: There are 2 correct answers to this question.

A. Joins that are defined on calculated columns B. Information about join cardinality C. Usage statistics of the calculation view D. Expected memory consumption

Correct Answer: A,B

Question 2

Which solutions form the SAP Business Technology Platform? Note: There are 2 correct answers to this question.

A. Analytics B. Application Development & Integration C. Experience Management D. Intelligent Suite

Correct Answer: A,B

Question 3

You want to create a star schema using a calculation view. The measures are based on columns from two transaction tables. DIMENSION calculation views provide the attributes.What is the correct approach?

A. Combine the transaction tables using an aggregation node in a calculation view of type CUBE with star join./Use a star join node to join the DIMENSIONS to the fact table. B. Combine the transaction tables using a star join node in a calculation view of type CUBE with star join./Use a join node to join the DIMENSIONS to the fact table. C. Combine the transaction tables using a join node in a calculation view of type CUBE with star join.Use a star join node to join the DIMENSIONS to the fact table. D. Combine the transaction tables using a star join node in a calculation view of type CUBE with star join.Use the same star join node to connect the DIMENSIONS to the fact table.

Correct Answer: C

Question 4

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. The names of the input parameters do not match. B. You selected the wrong parameter mapping TYPE. C. You already mapped the input parameters in another calculation view. D. Your source calculation view is of type DIMENSION.

Correct Answer: C

Question 5

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

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

Correct Answer: D

Question 6

Why would you use the Transparent Filter property in a calculation view?

A. To allow filter push-down in stacked calculation views B. To avoid columns being unnecessarily used in an aggregation C. To include columns that are NOT requested by a query D. To apply filters that are hidden from the end user

Correct Answer: A

Question 7

You combine two tables in a join node using multiple columns in each table.Why do you enable the dynamic join option? Note: There are 2 correct answers to this question.

A. To allow data analysis at different levels of granularity with the same calculation view B. To ensure that the aggregation always happens after the join execution C. To force the calculation at the relevant level of granularity, even if this level is not the grouping level defined by the query D. To ensure that the join execution only uses the join columns requested in the query

Correct Answer: A,D

Question 8

When is the first column store compression executed?

A. When a backup is started B. When the table is created C. When a delta merge is triggered D. Question E. When partitions are regenerated

Correct Answer: C

Question 9

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

A. SET B. PLACEHOLDER C. WHERE D. HINT

Correct Answer: B

SAP Certified Application Associate - SAP HANA Cloud Modeling - C-HCMOD-03 Exam Practice Test