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

Question 1

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. Provide reusable hierarchies for drilldown in a CUBE without star join

D. Enable SQL SELECT statements to access hierarchies

Correct Answer: C,D

Question 2

You deleted the design-time file of a calculation view in your HDB module.What is the recommended way to ensure that the corresponding runtime object is also removed from the database?

A. Deploy the project that contained the deleted design-time file.

B. Execute the refactor function for the calculation view.

C. Deploy the folder that contained the deleted design-time file.

D. Execute a DROP statement in an SQL Console connected to the HDI container.

Correct Answer: A

Question 3

Which of the following are standard options provided to define analytic privileges?Note: There are 3 correct answers to this question.

A. SQL expression

B. Attributes

C. Graph

D. Hierarchy function

E. Dynamic

Correct Answer: A,B,E

Question 4

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 5

You have imported calculation views from SAP HANA on-premise to SAP HANA Cloud.Why should you switch calculated column expression language from column engine to SQL?

A. To define limits for query unfolding

B. Column engine language is not supported.

C. To benefit from additional SQL optimizations

D. Incorrect aggregations may be generated

Correct Answer: C

Question 6

Using the table in the diagram, you need to create a CUBE calculation view.
What is the simplest approach to create the output shown in the screenshot?

A. Create a filter expression that uses an OR operator.

B. Implement a union node and map each country as a separate column.

C. Create a restricted column for each country.

D. Create 3 calculated columns.

Correct Answer: C

Question 7

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

A. Database explorer

B. Explain plan

C. Debug Query mode

D. SQL analyzer

Correct Answer: C

Question 8

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 9

In SAP HANA Cloud, which tasks are handled by the cloud provider?Note: There are 3 correct answers to this question.Sizing, provisioning, and monitoring the database

A. Backing up the operating system and the database software

B. Managing users, roles, and permissions in the database

C. Tuning the database to run optimally on the underlying operating system, and hardware

D. Installing, configuring, and upgrading the operating system

Correct Answer: A,C,D

Welcome to TestSimulate

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