CertsTopics Logo

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

Complete C_HCMOD_05 SAP Materials

Page: 6 / 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 21

You want to map an input parameter of calculation view A to an input parameter of calculation view B using the parameter mapping feature in the calculation view editor.

However, the input parameters of calculation view B are not proposed as source parameters. What might be the reason for this?

Options:

A.

You already mapped the input parameters in another calculation view.

B.

The names of the input parameters do not match.

C.

You selected the wrong parameter mapping TYPE.

D.

Your source calculation view is of type DIMENSION.

Question 22

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.

Options:

A.

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

B.

To ensure that the aggregation always happens after the join execution

C.

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

D.

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

Question 23

You create a table function to remove historic records, sum the current total weekly working hours for each employee, and update the personnel table with the results. The deployment of the table function fails.Which of the following could be a valid reason?

Options:

A.

Your function includes a TRUNCATE statement.

B.

Your function refers to a scalar function.

C.

You did NOT define a valid table type.

D.

You did not define at least one input parameter.

Question 24

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

Options:

A.

To generate hierarchies

B.

To define a filter

C.

To convert currencies

D.

To generate a restricted column

E.

To generate a calculated column

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