SAP Certified Application Associate - SAP HANA Cloud Modeling

QUESTION NO: 1
When is the first column store compression executed?

A. When a delta merge is triggered B. When the table is created C. When a backup is started D. When partitions are regenerated

Correct Answer: A

QUESTION NO: 2
What options do you have to handle orphan nodes in your hierarchy? Note: There are 2 correct answers to this question.

A. Assign them to a node at the root level. B. Define an expression to determine a parent. C. Assign them to a level below the root. D. Generate additional root nodes.

Correct Answer: A,D

QUESTION NO: 3
You are managing your source files using Git. In which sequence does your file progress towards a COMMIT?

A. Working directory -> Local Git repository -> Staging area B. Staging area -> Working directory -> Local Git repository C. Working directory -> Staging area -> Local Git repository D. Local Git repository -> Staging area -> Working directory

Correct Answer: C

QUESTION NO: 4
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?

A. 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. B. 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. C. 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. D. 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.

Correct Answer: D

QUESTION NO: 5
What are some best practices for writing SQLScript for use with calculation views? Note: There are 2 correct answers to this question.

A. Use dynamic SQL. B. Break up large statements by using variables. C. Control the flow logic using IF-THEN-ELSE conditions. D. Choose declarative language instead of imperative language.

Correct Answer: B,D

QUESTION NO: 6
What is a restricted measure?

A. A measure that cannot be referenced by a calculated column. B. A measure that is filtered by one or more attribute values. C. A measure that can be consumed by a CUBE and not a DIMENSION. D. A measure that can only be displayed by those with necessary privileges.

Correct Answer: B

QUESTION NO: 7
You implement a referential join between Table A and Table B, but when you query the calculation view, Table B is not pruned. What could be the problem? Note: There are 2 correct answers to this question.

A. Join cardinality is set :1. B. The Keep flag is activated for the Customer column. C. The Country column is requested. D. Integrity constraint is set to RIGHT.

Correct Answer: A,D

QUESTION NO: 8
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. Scalar function C. Anonymous block D. Table function

Correct Answer: D

QUESTION NO: 9
Why would you create calculation views of data category DIMENSION with type TIME?

A. To provide additional time-related navigation possibilities B. To store historical versions of attributes C. To provide the time intervals required by time-dependent parent-child hierarchies D. To add a temporal condition to a join to find matching records from two tables based on a date

Correct Answer: A

SAP Certified Application Associate - SAP HANA Cloud Modeling - C_HCMOD_01 Exam Questions