SAP E_HANAAW_18 Exam Practice Test Instant Access

Question 1

What benefits does SAP HANA Data Compression provide? Note: There are 2 correct answers to this question.

AOptimized data partitioning

BOptimized access to column store tables

COptimized access to column store tables

DIncreased parallel processing

Answer : A, D

Question 2

What must you take into consideration when you use the new Open SQL syntax (available as of SAP NetWeaver 7.4 SP05)? Note: There are 2 correct answers to this question.

AAll classical open SQL statements in your program will become invalid.

BAll ABAP variables must be escaped with a preceding @ sign.

CAll fields in the GROUP BY clause must be separated by commas.

DAll arithmetic expressions can be used for all types of variables.

Answer : B, C

Question 3

User STUDENT_A creates and activates a design-time object. In which schema is the runtime object generated?

ASTUDENT_A

B_SYS_BIC

C_SYS_BI

DSYSTEM

Answer : B

Question 4

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

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 7

Which tools can you use to provide input data for the SQL Performance Tuning Worklist (transaction SWLT)? Note: There are 3 correct answers to this question.

AABAP Test Cockpit (transaction: ATC)

BSQL Trace (transaction: ST05)

CDatabase Performance Monitor (transaction: DB50)

DSQL Monitor (transaction: SQLM)

ECode Inspector (transaction: SCI)

Answer : A, D, E

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