Download Latest C_HCMOD_03 Questions

SAP Certified Application Associate - SAP HANA Cloud Modeling Questions and Answers

Question 9

You want to create a star schema using a calculation view. The measures are based on columns from two transaction tables. DIMENSION calculation views provide the attributes.What is the correct approach?

Options:

Combine the transaction tables using a star join node in a calculation view of type CUBE with star join./Use a join node to join the DIMENSIONS to the fact table.

Combine the transaction tables using an aggregation node in a calculation view of type CUBE with star join./Use a star join node to join the DIMENSIONS to the fact table.

Combine the transaction tables using a join node in a calculation view of type CUBE with star join.Use a star join node to join the DIMENSIONS to the fact table.

Combine the transaction tables using a star join node in a calculation view of type CUBE with star join.Use the same star join node to connect the DIMENSIONS to the fact table.

Question 10

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?

Options:

Scalar function

Table function

Anonymous block

Procedure

Question 11

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?

Options:

"?"

"0"

"Null"

Question 12

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

Options:

Query processing time improves

Results are read from static cache

SQL compilation time increases

Count-distinct results are incorrect

SAP Certified Application Associate - SAP HANA Cloud Modeling Questions and Answers

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

CompTIA

Fortinet

Microsoft

Salesforce