Q86. An Analytic Privilege consists of several restrictions. What are they? There 3 correct answers to this question

Q87. What are the steps involved in supporting a database oriented programming model? There are 2 correct answers to this question.

Q88. What is the main function of Static Code Analysis? Please choose the correct answer.

Q89. When would you use a column store table instead of a row store table? There are 2 correct answers to this question.

Q90. Which of the following repository object can you edit only in ABAP Development tools in Eclipse and not in the Classical ABAP workbench?
There are 3 correct answers to this question.

Q91. In an Open SQL query, you select the sum of sales order gross amounts and a CASE statement to flag sa order gross amounts below a certain value. What information has to be provided in the GROUP BY list?

Q92. What is the language SAP HANA is developed in?

Q93. HANA modeling views can be created under

Q94. You apply static code checks on your ABAP coding to find potential functional regressions and receive a message about an “Unsecure use of FOR ALL ENTRIES” issue. Which tool can you use to get additional runtime information?

Q95. Discuss the basic approach of classical ABAP programming? There are 2 correct answers to this question.

Q96. One of your SAP systems needs to be migrated from its current database to an SAP HANA database. You want to avoid any functional issues after the migration. What should you search for and if necessary replace in the existing custom ABAP code? There are 3 correct answers to this question.

Q97. Which of the following ABAP transactions can you use to detect SQL performance optimization potential in your ABAP code? 2 ans

Q98. Which of the following information is mandatory in the definition of an association in a Core Data Services (CDS) view?

Q99. You use native SQL to access the SAP HANA database. What should you do to retrieve the correct data? There are 3 correct answers to this question.

Q100. Which of the following categories of parameters can you use in the definition of an ABAP manage database procedure (AMDP)?
There are 3 correct answers to this question.

Q101. Which SAP HANA engine executes Calculation view? (2 answers)

Q102. Which system schema/user is the owner of all the activated objects?

Q103. DB-Specific Properties that allows switching between storage types when running on an SAP HANA database. What are these storage types? There are 2 correct answers to this question.