Question 1
Which of the following are standard options provided to define analytic privileges? Note: There are 3 correct answers to this question.
Correct Answer:
A. Dynamic; B. SQL expression; E. Attributes
Free SAP Certified Associate - Data Engineer - SAP HANA C_HAMOD_2404 Exam Questions
Question 2
You have generated a calculation view properties file. What does it contain?
Correct Answer:
B. Descriptions of all objects defined in a calculation view
Question 3
Why would you partition a table in an SAP HANA database? Note: There are 2 correct answers to this question.
Correct Answer:
B. To overcome the 2 billion record limit; D. To improve query performance when accessing large column tables
Question 4
In a calculation view, your table function node executes a table function that requires input parameters.
How can you fill the input parameters of the table function? Note: There are 3 correct answers to this question.
Correct Answer:
A. Define constant values.; D. Map columns from lower nodes.; E. Create and map an input parameter.
Question 5
In a calculation view, why would you choose the DEPRECATED setting? Note: There are 2 correct answers to this question.
Correct Answer:
A. To warn developers that the calculation view is no longer supported; B. To indicate that it should not be used as a data source to other calculation views
Question 6
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?
Correct Answer:
C. Your table function includes a DELETE statement.
Question 7
Why might you use the Keep Flag property in an aggregation node?
Correct Answer:
C. To include columns that are NOT requested by a query but are essential for the correct result
Question 8
Which of the following are characteristics of the OPTIMIZED linked database feature? Note: There are 2 correct answers to this question.
Correct Answer:
A. The metadata of remote tables is cached on the target system; C. The source and target system must be SAP HANA
Question 9
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?
Correct Answer:
D. You already mapped the input parameters in another calculation view.
Question 10
In your calculation view, you want to consume a custom data source defined using SQLScript. In which type of object do you write your code?
Correct Answer:
D. Table function