E_HANAAW_18 Online Practice Questions and Answers

Which of the following feature were added to the ABAP Dictionary to support the SAP HANA database? There are 3 correct answers to this question.

A. De-pooling and de-clustering

B. Changes of data class

C. Definition of full-text indexes

D. Definition of an enhancement category

E. Storage type for tables

Which data sources can you use for SAP list viewer with integrated data access? There are 3 correct answers to this question.

A. CDS View

B. Database procedure

C. External view

D. Database Table

E. Internal table

How will you hide the attributes that are not required for client consumption? Choose the correct answer

A. By setting the hidden property flag of the attribute in the View

B. By setting the hidden property flag of the attribute provider

C. By setting the hidden property flag of the attribute column

D. By setting the hidden property flag of the attribute in the Semantics screen

Which is not a Golden Rule for Open SQL? Please choose the correct answer.

A. Minimize the Number of Database Accesses

B. Reduce the Database Load

C. Minimize the Amount of Data Transferred

D. Keep the result set large

Which of the following is latest release of SAP HANA?

A. SAP HANA 1.0 SP06

B. SAP HANA 1.0

C. SAP HANA 1.6 SP03

D. SAP HANA 2.0 SPS 04

You apply static code checks on your ABAP coding to find potential functional regressions and receive a message about an "Unsecure use of FOR ALL ENTRIES'' issue. Which tool can you use to get additional runtime information?

A. The ABAP Test Cockpit (ATC)

B. The ABAP Code Inspector (SCI)

C. The Runtime Check Monitor (SRTCM)

D. The ABAP runtime error information (ST22)

Which option in SAP NetWeaver Gateway Service Builder (transaction SEGW) can be used to implement the consumption of a Core Data Services view?

A. "Map to Data source"

B. "Consume CDS view"

C. "Relate to Business Entity"

D. "Read from DDL source"

Which functional problem can you detect when using the Runtime Check Monitor (SRTCM )?

A. Existence check for secondary indexes

B. Use of Native SQL and DB Hints

C. Missing ORDER BY or SORT after SELECT

D. Direct access to table pools/cluster

You define a core data services (CDS) View. For which of the following expressions and built in functions must you provide alias? There are 3 correct answers to this question.

A. CASTE Expression

B. CASE expression

C. Currency Conversion

D. Nested CASE expression

E. Unit conversion

In a Graphical calculation view you want to implement a union between two result sets that differ only in the fact that one of the two has one additional field named ADDRESS.

How can you achieve this in a union node? There are 2 correct answers to this question.

A. Create an input parameter for the ADDRESS field

B. Exclude the ADDRESS field from the union

C. Create a restricted column for the ADDRESS field

D. Map the ADDRESS field to a constant value