Online Access Free E-HANAAW-16 Practice Test

Which of the following is a limitation when you create an external view? Please choose the correct answer.

• A.You can only use native SQL to consume the external view
• B.You must use the ABAP Development tools (ADT) TO CREATE the external view
• C.You must know the underlying tables and join conditions of the SAP HANA view.
• D.You must include the name of the SAP HANA view in the name of the external view.

What is the main benefit of the SQL Performance Tuning Worklist?

• A.It automatically translates ABAP coding to SQLScript.
• B.It allows you to correlate the results of an ABAP source code analysis with SQL runtime data.
• C.It allows you to simulate the impact of performance optimization patterns.
• D.It establishes a governance process for performance optimizations.

What should you do to follow the code-to-data approach to programming? 2 ans

• A.Perform expensive calculations on the ABAP application server.
• B.Aggregate data on the database, and transfer the results to the ABAP layer.
• C.Perform expensive calculations on the database
• D.Transfer all data from the database to the ABAP layer, and then aggregate the results.

ANSI SQL owns features and adds languages. These languages divided into three parts. What are they? There are 3 correct answers to this question.

• A.Data Transferred Language
• B.The Database Language
• C.The Data Control Language
• D.The Data Definition Language
• E.Data Manipulation Language

What are the key points that should be kept in mind while performing the Nonautomatic update in SAP HANA Transport Container? (2 right answers)

• A.You need to refresh the content of the container manually
• B.Automatic release of units
• C.Changes to Delta Container
• D.Take snapshot manually before releasing of the container