Download SAP Certified Development Specialist -ABAP for SAP HANA 2-0.VCEPlus.E_HANAAW_17.2021-10-04.1e.40q.vcex

Download Exam

File Info

Exam SAP Certified Development Specialist - ABAP for SAP HANA 2-0
Number E_HANAAW_17
File Name SAP Certified Development Specialist -ABAP for SAP HANA 2-0.VCEPlus.E_HANAAW_17.2021-10-04.1e.40q.vcex
Size 209 Kb
Posted October 04, 2021
Downloads 65

How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.


With discount: 20%


Demo Questions

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

  • 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

Question 2
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  

Question 3
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: АТС)

Question 4
Which step of the Guided Performance Analysis should you perform in theproduction 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)

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

  • A: Enhanced distribution of results
  • B: Flexible schedule of check runs
  • C: Configuration of check variants
  • D: Documented checks

Question 6
Which task can you perform with the SQL Monitor(transaction SQLM)?  

  • A: Capture the SQL profile of an application
  • B: Search the problematic SELECT * statements
  • C: Display the execution plan of an SQL statement
  • D: Combine static and dynamic performance analysis results

Question 7
Which functional problem can you detect when using the Runtime CheckMonitor (SRTCM)?

  • A: Use of Native SQL and DB Hints
  • B: Existence check for Secondary Indexes
  • C: Direct access to Table Pools/Cluster
  • D: Missing ORDER BY or SORT after SELECT

Question 8
Which rules does SAP recommend to improve the performance of ABAP reports on SAP HANA? (Choose two.)  

  • A: Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement
  • B: Perform all calculations and aggregations in the ABAP layer
  • C: Ensure the WHERE clause contains at least one index field
  • D: Ensure the access to buffered tables uses the SAP table buffer

Question 9
What must you take into consideration when you use the new Open SQL syntax (available as of SAP NetWeaver 7.4 SP05)?(Choose two.)

  • A: All classical open SQL statements in your program will become invalid
  • B: All ABAP variables must be escaped with a preceding @ sign
  • C: All fields in the GROUP BY clause must be separated by commas
  • D: All arithmetic expressions can be used for all types of variables

Question 10
When using an SAP HANA full text search, what do you have tokeep in mind?

  • A: The full-text index is always updated asynchronously
  • B: SAP HANA has to be the primary database to create a full text search
  • C: The LIKE operator is required in your SELECT statement to implement fuzzy logic
  • D: The SCORE ( ) function is required to ensure the best hits of your search appear on top


You can buy ProfExam with a 20% discount..

Get Now!


Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen


Use VCE Exam Simulator to open VCE files