Online Access Free E-HANAAW-17 Exam Questions

You create a check variant in the Code Inspector which includes the check 'Search problematic Select * statements'. SAP HANA is used as the db In the check parameters, which value would you use for the percentage of fields that are effectively used?
Please choose the correct answer.

• A.A lower value than on a traditional, row-store only based database
• B.The same value as on a traditional, row-store only based database
• C.A value that you calculate based on the number of tables
• D.A higher value than on a traditional, row-store only based database

What are best practices when programming in ABAP for SAP HANA? There are 2 correct answers to this question.

• A.Use repeated SELECT SINGLE statements to ensure that you only read arrow if it is really required
• B.Eliminate nested SELECT statements to reduce the overall number of database accesses
• C.Calculate aggregations using ABAP code on the application server to limit database load
• D.Use a column list in the SELECT clause to ensure that you only read a column if it is really required

You perform a static code check using the Code Inspector (SCI). In your SCI variant, you select the Search problematic SELECT * statement check. What does this check report? Please choose the correct answer.

• A.SELECT * statements on tables with the Column Store storage type
• B.SELECT * statements on tables with more than 100,000 records
• C.SELECT * statements on tables with more than a specified number of fields
• D.SELECT * statements where fewer than a specified percentage of all fields are effectively used

What is the main function of Static Code Analysis? Please choose the correct answer.

• A.ABAP source code with performance optimization potential
• B.Integrates with SAP Solution Manager
• C.Integrated into ABAP Development Tools and ABAP Workbench
• D.To detect code that would lead to functional or performance issues When migrating to SAP HANA

Which of the statements are true for SQLScript? (2 answers)

• A.SQLScript is an open standard.
• B.SQLScript is a collection of extensions to SQL.
• C.SQLScript is used to push down data intensive logic into the database.