Free SAP E_HANAAW_18 Exam Dumps Questions & Answers

You want to move some of the logic of an ABAP program into an ABAP-managed database procedure (AMDP). To do so, you need to translate Open SQL statements into SAP HANA Native SQL. Which of the following are necessary adjustments? Note: There are 3 correct answers to this question.

• A.Specify the schema for every table.
• B.Replace UP TO n ROWS additions.
• C.Replace ORDER BY additions.
• D.Add explicit client handling.
• E.Replace CORRESPONDING FIELDS additions.

Which of the Golden Rules for Open SQL Performance have become more important with SAP HANA? Note: There are 2 correct answers to this question.

• A.Minimize the number of database accesses.
• B.Minimize the amount of transferred data.
• C.Minimize the search overhead.
• D.Keep unnecessary load away from the database.

You define a Core Data Services (CDS) view to merge the results of queries using the UNION keyword. What must the column lists of these queries contain? Note: There are 2 correct answers to this question.

• A.Columns of identical types
• B.The same number of columns
• C.Columns of compatible types
• D.All key fields

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.Image 2
• B.Image 3
• C.N/A
• D.Image 1

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

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