Online Access Free E-HANAAW-17 Exam Questions

Which tasks does the ABAP managed database (AMDP) framework perform? There are 2 correct answers to this question.

• A.Delete the obsolete versions of the database procedure asynchronously
• B.Create a new version of the database when the AMDP is first activated
• C.Create a new version of the database when the AMDP is first called
• D.Delete the obsolete versions of the database procedure synchronously

You developed an ABAP program using ABAP Development Tools for SAP NetWeaver. How can you execute it? 2 ans

• A.Use the Open Development Object dialog (CTRL+SHIFT+A) and enter <Program_Name>/Execute in the search field.
• B.Open the ABAP program in the ABAP Development perspective and execute it using the shortcut Fl.
• C.Call transaction SRUN_ADT and enter the name of the ABAP program.
• D.In the Project Explorer view, right-click the program and choose Run As -► ABAP Application from the context menu.
• E.Open the ABAP program in the ABAP Development perspective and execute it using the shortcut F8.

You use native SQL to access the SAP HANA database. What should you do to retrieve the correct data? There are 3 correct answers to this question.

• A.Specify the database schema if it is not the user's default schema
• B.Use the UP TO n ROWS addition
• C.Use a Comma-separated column list
• D.Explicitly handle the client field
• E.Use the tilde symbol (-) to separate qualifier from column name

What are the steps that supported several tools, which in total result in a Guided Performance Optimization? There are 2 correct answers to this question.

• A.A new tool called SQL Monitor to determine the priority if different programs access the database intensively
• B.Tools analyzing performance at run-time, to determine if critical constructs
• C.A selection Code Inspector (SCI) and ABAP Test Cockpit (ATC) to locate potential functional and performance issues.
• D.The ABAP Trace (SAT) and the ABAP Profiling perspective to measure and compare runtime consumption

One of your SAP systems needs to be migrated from its current database to an SAP HANA database. You want to avoid any functional issues after the migration. What should you search for and if necessary replace in the existing custom ABAP code? There are 3 correct answers to this question.

• A.Code that relies on implicit database sorting
• B.ORDER BY Clauses in Open SQL statements
• C.Direct access to a cluster on the database
• D.Native SQL statements
• E.Left outer joins in open SQL statements