SAP E_HANAAW_18 Exam Questions Instant Access

Question 1

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.

AMinimize the number of database accesses.

BMinimize the amount of transferred data.

CKeep unnecessary load away from the database.

DMinimize the search overhead.

Answer : A, B

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

You have created a CDS view and used alias names for some of its elements. In which of the following cases is the alias name mandatory? Note: There are 3 correct answers to this question.

ACASE ordertype WHEN 'A' THEN 1 ELSE 0 END AS order_type

BCAST( 'USD' AS abap.cuky ) AS currency_key

Ccrtdby AS created_by

DSUM( revenue ) AS total_revenue

EASSOCIATION TO sflight AS .flights

Answer : A, B, D

Question 4

You want to execute a native SQL statement in your program. Why should you use ABAP Database Connectivity (ADBC)? Note: There are 2 correct answers to this question.

AIt supports locking and commit handling.

BIt has syntax check at compile time.

CIt supports exception handling.

DIt supports where-used list.

Answer : C, D

Question 5

Which step of the Guided Performance Analysis should you perform in the production system?

AExecuting a check run with ABAP Test Cockpit (ATC)

BCollecting data with SQL Monitor (SQLM)

CPerforming an inspection with Code Inspector (SCI)

DBuilding a work list with SQL Performance Tuning Worklist (SWLT)

Answer : B

Question 6

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

Question 7

Why would you implement Smart Data Access (SDA)?

ATo replicate data between SAP ECC and SAP HANA

BTo define caching rules based on usage patterns

CTo generate delta images when sources cannot provide this function

DTo provide real-time access to remote data sources

Answer : A

SAP Certified Development Specialist - ABAP for SAP HANA 2.0 E_HANAAW_18 Exam Questions