SAP E_HANAAW_18 Exam Questions Instant Access

Question 1

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 2

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 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

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

Question 5

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 6

Which of the following features does the ABAP Test Cockpit offer that the ABAP Code Inspector does NOT offer? Note: There are 2 correct answers to this question.

AFlexible schedule of check runs

BEnhanced distribution of results

CDocumented checks

DConfiguration of check variants

Answer : A, B

Question 7

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

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