SAP Certified Application Associate - SAP HANA Cloud Modeling - C_HCMOD

Question 1

A calculation view consumes the data sources shown in the graphic.

You want to identify which companies sold products in January AND February. What is the optimal way to do this?

A. Use a minus node B. Use an intersect node. C. Use a union node. D. Use an aggregation node.

Discussion 0

Correct Answer: B Vote an answer

Question 2

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 implement conditional logic C. To exploit additional data types D. To include ABAP syntax in the code E. To automate the generation of the code

Discussion 0

Correct Answer: A,B,C Vote an answer

Question 3

When is the first column store compression executed?

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

Discussion 0

Correct Answer: D Vote an answer

Question 4

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

A. SQL compilation time increases B. Results are read from static cache C. Query processing time improves D. Count-distinct results are incorrect

Discussion 0

Correct Answer: A,D Vote an answer

Question 5

What are the key steps to implement currency conversion in a calculation view?

A. Enable the measure for conversion Choose client, source, and target currencies Choose conversion date and rate type Deploy the conversion rule B. Assign semantic type Enable the measure for conversion/Choose client, source, and target currencies/Choose conversion date and rate type C. Assign semantic type/Choose client, source, and target currencies/Choose conversion date and rate type/Define an expression in a calculated column D. Enable the measure for conversion/Choose client, source, and target currencies/Choose conversion date and rate type/Assign the conversion rule to your calculation view

Discussion 0

Correct Answer: B Vote an answer

Question 6

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 7

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 8

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

Question 9

Which of the following data sources can you include in a graphical calculation view?Note: There are 2 correct answers to this question.

A. Procedure B. Table function C. Scalar function D. Row table

Discussion 0

Correct Answer: B,D Vote an answer

SAP Certified Application Associate - SAP HANA Cloud Modeling - C_HCMOD_03 FREE EXAM DUMPS QUESTIONS & ANSWERS