Question 1

In a calculation view, what is the purpose of a variable?

Options :

A : To pass values between procedures and calculation views

B : To provide a dynamic value in a calculated column

C : To break up complex SQL into smaller steps

D : To filter an attribute at runtime based on a user input

Answer: D

Question 2

What can you do with shared hierarchies? Note:There are 2 correct answers to this question.

Options :

A : Access hierarchies created in external schemas

B : Enable SQL SELECT statements to access hierarchies

C : Provide reusable hierarchies for drilldown in a CUBE with star join

D : Provide reusable hierarchies for drilldown in a CUBE without star join

Answer: B,D

Question 3

Why would you create SQL in calculation views?

Options :

A : To implement custom logic

B : To provide an alternative to graphical modeling

C : To fine-tune performance

D : To enable write capabilities

Answer: A

Question 4

At which levels of a project structure can you execute a deploy operation?Note: There are 2 correct answers to this question.

Options :

A : Individual source file

B : Entire workspace

C : Sub-folder of a database module

D : Individual container

Answer: B,C

Question 5

You are deploying a new calculation view, A, that uses calculation view B, as shown in the diagram.

When you preview calculation view A, the account number is not masked.What could be the reason?

Options :

A : You previewed the data with the technical user in SAP Business Application Studio.

B : You did not define masking in calculation view A.

C : The UNMASKED privilege has NOT been granted at the schema level.

D : The type of the Account_Number column is VARCHAR.

Answer: C

Prepare Efficiently with Free C_HAMOD_2404 Exam Practice Test