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 are some of the features available for SAP List Viewer with Integrated Data Access (ALV IDA)? Note: There are 3 correct answers to this question.

AGroup rows

BEdit cells

CSearch in content

DDisplay diagrams

EDouble-click on rows

Answer : A, C, E

Question 3

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 4

Which of the following repository objects can you edit only in ABAP Development Tools in Eclipse, and NOT in the classical ABAP Workbench? Note: There are 3 correct answers to this question.

AData Definition

BABAP class with new Open SQL Syntax

CFull-text index

DDatabase Procedure Proxy

EABAP class with SQL script coding

Answer : B, D, E

Question 5

You want to move some of the logic of an ABAP program into an ABAP-managed database procedure (AMDP). To do so, you need to translate Open SQL statements into SAP HANA Native SQL. Which of the following are necessary adjustments? Note: There are 3 correct answers to this question.

AReplace UP TO n ROWS additions.

BReplace ORDER BY additions.

CSpecify the schema for every table.

DReplace CORRESPONDING FIELDS additions.

EAdd explicit client handling.

Answer : A, C, E

Question 6

In an ABAP Core Data Services (CDS) view, what must you do to expose an association for use in another CDS view?

AInclude all fields used in the ON condition in the projection

BDefine the cardinality for the target entity.

CSpecify an alias for the target entity.

DSpecify the other views in which the association can be used.

Answer : A

Question 7

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

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