SAP Certified Application Associate - SAP HANA Cloud Modeling

Question 1

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

B. "0"

C. <empty string>

D. "Null"

Correct Answer: C

Question 2

Why would you choose to implement a referential join?

A. To automate the setting of cardinality rules

B. To develop a series of linked joins

C. To define conditions for potential data source pruning

D. To reuse the settings of an existing join

Correct Answer: A

Question 3

Which of the following techniques can you use to improve the performance of calculation views?Note: There are 2 correct answers to this question.

A. Avoid aggregating data early in the data flow.

B. Implement union pruning.

C. Partition large tables.

D. Limit the number of stacked calculation views.

Correct Answer: C,D

Question 4

You have generated a calculation view properties file.What does it contain?

A. Dependencies between calculation views

B. Documentation to support the calculation view

C. All settings defined in a calculation view

D. Descriptions of all objects defined in a calculation view

Correct Answer: D

Question 5

In a calculation view, your table function node executes a table function that requires input parameters. How can you fill the input parameters of the table function? Note: There are 3 correct answers to this question.

A. Assign a hierarchy node.

B. Map columns from lower nodes.

C. Reference the output of a procedure.

D. Define constant values.

E. Create and map an input parameter

Correct Answer: B,D,E

Question 6

What is the recommended tool for developing cloud foundry applications?

A. SAP HANA Web IDE

B. SAP Business Application Studio

C. SAP HANA Cloud Central

D. SAP HANA cockpit

Correct Answer: B

Question 7

Which calendar types can be selected when creating time-based DIMENSIONS?Note: There are 2 correct answers to this question.

A. Factory

B. Gregorian

C. Fiscal

D. Julian

Correct Answer: B,C

Question 8

You combine two tables in a join node using multiple columns in each table.Why do you enable the dynamic join option?
Note: There are 2 correct answers to this question.

A. To allow data analysis at different levels of granularity with the same calculation view

B. To force the calculation at the relevant level of granularity, even if this level is not the grouping level defined by the query

C. To ensure that the aggregation always happens after the join execution

D. To ensure that the join execution only uses the join columns requested in the query

Correct Answer: A,D

Question 9

What is generated when you deploy a CUBE calculation view design-time file?Note: There are 2 correct answers to this question.

A. A column view in a container

B. Cached results to improve read performance

C. Metadata to enable consumption by external tools

D. An SQL execution plan

Correct Answer: B,C

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

Latest Update

Useful Links

Contact Us