Online Access Free E_HANAAW_14 Exam Questions

Which rules does SAP recommended to improve the performance of ABAP report on SAP HANA? There are
2 correct answers to this question.

• A.Use a nested SELECT statement instead of SELECT FOR ALL ENTRIES
• B.Use array variants of INSERT UPDATE MODIFY and DELETE
• C.Perform all calculations and aggregations in the ABAP layer
• D.Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement

You have an SQLScript procedure with a table input parameter it_books. You want to use the parameter on the right-hand side of an assignment operator within the procedure. How do you refer to the parameter? Please choose the correct answer.

• A.@it_books
• B.{it.books}
• C.:it_books
• D.it_books

What are some of the features available SAP List Viewer with integrated data access (SALV IDA)? There are
3 correct answers to this question.

• A.Display diagrams
• B.Search in content
• C.Edit cells
• D.Double-click on rows
• E.Group rows

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

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

In a Graphical calculation view you want to implement a union between two result sets that differ only in the fact that one of the two has one additional field named ADDRESS. How can you achieve this in a union node?
There are 2 correct answers to this question.

• A.Create an input parameter for the ADDRESS field
• B.Exclude the ADDRESS field from the union
• C.Create a restricted column for the ADDRESS field
• D.Map the ADDRESS field to a constant value