SAP Certified Application Associate - SAP HANA Cloud Modeling (C-HCMOD-05) Free Practice Test

Question 1

You created a procedure to be consumed in an analytic privilege of the type DYNAMIC, but it isn't working as expected.What could be the reason?Note: There are 2 correct answers to this question.

A. The procedure is write-enabled

B. The output parameter is defined as NVARCHAR

C. You defined more than one output parameter

D. No input parameter is specified

Correct Answer: C,D

Question 2

Which solutions form the SAP Business Technology Platform? Note: There are 2 correct answers to this question.

A. Intelligent Suite

B. Experience Management

C. Application Development & Integration

D. Analytics

Correct Answer: C,D

Question 3

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 fails and the table is not dropped.

B. The deployment is successful but the data preview returns an error message.

C. The deployment fails and the table is dropped.

D. The deployment is successful and the data preview returns expected data.

Correct Answer: A

Question 4

You set the Null Handling property for an attribute but do not set a default value.What is displayed when null values are found in a column of data type NVARCHAR?

A. "Null"

B. "0"

C. <empty string>

D. "?"

Correct Answer: C

Question 5

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

A. Count-distinct results are incorrect

B. Results are read from static cache

C. SQL compilation time increases

D. Query processing time improves

Correct Answer: C,D

Question 6

You have linked an underlying node to the star join node to define the data foundation. Which data source type can you then join to the data foundation?

A. CUBE calculation view

B. Table functions

C. DIMENSION calculation view

D. Tables

Correct Answer: C

Question 7

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

A. To pass parameters from calculation views

B. To exploit additional data types

C. To implement conditional logic

D. To automate the generation of the code

E. To include ABAP syntax in the code

Correct Answer: A,B,C

Question 8

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

A. To specify which HDI plug-ins are available

B. To specify an external schema in which calculation views will get their data

C. To specify in which space the container should be deployed

D. To specify the namespace rules applicable to the name of database objects

Correct Answer: A

Question 9

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

B. 5

C. 9

D. 2

Correct Answer: C

Welcome to TestSimulate

SAP Certified Application Associate - SAP HANA Cloud Modeling (C-HCMOD-05) Free Practice Test