C-HCMOD-02 by SAP Valid Free Exam Practice Test

Question 1

You have configured static cache for your calculation view and run a query against it, but the cache results are not being used.What might be the reason for this?

A. You did not define any columns in the cache setting. B. The query requests only a subset of the cached results. C. The cache data retention period has expired. D. You did not define a filter in the cache setting.

Correct Answer: A

Question 2

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. Define a restricted column in a 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. Include an aggregation node above the union node.

Correct Answer: C

Question 3

Why would you use parameter mapping in a calculation view?Note: There are 2 correct answers to this question.

A. To convert the data types of input parameters B. To assign variables to one or more attributes C. To pass variable values to external value help views D. To push down filters to the lowest level calculation views

Correct Answer: C,D

Question 4

Which tool generates and executes the SQL for a specific node of your calculation view?

A. Explain plan B. Database explorer C. Debug Query mode D. SQL analyzer

Correct Answer: C

Question 5

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 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. B. 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. 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 6

Which project structure object corresponds to a unique HDI container?

A. space B. database module C. project D. src folder

Correct Answer: D

Question 7

In a database module, what is the purpose of the .hdiconfig file?

A. To specify the namespace rules applicable to the name of database objects B. To specify which HDI plug-ins are available C. To specify an external schema in which calculation views will get their data D. To specify in which space the container should be deployed

Correct Answer: B

Question 8

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

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

Correct Answer: D

Question 9

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

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

Correct Answer: B,C

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