CertsTopics Logo

Weekend Sale Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

SAP Certified Application Associate Changed C_HCMOD_05 Questions

Page: 5 / 7
Total 88 questions
Get C_HCMOD_05 Full Access Download C_HCMOD_05 PDF

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

Question 17

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?

Options:

A.

Projection

B.

Join

C.

Union

D.

Aggregation

Question 18

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

Options:

A.

WHERE

B.

PLACEHOLDER

C.

HINT

D.

SET

Question 19

What is a restricted measure?

Options:

A.

A measure that can be consumed by a CUBE and not a DIMENSION.

B.

A measure that is filtered by one or more attribute values.

C.

A measure that can only be displayed by those with necessary privileges.

D.

A measure that cannot be referenced by a calculated column.

Question 20

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

Options:

A.

Avoid aggregating data early in the data flow.

B.

Partition large tables.

C.

Limit the number of stacked calculation views.

D.

Implement union pruning.

Page: 5 / 7
Total 88 questions
Get C_HCMOD_05 Full Access Download C_HCMOD_05 PDF