SAP Certified Application Associate - SAP HANA Cloud Modeling - C-HCMOD-02 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

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

Discussion 0

Correct Answer: C Vote an answer

Question 2

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

A. To break up complex SQL into smaller steps B. To pass values between procedures and calculation views C. To filter an attribute at runtime based on a user input D. To provide a dynamic value in a calculated column

Discussion 0

Correct Answer: D Vote an answer

Question 3

At which levels of a project structure can you execute a deploy operation?Note: There are 2 correct answers to this question.

A. Individual source file B. Entire workspace C. Sub-folder of a database module D. Individual container

Discussion 0

Correct Answer: B,C Vote an answer

Question 4

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

Discussion 0

Correct Answer: B Vote an answer

Question 5

What are possible consequences of unfolding?Note: There are 2 correct answers to this question.

A. SQL compilation time increases B. Results are read from static cache C. Query processing time improves D. Count-distinct results are incorrect

Discussion 0

Correct Answer: A,D Vote an answer

Question 6

What is the recommended tool for developing cloud foundry applications?

A. SAP HANA Cloud Central B. SAP HANA Web IDE C. SAP HANA cockpit D. SAP Business Application Studio

Discussion 0

Correct Answer: A Vote an answer

Question 7

You created a table and inserted data in it using SQL statements inside the SAP HANA Deployment Infrastructure (HDI) container of your project. You add this table as a data source to a calculation view and try to deploy it.What do you observe in the SAP HANA database container?

A. The deployment is successful but the data preview returns an error message. B. The deployment fails and the table is not dropped. C. The deployment fails and the table is dropped. D. The deployment is successful and the data preview returns expected data.

Discussion 0

Correct Answer: B Vote an answer

Question 8

A new version of SAP HANA Cloud, SAP HANA database is available from today.If you do not perform the upgrade manually, how much time do you have before your database will be automatically upgraded to the next version?

A. 3 months B. 7 months C. 2 weeks D. 1 year

Discussion 0

Correct Answer: A Vote an answer

Question 9

In a database module, what is the purpose of the .hdiconfig file?

A. To specify which HDI plug-ins are available B. To specify the namespace rules applicable to the name of database objects C. To specify an external schema in which calculation views will get their data D. To specify in which space the container should be deployed

Discussion 0

Correct Answer: A Vote an answer