SAP Certified Associate C_HAMOD_2404 Updated Exam

SAP Certified Associate - Data Engineer - SAP HANA Questions and Answers

Question 21

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

To provide a dynamic value in a calculated column

To break up complex SQL into smaller steps

To pass values between procedures and calculation views

To filter an attribute at run-time based on a user input

Question 22

How can you define a variable that presents its value help hierarchically? Note: There are 2correct answers to this question.

Create a level hierarchy and assign it to the variable.

•Ensure the variable's reference column is the top level of the hierarchy.

Create a parent-child hierarchy and assign it to the variable.

•Ensure the variable's reference column is the parent attribute of the hierarchy.

Create a parent-child hierarchy and assign it to the variable.

•Ensure the variable's reference column is the child attribute of the hierarchy.

Create a level hierarchy and assign it to the variable.

•Ensure the variable's reference column is the leaf level of the hierarchy.

Question 23

You have defined a pruning configuration table in a calculation view. What are you attempting to prune from the query execution?

Data sources of unions

Joins

Calculated columns

Filters

Question 24

In a flowgraph, which node do you use to select only the required columns from a data source and to filter specific rows?

Projection

Aggregate

Case

Pivot