E_HANAAW_18 Online Practice Questions and Answers

Which code-to-data capability is responsible for the Optimizations and Translation of "Open SQL SELECT FOR ALL ENTRIES clauses into native SQL?. Please choose the correct answer.

A. Database Optimization

B. Transparent Optimizations

C. HANA Specific features

D. Buffer system Optimization

Which of the following is true? (2 correct answers)

A. A read only procedure cannot call read-write procedure.

B. A Read-write procedure cannot call another read-write procedure.

C. A read-write procedure can call both read-write and read only procedures.

What is Core Data Services (CDS)?

A. A collection of services that provide information about the data volumes of the SAP HANA core tables

B. A collection of services for ABAP application programming that provide access to the core features of the SAP HANA database management system

C. A collection of core features and services that provide data from the ABAP application server layer to the user interface

D. A collection of domain-specific languages and services for definition and consumption of semantically rich data models

Which of the following can be part of an analytic view? (3 answers)

A. Query transformation

B. Logical joins

C. Attributes

D. Data foundation

E. Unions

Which of the below has huge negative impact on performance? (2 answers)

A. Mixing up SQL statement and CE functions

B. Join on calculated column

C. Inner Join

What you must do when you define and implement an ABAP Managed Database Procedure AMDP? There are 3 correct answers to this question.

A. Define all the method parameters to pass by value

B. List all the ABAP dictionary tables used in the procedure body in the USING clause

C. Use Scalar types for all the AMDP method parameters

D. Specify the database system and language

E. Mark the AMDP method as read-only

Which of the following ABAP transactions can you use to detect SQL performance optimization potential in your ABAP code? 2 answers

A. SQLM

B. SE09

C. SWLT

D. ST22

E. SE3S

What are the advantages of column based tables? (3 correct answers)

A. Bigger Data Set

B. Better Compression

C. Better parallel Processing

D. Faster Data Access

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

What are the Functions of Transaction DBACOCKPIT There are 2 correct answers to this question.

A. Use Schema for the Connections

B. Maintain, Monitor and test secondary database connection

C. Maintain only HANA specific objects

D. Used to access local or remote database system