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

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 3

You are programming a report that reads data from a secondary HANA database (DB). What do you need to consider in your SQL statement? Note: There are 2 correct answers to this question.

AYou have to use native SQL when reading data from the secondary DB.

BYou have to specify the DB connection explicitly in your statement.

CYou have to specify the DB schema explicitly in your statement.

DAll tables and fields you are using must exist in the ABAP Dictionary of the secondary DB.

Answer : B, C

Question 4

You implement an ABAP-managed database procedure (AMDP). Within this AMDP, you want to query data from calculation view CA_BOOKINGS_COUNT in SAP HANA content package ha400.primdb. How can you address the calculation view? Note There are 2 correct answers to this question.

A'ha400.primdb/CA_BOOKINGS_COUNT'

B'ha400.primdb: :CA_BOOKINGS_COUNT'

C_SYS_BIC.'ha400.primdb/CA_BOOKINGS_COUNT'

D_SYS_BIC.'ha400.primdb::CA_BOOKINGS_COUNT'

Answer : C, D

Question 5

How many result sets are returned when an SAP HANA database procedure is called using the CALL...WITH OVERVIEW statement?

ATwo result sets

BAs many result sets as there are table output parameters in the procedure

COne result set

DAs many result sets as there are input parameters in the procedure

Answer : C

Question 6

Which task does the ABAP Managed Database Procedure (AMDP) framework perform?

ADeploy a new version of the database procedure when the AMDP is first called.

BDeploy the database procedure whenever the AMDP is called.

CDeploy the database procedure when the AMDP is first activated.

DDeploy the database procedure whenever the AMDP is activated.

Answer : A

Question 7

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

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