E_HANAAW_17 ABAP for SAP HANA 2.0

Question preview

Check the first 10 questions. Answers are revealed only when you take the quiz.

1. 1 · Geral

   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

2. 2 · Geral

   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

3. 3 · Geral

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

4. 4 · Geral

   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)

5. 5 · Geral

   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

6. 6 · Geral

   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

7. 7 · Geral

   Which functional problem can you detect when using the Runtime Check Monitor (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

8. 8 · Geral

   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

9. 9 · Geral

   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

10. 10 · Geral

    When using an SAP HANA full text search, what do you have to keep 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

And 30 more questions waiting for you.