SAP Certified Development Specialist - ABAP for SAP HANA 2.0

Here you have the best SAP E_HANAAW_17 practice exam questions

You have 40 total questions to study from
Each page has 5 questions, making a total of 8 pages
You can navigate through the pages using the buttons at the bottom
This questions were last updated on January 21, 2026
This site is not affiliated with or endorsed by SAP.

Question 1 of 40

You analyze SQL Monitor data in transaction SQLMD. You know that program X accesses database table Y. You made sure that program X was executed while the SQL Monitor collected its data. But the relevant database access is NOT listed in SQLMD.
What could be the reason? (Choose three.)

Program X was executed in the background

SQL Monitor was activated for a specific application server

SQL Monitor was activated with a filter that excludes database table Y

The data has NOT yet been transferred to the SQL Monitor database tables

Database table Y is a buffered table

Correct Answer: B, C, D

Question 2 of 40

Which of the Golden Rules for Open SQL Performance have become more important with SAP HANA? (Choose two.)

Keep unnecessary load away from the database

Minimize the search overhead

Minimize the number of database accesses

Minimize the amount of transferred data

Correct Answer: C, D

Question 3 of 40

Which tools can you use to provide input data for the SQL Performance Tuning Worklist (transaction SWLT)? (Choose three.)

Database Performance Monitor (transaction: DB50)

SQL Monitor (transaction: SQLM)

SQL Trace (transaction: ST05)

Code Inspector (transaction: SCI)

ABAP Test Cockpit (transaction: АТС)

Correct Answer: B, D, E

Question 4 of 40

Which step of the Guided Performance Analysis should you perform in the production system?

Collecting data with SQL Monitor (SQLM)

Performing an inspection with Code Inspector (SCI)

Executing a check run with ABAP Test Cockpit (АТС)

Building a work list with SQL Performance Tuning Worklist (SWLT)

Correct Answer: A

Question 5 of 40

Which of the following features the ABAP Test Cockpit offer that the ABAP Code Inspector does NOT offer? (Choose two.)

Enhanced distribution of results

Flexible schedule of check runs

Configuration of check variants

Documented checks

Correct Answer: A, B