SAP E_HANAAW_18 Exam Practice Test Instant Access

Question 1

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

AEnsure the access to buffered tables uses the SAP table U buffer.

BPerform all calculations and aggregations in the ABAP U layer.

CEnsure the WHERE clause contains at least one index field.

DUse SELECT FOR ALL ENTRIES instead of a nested SELECT statement.

Answer : C, D

Question 2

Which tools can you use to provide input data for the SQL Performance Tuning Worklist (transaction SWLT)? Note: There are 3 correct answers to this question.

AABAP Test Cockpit (transaction: ATC)

BSQL Trace (transaction: ST05)

CDatabase Performance Monitor (transaction: DB50)

DSQL Monitor (transaction: SQLM)

ECode Inspector (transaction: SCI)

Answer : A, D, E

Question 3

Which functional problem can you detect when using the Runtime Check Monitor (SRTCM)?

ADirect access to Table Pools/Cluster

BMissing ORDER BY or SORT after SELECT

CUse of Native SQL and DB Hints

DExistence check for Secondary Indexes

Answer : B

Question 4

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.

ASAP HANA views used in the procedure body

Bfunctions used in the procedure body

CAMDPs used in the procedure body

DABAP Dictionary tables used in the procedure body

EABAP Dictionary views used in the procedure body

Answer : C, D, E

Question 5

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.

AColumns of compatible types

BThe same number of columns

CAll key fields

DColumns of identical types

Answer : A, B

Question 6

Your development team needs to include SAP HANA objects into an ABAP workbench request. You want to use SAP HANA Transport for ABAP (HTA), and NOT the SAP HANA Transport Container (HTC). Why would you choose HTA? Note: There are 2 correct answers to this question.

ABecause you use the technique that is recommended by SAP.

BBecause you automatically add changed objects to the transport request.

CBecause you can manually re-deploy objects after a failed import.

DBecause you always transport entire SAP HANA content packages.

Answer : A, C

Question 7

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

AOptimized data partitioning

BOptimized access to column store tables

COptimized access to column store tables

DIncreased parallel processing

Answer : A, D

SAP E_HANAAW_18 SAP Certified Development Specialist - ABAP for SAP HANA 2.0 Exam Practice Test