C_HAMOD_2404 – SAP Certified Associate – Data Engineer – SAP HANA PDF Dumps

Question: 1
What can you do with shared hierarchies? Note:There are 2 correct answers to this question.
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: 2
Why would you create SQL in calculation views?
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: 3
Which type of join supports a temporal condition in a calculation view?
A. Referential join
B. Inner join
C. Text join
D. Left outer join
Answer: B

Question: 4
What options do you have to handle orphan nodes in your hierarchy?Note: There are 2 correct answers to this question.
A. Define an expression to determine a parent.
B. Generate additional root nodes.
C. Assign them to a level below the root.
D. Assign them to a node at the root level.
Answer: B C

Question: 5
What do you use in the definition of a dynamic SQL analytic privilege?
A. A table function that returns a list of allowed values.
B. A scalar function that returns a list of the allowed values for each attribute.
C. A procedure that returns the data access condition as an SQL expression.
D. An organization hierarchy that provides role-based access to data.
Answer: C