SAP E_HANAAW_18 Exam Questions Instant Access

Question 1

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 2

You import an ABAP workbench request into an SAP system P81. The ABAP workbench request contains a single SAP HANA view CA_CUSTOMER that belongs to SAP HANA content package ZHA400_00. Which prerequisites are mandatory for an implicit deployment of the SAP HANA view onto the database? Note: There are 2 correct answers to this question.

AView CA_CUSTOMER has deployment mode A.

BPackage ZHA400_00 has deployment mode A.

CSystem P81 has SAP HANA as primary database.

DPackage ZHA400_00 is listed in table SNHI DUP PREWORK.

Answer : C, D

Question 3

In SAP HANA SQL, you want to create a table whose definition should NOT be visible in the catalog. Which of the following table types fulfill this requirement?

AHISTORY COLUMN

BGLOBAL TEMPORARY

CLOCAL TEMPORARY

DROW

Answer : C

Question 4

You developed an ABAP Managed Database Procedure (AMDP). You want to allow the enhancement of this AMDP using a Business Add-In (BAdI). Which of the following objects must you create? Note: There are 3 correct answers to this question.

AA BAdI fallback implementation

BA BAdI definition

CA database procedure

DAn enhancement spot

EA BAdI sample implementation

Answer : A, B, D

Question 5

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

You use ABAP Database Connectivity (ADBC) to issue native SQL calls to the database. Which method of class CL_SQL_RESULT_SET retrieves the entire result set of the native SQL call?

ASET_PARAM_TABLE

BNEXT

CEXECUTE_QUERY

DNEXT_PACKAGE

Answer : D

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