SAP E_HANAAW_17 Exam Actual Questions

The questions for E_HANAAW_17 were last updated on Dec. 2, 2024.

Viewing page 1 out of 10 pages.
Viewing questions 1-4 out of 40 questions

Topic 1 - Topic 1, Guided Performance Analysis

Question #1 Topic 1

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.)

A. Program X was executed in the background
B. SQL Monitor was activated for a specific application server
C. SQL Monitor was activated with a filter that excludes database table Y
D. The data has NOT yet been transferred to the SQL Monitor database tables
E. Database table Y is a buffered table

Reveal Solution Discussion

Correct Answer: BCD 🗳️

Question #2 Topic 1

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

A. Keep unnecessary load away from the database
B. Minimize the search overhead
C. Minimize the number of database accesses
D. Minimize the amount of transferred data

Reveal Solution Discussion 1

Correct Answer: CD 🗳️

Question #3 Topic 1

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

A. Database Performance Monitor (transaction: DB50)
B. SQL Monitor (transaction: SQLM)
C. SQL Trace (transaction: ST05)
D. Code Inspector (transaction: SCI)
E. ABAP Test Cockpit (transaction: АТС)

Reveal Solution Discussion

Correct Answer: BDE 🗳️

Question #4 Topic 1

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

A. Collecting data with SQL Monitor (SQLM)
B. Performing an inspection with Code Inspector (SCI)
C. Executing a check run with ABAP Test Cockpit (АТС)
D. Building a work list with SQL Performance Tuning Worklist (SWLT)

Reveal Solution Discussion

Correct Answer: A 🗳️