SAP E_HANAAW_18 Exam Practice Test Instant Access

Question 1

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 2

Which of the following takes advantage of the computing power of multiple CPUs used by SAP HANA?

ADatabase table compression

BDictionary encoding

CParallel processing

DColumnar data storage

Answer : C

Question 3

You have created a CDS view as follows: define view zha400 as

select from spfli association^] to sflight as_flights on

spfli.carrid = _flights.carrid and spfli.connid = _flights.connid { ... } Given that table sflight also contains the field planetype, how must you address the fields carrid and planetype from table SFLIGHT?

Acarrid and planetype

Bcarrid and _flights.planetype

C_flights.carrid and planetype

D_flights.carrid and_flights.planetype

Answer : 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 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 6

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 7

User STUDENT_A creates and activates a design-time object. In which schema is the runtime object generated?

ASTUDENT_A

B_SYS_BIC

C_SYS_BI

DSYSTEM

Answer : B

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