SAP ABAP for HANA Sample Questions:

01. Your ABAP program contains an Open SQL join of two client-dependent tables. You want to replace this with a native SQL SELECT statement.
Which of the following changes to the SELECT statement can you use to retrieve the same data as before?
There are 2 correct answers to this question.
a) Include the client field in the WHERE condition.
b) Use the CLIENT SPECIFIED addition.
c) Include the client field in the join condition.
d) Include the client field in the field list.
 
02. In addition to closing the result set, what does the CLOSE method of the CL_SQL_RESULT_SET class when using ABAP Database Connectivity (ADBC) do?
Please choose the correct answer.
a) Release packages
b) Update packages
c) Release resources
d) Update resources
 
03. What are the benefits of using the SQL Monitor (transaction SQLM)?
There are 2 correct answers to this question.
a) It collects monitoring data asynchronously without additional database interaction.
b) It can be active in a production system with minimal performance overhead.
c) It displays the database execution plan for all SQL statements.
d) It schedules ABAP programs to monitor and log all database accesses.
 
04. Your customer wants to migrate to SAP HANA and you want to identify which business processes should be optimized. 
Which of the following steps must you perform to get this information? 
There are 2 correct answers to this question.
a) Combine the results of the SQL Monitor with the results of an ABAP runtime analysis.
b) Activate the new SQL Monitor in a productive system.
c) Combine the results of the SQL Monitor with the results of a static source code analysis.
d) Activate the new SQL Monitor in a development system.
 
05. Which features does the source code editor provide in ABAP Development Tools for SAP NetWeaver?
There are 2 correct answers to this question.
a) Screen editing
b) Quickfix
c) Form-based class builder
d) Content assistance
 
06. In which of the following situations could a row store table be more suitable than a column store table?
There are 2 correct answers to this question.
a) The table contains data that you want to aggregate.
b) The table contains only a small number of records.
c) The table contains mainly distinct values per column across rows.
d) The table contains text that you want to search.
 
07. You create a check variant in the Code Inspector which includes the check 'Search problematic Select * statements'. SAP HANA is used as the database.
In the check parameters, which value would you use for the percentage of fields that are effectively used?
Please choose the correct answer.
a) A lower value than on a traditional, row-store only based database
b) The same value as on a traditional, row-store only based database
c) A value that you calculate based on the number of tables
d) A higher value than on a traditional, row-store only based database
 
08. You have an SQLScript procedure with a table input parameter it_books.
You want to use the parameter on the right-hand side of an assignment operator within the procedure. How do you refer to the parameter?
Please choose the correct answer.
a) {it_books}
b) :it_books
c) @it_books
d) it_books
 
09. What should you do to follow the code-to-data approach to programming?
There are 2 correct answers to this question.
a) Perform expensive calculations on the database.
b) Transfer all data from the database to the ABAP layer, and then aggregate the results.
c) Aggregate data on the database, and transfer the results to the ABAP layer.
d) Perform expensive calculations on the ABAP application server.
 
10. What are functions of the ABAP Managed Database Procedure (AMDP) framework?
There are 2 correct answers to this question.
a) It deletes obsolete versions of the database procedure asynchronously
b) It creates the database procedure when the AMDP is first called.
c) It creates the database procedure when the AMDP is first activated.
d) It deletes obsolete versions of the database procedure synchronously.
 
Quick Tips:
  • SAP provides a note "There are 'N' correct answers to this question." in actual SAP ABAP for HANA Certification Exam.
  • SAP does not ask "True or False" type questions in actual SAP E_HANAAW_12 Exam.
  • SAP provides an option to Increase (+) or Decrease (-) font size of exam screen for better readability in actual SAP ABAP for SAP HANA Certification Exam.

Solutions:

QUESTION: 01 Answer: a, c QUESTION: 02 Answer: c QUESTION: 03 Answer: a, b QUESTION: 04 Answer: b, c QUESTION: 05 Answer: b, d
QUESTION: 06 Answer: b, c QUESTION: 07 Answer: a QUESTION: 08 Answer: b QUESTION: 09 Answer: a, c QUESTION: 10 Answer: a, b



Serkan AKKAVAK
Computer Engineer
ABAP Developer & SAP S/4 HANA Logistics Consultant
Contact : serkurumsal@yandex.com