Free SAP E-HANAAW-16 Exam Dumps Questions & Answers

How can you check if Core Data Services (CDS) views with scalar input parameters can be used in Open SQL queries in your system?

• A.  Use the static method use_features of class cl_abap_dbfeatures.
• B.  Check the Open SQL statement in the Explain SQL Statement transaction (SDBE).
• C.  Perform a static code check using the FUNCTIONAL_DB variant.
• D.  Check the value of the ABAP system field sy-cdsfeatures.

Which of the following tasks can you perform with SQL monitor (transaction SQLM)? There are 1 correct answer to this question.

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

What allows you to resolve errors quickly or warnings reported about the code? Please choose the correct answer.

• A.  Quick Fix
• B.  Debug perspective
• C.  ABAP debugger
• D.  Code execution

What are the Guidelines for optimizing ABAP code running on HANA? There are 3 correct answers to this question.

• A.  DB specific properties
• B.  High-speed data analysis
• C.  Open SQL settings
• D.  Column store
• E.  Technical settings

Which of the following is not involved in database table of "The NewABAP SQL Monitor-Architecture?
Choose the correct answer

• A.  Critical data table
• B.  Selection data table
• C.  Performance data table
• D.  Runtime monitor data