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

Question 1

Which are types of calculation views?
Note: There are 3 correct answers to this question

A. DIMENSION B. COMPOSITE C. SEMANTIC D. CUBE E. CUBE WITH STAR JOIN

Correct Answer: A,D,E

Question 2

What are the consequences of NOT executing a delta merge?Note: There are 2 correct answers to this question.

A. New records are not read. B. Read performance decreases. C. Memory is not optimized. D. Aggregates are not adjusted.

Correct Answer: A,B

Question 3

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 can only be displayed by those with necessary privileges. D. A measure that is filtered by one or more attribute values.

Correct Answer: D

Question 4

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

Correct Answer: C

Question 5

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 6

You are managing your source files using Git.
In which sequence does your file progress towards a COMMIT?

A. Working directory -> Local Git repository -> Staging area B. Local Git repository -> Staging area -> Working directory C. Working directory -> Staging area -> Local Git repository D. Staging area -> Working directory -> Local Git repository

Correct Answer: C

Question 7

You have generated a calculation view properties file.What does it contain?

A. Documentation to support the calculation view B. All settings defined in a calculation view C. Dependencies between calculation views D. Descriptions of all objects defined in a calculation view

Correct Answer: D

Question 8

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

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

Correct Answer: A,D

Question 9

You are deploying a new calculation view, A, that uses calculation view B, as shown in the diagram.

When you preview calculation view A, the account number is not masked.What could be the reason?

A. The UNMASKED privilege has NOT been granted at the schema level. B. The type of the Account_Number column is VARCHAR. C. You did not define masking in calculation view A. D. You previewed the data with the technical user in SAP Business Application Studio.

Correct Answer: A

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