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

Question 1

You define a hierarchy in a calculation view. You want to expose the hierarchy to SQL. Which of the following conditions must be met? Note: There are 2 correct answers to this question.

A. The hierarchy must be a local hierarchy. B. The hierarchy must be a shared hierarchy. C. The hierarchy must be exposed by a calculation view of type CUBE with star join. D. The hierarchy must be a parent-child hierarchy.

Discussion 0

Correct Answer: B,C Vote an answer

Question 2

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

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

Discussion 0

Correct Answer: A,D Vote an answer

Question 3

You create a user-provided service to access tables in external schemas. In which file type do you assign the user-provided service to your database module?

A. .hdiconfig B. .namespace C. .mtar D. .yaml

Discussion 0

Correct Answer: D Vote an answer

Question 4

What is the SQL keyword used to process input parameters defined in a calculation view?

A. HINT B. PLACEHOLDER C. WHERE D. SET

Discussion 0

Correct Answer: B Vote an answer

Question 5

What are the consequences of NOT executing a delta merge? Note: There are 2 correct answers to this question.

A. New records are not read. B. Read performance decreases. C. Memory is not optimized. D. Aggregates are not adjusted.

Discussion 0

Correct Answer: A,B Vote an answer

Question 6

In a calculation view, why would you implement an SQL expression? Note: There are 3 correct answers to this question.

A. To convert currencies B. To generate a restricted column C. To generate a calculated column D. To define a filter E. To generate hierarchies

Discussion 0

Correct Answer: B,C,D Vote an answer

Question 7

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

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

Discussion 0

Correct Answer: C,D Vote an answer

Question 8

Which database features are typically NOT required by analytical applications that run on SAP HANA Cloud? Note: There are 2 correct answers to this question.

A. Pre-calculated aggregates B. Stored procedures C. Indexes D. Table partitions

Discussion 0

Correct Answer: A,C Vote an answer

Question 9

Your calculation view consumes one data source, which includes the following columns:
SALES_ORDER_ID, PRODUCT_ID, QUANTITY and PRICE. In the output, you want to see summarized data by PRODUCT_ID and a calculated column, PRODUCT_TOTAL, with the formula QUANTITY * PRICE. In which type of node do you define the calculation to display the correct result?

A. Union B. Join C. Aggregation D. Projection

Discussion 0

Correct Answer: D Vote an answer