SAP E_HANAAW_17 Exam Practice Questions (P. 1)
- Full Access (40 questions)
- Six months of Premium Access
- Access to one million comments
- Seamless ChatGPT Integration
- Ability to download PDF files
- Anki Flashcard files for revision
- No Captcha & No AdSense
- Advanced Exam Configuration
Question #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.)
What could be the reason? (Choose three.)
- AProgram X was executed in the background
- BSQL Monitor was activated for a specific application server
- CSQL Monitor was activated with a filter that excludes database table Y
- DThe data has NOT yet been transferred to the SQL Monitor database tables
- EDatabase table Y is a buffered table
Correct Answer:
BCD
BCD
send
light_mode
delete
Question #2
Which of the Golden Rules for Open SQL Performance have become more important with SAP HANA? (Choose two.)
- AKeep unnecessary load away from the database
- BMinimize the search overhead
- CMinimize the number of database accesses
- DMinimize the amount of transferred data
Correct Answer:
CD
CD
send
light_mode
delete
Question #3
Which tools can you use to provide input data for the SQL Performance Tuning Worklist (transaction SWLT)? (Choose three.)
- ADatabase Performance Monitor (transaction: DB50)
- BSQL Monitor (transaction: SQLM)
- CSQL Trace (transaction: ST05)
- DCode Inspector (transaction: SCI)
- EABAP Test Cockpit (transaction: АТС)
Correct Answer:
BDE
BDE
send
light_mode
delete
Question #4
Which step of the Guided Performance Analysis should you perform in the production system?
- ACollecting data with SQL Monitor (SQLM)
- BPerforming an inspection with Code Inspector (SCI)
- CExecuting a check run with ABAP Test Cockpit (АТС)
- DBuilding a work list with SQL Performance Tuning Worklist (SWLT)
Correct Answer:
A
A
send
light_mode
delete
Question #5
Which of the following features the ABAP Test Cockpit offer that the ABAP Code Inspector does NOT offer? (Choose two.)
- AEnhanced distribution of results
- BFlexible schedule of check runs
- CConfiguration of check variants
- DDocumented checks
Correct Answer:
AB
AB
send
light_mode
delete
All Pages