Question 1

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 2

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

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 5

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

Free Practice Questions for SAP E_HANAAW_18 Exam

Question 1

Question 2

Question 3

Question 4

Question 5