Online Access Free E-HANAAW-18 Practice Test

Which rules does SAP recommend to improve the performance of ABAP reports on SAP HANA? Note: There are 2 correct answers to this question.

• A.Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement.
• B.Ensure the access to buffered tables uses the SAP table U buffer.
• C.Ensure the WHERE clause contains at least one index field.
• D.Perform all calculations and aggregations in the ABAP U layer.

What benefits does SAP HANA Data Compression provide? Note: There are 2 correct answers to this question.

• A.Optimized data partitioning
• B.Increased parallel processing
• C.Optimized access to column store tables
• D.Optimized access to column store tables

You define and implement an ABAP Managed Database Procedure (AMDP). What do you have to list after the USING clause? Note: There are 3 correct answers to this question.

• A.SAP HANA views used in the procedure body
• B.ABAP Dictionary tables used in the procedure body
• C.functions used in the procedure body
• D.AMDPs used in the procedure body
• E.ABAP Dictionary views used in the procedure body

You are using a calculated column COUNTS within your Dimension Calculation View and an aggregation node. This is the data that goes into the aggregation node:

• A.N/A
• B.Image 1
• C.Image 3
• D.Image 2

You are debugging in ABAP Development Tools in Eclipse.
What features are available? Note: There are 2 correct answers to
this question.

• A.Conditional breakpoints
• B.Memory usage analysis
• C.Debugger scripting
• D.Watch points