C_HCMOD_03 by SAP Valid Free Exam Practice Test

Question 1

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

Correct Answer: C

Question 2

A calculation view consumes the data sources shown in the graphic.

You want to identify which companies sold products in January AND February. What is the optimal way to do this?

A. Use an intersect node. B. Use an aggregation node. C. Use a minus node D. Use a union node.

Correct Answer: A

Question 3

A calculation view includes a rank node that uses the source data and settings shown in the graphic.

Your query requests all columns of the rank node.How many rows are in the output of your query?

A. 9 B. 5 C. 2 D. 6

Correct Answer: A

Question 4

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 5

Why would an SQL developer work with SQLScript?Note: There are 3 correct answers to this question.

A. To automate the generation of the code B. To include ABAP syntax in the code C. To exploit additional data types D. To pass parameters from calculation views E. To implement conditional logic

Correct Answer: C,D,E

Question 6

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. Table function B. Scalar function C. Anonymous block D. Procedure

Correct Answer: A

Question 7

In Business Application Studio, you rename a DIMENSION calculation view that is used by a CUBE calculation view. You do NOT use the option to rename the runtime view and adjust the reference.
Afterward, you perform the following deploy operations:Deploy the DIMENSION calculation view as a single object.Deploy the entire SAP HANA database module.What is the outcome of the deploy operations?

A. The first deployment fails.The second deployment is successful. B. The first deployment is successful.The second deployment fails. C. The first deployment fails.The second deployment fails. D. The first deployment is successful.The second deployment is successful.

Correct Answer: 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

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 3 calculated columns. B. Implement a union node and map each country as a separate column. C. Create a filter expression that uses an OR operator. D. Create a restricted column for each country.

Correct Answer: D

SAP Certified Application Associate - SAP HANA Cloud Modeling - C_HCMOD_03 Exam Practice Test