Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us [email protected]
Menu
sale

Want to Unlock All Questions for this Exam?

Full Exam Access, Discussions, No Robots Checks

27
Students signed up in the last 24H

SAP E_HANAAW_17 Exam Actual Questions

The questions for E_HANAAW_17 were last updated on April 18, 2024.
  • Viewing page 1 out of 10 pages.
  • Viewing questions 1-4 out of 43 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 Hide 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 Hide 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 Hide 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 Hide Solution   Discussion  

Correct Answer: A 🗳️

Next Questions

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel