SAP E_HANAAW_18 Exam Practice Test Instant Access

Question 1

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 2

What is the purpose of an ABAP project in ABAP Development Tools for Eclipse? Note: There are 2 correct answers to this question.

AIt represents the connection to an ABAP system.

BIt represents the connection to the SAP HANA server.

CIt is used to transport ABAP repository objects.

DIt provides access to all ABAP repository objects in an ABAP system.

Answer : A, D

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

You are using a calculated column COUNTS within your Dimension Calculation View and an aggregation node. This is the data that goes into the aggregation node:

AImage 1

BImage 2

CImage 3

DN/A

Answer : C

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 E_HANAAW_18 SAP Certified Development Specialist - ABAP for SAP HANA 2.0 Exam Practice Test