SAP Certified Application Associate - SAP HANA Cloud Modeling - C_HCMOD

Question 1

You combine two customer master data tables with a union node in a calculation view. Both master data tables include the same customer name.How do you ensure that each customer name appears only once in the results?

A. Include an aggregation node above the union node. B. In the union node, map both source customer name columns to one target column. C. Add an intersect node above the union node. D. Define a restricted column in a union node.

Discussion 0

Correct Answer: C Vote an answer

Question 2

What is a restricted measure?

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

Discussion 0

Correct Answer: A Vote an answer

Question 3

What can you do with shared hierarchies? Note:There are 2 correct answers to this question.

A. Access hierarchies created in external schemas B. Provide reusable hierarchies for drilldown in a CUBE with star join C. Enable SQL SELECT statements to access hierarchies D. Provide reusable hierarchies for drilldown in a CUBE without star join

Discussion 0

Correct Answer: C,D Vote an answer

Question 4

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

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

Discussion 0

Correct Answer: B,D Vote an answer

Question 5

What are some best practices when developing calculation views? Note: There are 2 correct answers to this question.

A. Include all data flow logic within one calculation view. B. Model star schemas using a sequence of join nodes. C. Aggregate at the lowest possible node. D. Avoid defining joins on calculated columns.

Discussion 0

Correct Answer: A,D Vote an answer

Question 6

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

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

Discussion 0

Correct Answer: C Vote an answer

Question 7

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

Discussion 0

Correct Answer: D Vote an answer

Question 8

What are some of the typical roles in an SAP HANA Cloud implementation?Note: There are 2 correct answers to this question.

A. Data architect B. Kubernetes expert C. ABAP developer D. Modeler

Discussion 0

Correct Answer: A,D Vote an answer

Question 9

A calculation view includes a rank node that uses the source data and settings shown in the graphic.

Your query requests all columns of the rank node.How many rows are in the output of your query?

A. 6 B. 9 C. 2 D. 5

Discussion 0

Correct Answer: B Vote an answer

SAP Certified Application Associate - SAP HANA Cloud Modeling - C_HCMOD_02 FREE EXAM DUMPS QUESTIONS & ANSWERS