SAP Certified Application Associate - SAP HANA (Edition 2016 - SPS12) - C-HANAIMP-12 Exam Practice Test
Question 1
What variable type do you use if you want to allow the user to choose dates from 2011 to
2 014?
Please choose the correct answer.
Response:
2 014?
Please choose the correct answer.
Response:
Correct Answer: C
Question 2
Look at Figure You are selling books that have been translated into various languages.
What join type should you use?
Please choose the correct answer.
Response:
What join type should you use?
Please choose the correct answer.
Response:
Correct Answer: D
Question 3
In which deployment scenarios does security stay in the application server, and end users do not log into the SAP HANA system?
There are 2 correct answers to this question.
Response:
There are 2 correct answers to this question.
Response:
Correct Answer: A,C
Question 4
Which data provisioning tools can use SAP HANA adapters?
There are 2 correct answers to this question.
There are 2 correct answers to this question.
Correct Answer: A,C
Question 5
You want to reuse a decision table on multiple tables with a similar data structure. You design the decision table that passes a specific table name as an input parameter when you execute the decision table.
What do you have to use in the data foundation to achieve this?
Please choose the correct answer.
Response:
What do you have to use in the data foundation to achieve this?
Please choose the correct answer.
Response:
Correct Answer: C
Question 6
Prior to modeling in SAP HANA, you want to check whether a table is row-based or column-based. How can you do this in the SAP HANA studio?
There are 2 correct answers to this question.
Response:
There are 2 correct answers to this question.
Response:
Correct Answer: A,C
Question 7
What type of load does SAP HANA perform when starting up?
Please choose the correct answer.
Response:
Please choose the correct answer.
Response:
Correct Answer: D
Question 8
The company's board members want to run simulations on the year-end financial dat a. What do you use to build this for them?
Please choose the correct answer.
Response:
Please choose the correct answer.
Response:
Correct Answer: C
Question 9
If we change the transaction "Laura buys 10 apples" to "Laura buys 10 green apples," how would we store the color green?
Please choose the correct answer.
Response:
Please choose the correct answer.
Response:
Correct Answer: D
Question 10
For what SQL keyword is the aggregation node the equivalent?
Please choose the correct answer.
Response:
Please choose the correct answer.
Response:
Correct Answer: D
Question 11
Which features are similar between an analytic view and a calculation view of type cube with star join?
There are 3 correct answers to this question.
Response:
There are 3 correct answers to this question.
Response:
Correct Answer: A,D,E
Question 12
Which of the following are reasons you should use Core Data Services (CDS) to create a schema?
There are 2 correct answers to this question.
Response:
There are 2 correct answers to this question.
Response:
Correct Answer: A,D
Question 13
You need a business intelligence tool that is Microsoft Excel-based and can use parent- child hierarchies. Which tool do you use?
Please choose the correct answer.
Response:
Please choose the correct answer.
Response:
Correct Answer: A
Question 14
Schema mapping is used during which process?
Please choose the correct answer.
Response:
Please choose the correct answer.
Response:
Correct Answer: D
