SAP E_HANAAW_18 Exam Practice Test Instant Access

Question 1

You define a Core Data Services (CDS) view to merge the results of queries using the UNION keyword. What must the column lists of these queries contain? Note: There are 2 correct answers to this question.

AColumns of compatible types

BThe same number of columns

CAll key fields

DColumns of identical types

Answer : A, 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

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 4

You are debugging in ABAP Development Tools in Eclipse.

What features are available? Note: There are 2 correct answers to

this question.

ADebugger scripting

BWatch points

CConditional breakpoints

DMemory usage analysis

Answer : B, C

Question 5

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 6

Which rules does SAP recommend to improve the performance of ABAP reports on SAP HANA? Note: There are 2 correct answers to this question.

AEnsure the access to buffered tables uses the SAP table U buffer.

BPerform all calculations and aggregations in the ABAP U layer.

CEnsure the WHERE clause contains at least one index field.

DUse SELECT FOR ALL ENTRIES instead of a nested SELECT statement.

Answer : C, D

Question 7

Which of the following tools and programming techniques use the SQL Data Definition Language? Note: There are 2 correct answers to this question.

ACore Data Services (CDS) access control

BCore Data Services (CDS) data definition

COpen SQL

DABAP Dictionary

Answer : B, C

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