E_HANAAW_18 Online Practice Questions and Answers

In addition to closing the result set. What does the CLOSE method of the CL_SQL_RESULT_SET class when using ABAP Database Connectivity (ADBC) do? Please choose the correct answer.

A. Release resources

B. Update resources

C. Update resources

D. Update packages

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)

Which is better from performance point of view?

A. SQLScript Procedure

B. Modeling Views

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

A. SYS_BI

B. SYSTEM

C. _SYS_BIC

D. STUDENT_A

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

While creating a Graphical Calculation view, what are the options available in Tools palette? (4 answers)

A. Union

B. Cast

C. Aggregation

D. Projection

E. Join

F. Distinct

Which components can be a part of a calculation view? (2 answers)

A. BAPIs

B. Analytic View

C. Tables

D. Attribute View

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

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 is the purpose of an ABAP project in ABAP Development tools for eclipse? (2 answers)

A. It provides access to all ABAP repository objects in an ABAP system.

B. It represents the connection to an ABAP system

C. It represents the connection to the SAP HANA server

D. It is used to transport ABAP repository objects