E_HANAAW_17 Online Practice Questions and Answers

Which feature can you use to improve the performance of data transformation in the Extract, Transform and Load (ETL) process?

A. Service Adaptation Description Language (SADL)

B. Process Agent Framework (PAF)

C. ABAP Messaging Channels (AMC)

D. ABAP Managed Database Procedures (AMDP)

What is the main purpose of Analytic Privilege?

A. Restrict users to access database tables

B. Restrict row level access so that user will be able to see only certain portion of the data

C. Restrict user to access modeling view

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.

In order to get language-specific data, which join is used in SAP HANA?

A. Referential Join

B. Language join

C. Text Join

D. It is not possible to fetch language-specific data in HANA

Which of the following is not an element of Analytical view? Please choose the correct answer.

A. Currency conversion is not applicable

B. Join fact tables

C. Read Data from the joined database tables

D. Used to Joined table

Which tools can you use to provide input data for the SQL performance tuning work list (Transaction SWLT)? There are 3 correct answers to this question.

A. Data base performance monitor (transaction DB50)

B. Code inspector (transaction SCI)

C. SQL Trace (transaction ST05)

D. SQL monitor (transaction SQLM)

E. ABAP test cockpit (transaction ATC)

What is the main advantage of SQLScript? (2 answers)

A. SQLScript can be better modularized than traditional SQL

B. SQLScript code can easily be translated into modeling view

C. SQLScript is faster than traditional SQL

What are the features associated with ABAP CDS? There are 3 correct answers to this question.

A. Create

B. Export

C. Update

D. Read

E. Distribution

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 system schema contains the list of Activated and inactive Objects? 2 answers

A. Used to access local or remote database system

B. Maintain, Monitor and test secondary database connection

C. Use Schema for the Connections

D. Maintain only HANA specific objects