SAP Certified Application Associate - SAP HANA 2.0 SPS06 - C_HANAIMP_18 Exam Practice Test

Question 1
Which of the following are warm data tier solutions?Note: There are 3 correct answers to this question.

Correct Answer: B,C,D
Question 2
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: B
Question 3
What are the consequences of NOT executing a delta merge?Note: There are 2 correct answers to this question.

Correct Answer: B,C
Question 4
What does SAP HANA provide to support full stack native application development?Note: There are 2 correct answers to this question.

Correct Answer: A,C
Question 5
Why do you use the Hidden Columns checkbox in the semantics node of your calculation view?Note: There are 2 correct answers to this question.

Correct Answer: A,D
Question 6
You have a cube calculation view that consumes a dimension view. You suspect some dimension columns have been renamed in the cube calculation view.Which function of SAP Web IDE for SAP HANA do you use to check where the output columns originate from?

Correct Answer: A
Question 7
Your calculation view consumes one data source, which includes the following columns:
SALES_ORDER_ID, PRODUCT_ID, QUANTITY and PRICE.In the output, you want to see summarized data by PRODUCT_ID and a calculated column, PRODUCT_TOTAL, with the formula QUANTITY * PRICE.In which type of node do you define the calculation to display the correct result?

Correct Answer: D
Question 8
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
Question 9
Why should you define calculated column expressions using plain SQL and avoid using column engine language?

Correct Answer: A