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

Question 1

In a calculation view, why would you implement an SQL expression? Note: There are 3 correct answers to this question.

A. To generate a calculated column B. To convert currencies C. To generate a restricted column D. To generate hierarchies E. To define a filter

Correct Answer: A,C,E

Question 2

You create a table function to remove historic records, sum the current total weekly working hours for each employee, and update the personnel table with the results. The deployment of the table function fails.Which of the following could be a valid reason?

A. You did not define at least one input parameter. B. You did NOT define a valid table type. C. Your function includes a TRUNCATE statement. D. Your function refers to a scalar function.

Correct Answer: C

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

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

In a calculation view, why would you choose the DEPRECATED setting?Note: There are 2 correct answers to this question.

A. To lock the calculation view from further modifications B. To indicate that it should not be used as a data source to other calculation views C. To warn developers that the calculation view is no longer supported D. To ensure it is not exposed to reporting tools for consumption

Correct Answer: C,D

Question 6

What are some of the restrictions that apply when defining parallelization blocks in calculation views?
Note: There are 2 correct answers to this question.

A. The block must only have one start node. B. Only one block can be defined across a stack of calculation views. C. Multiple blocks can only be defined within a single calculation view. D. The block must start with a node that defines a table as a data source.

Correct Answer: B,D

Question 7

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. Stored procedures B. Table partitions C. Indexes D. Pre-calculated aggregates

Correct Answer: C,D

Question 8

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. Tuning the database to run optimally on the underlying operating system, and hardware B. Managing users, roles, and permissions in the database C. Backing up the operating system and the database software D. Installing, configuring, and upgrading the operating system

Correct Answer: A,C,D

Question 9

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. Develop calculation views B. Create graph workspaces C. Develop SAP Fiori apps D. Configure data tiering

Correct Answer: A,B

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