SAP Certified Application Associate - SAP HANA Cloud Modeling (C_HCMOD_01) Free Practice Test

Question 1

Which of the following approaches might improve the performance of joins in a CUBE calculation view?
Note: There are 2 correct answers to this question.

A. Determining join direction in a full outer join

B. Specifying the join cardinality

C. Using an inner join

D. Limiting the number of joined columns

Correct Answer: B,D

Question 2

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 -> Staging area -> Local Git repository

C. Local Git repository -> Staging area -> Working directory

D. Working directory -> Local Git repository -> Staging area

Correct Answer: B

Question 3

Why do you use the Hidden Columns checkbox in the semantics node of your calculation view? Note:
There are 2 correct answers to this question.

A. To remove a column that is also used as a Label column

B. To ensure specific columns are NOT exposed to the reporting tool

C. To prevent passing columns in stacked calculation views

D. To avoid exposing sensitive columns when defining calculated columns

Correct Answer: A,B

Question 4

Which database features are typically NOT required by analytical applications that run on SAP HANA Cloud? Note: There are 2 correct answers to this question.

A. Pre-calculated aggregates

B. Stored procedures

C. Table partitions

D. Indexes

Correct Answer: A,D

Question 5

What are some of the typical tasks performed by the SAP HANA Cloud modeler role? Note: There are 2 correct answers to this question.

A. Create graph workspaces

B. Develop SAP Fiori apps

C. Configure data tiering

D. Develop calculation views

Correct Answer: A,D

Question 6

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. Join cardinality is set :1.

B. Integrity constraint is set to RIGHT.

C. The Country column is requested.

D. The Keep flag is activated for the Customer column.

Correct Answer: A,B

Question 7

What is the recommended tool for developing cloud foundry applications on SAP Business Technology Platform?

A. SAP HANA Web IDE

B. SAP Business Application Studio

C. SAP HANA Cloud Central

D. SAP HANA cockpit

Correct Answer: B

Question 8

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

A. To filter an attribute at runtime based on a user input

B. To break up complex SQL into smaller steps

C. To pass values between procedures and calculation views

D. To provide a dynamic value in a calculated column

Correct Answer: B

Question 9

In your calculation view, you want to consume a custom data source defined using SQLScript. In which type of object do you write your code?

A. Scalar function

B. Anonymous block

C. Procedure

D. Table function

Correct Answer: D

Welcome to TestSimulate

SAP Certified Application Associate - SAP HANA Cloud Modeling (C_HCMOD_01) Free Practice Test