E_HANAAW_12 Online Practice Questions and Answers

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

A. Join fact tables

B. Read Data from the joined database tables

C. Currency conversion is not applicable

D. Used to Joined table

What are the steps that supported several tools, which in total result in a Guided Performance Optimization?

There are 2 correct answers to this question.

A. Tools analyzing performance at run-time, to determine if critical constructs

B. A new tool called SQL Monitor to determine the priority if different programs access the database intensively

C. A selection Code Inspector (SCI) and ABAP Test Cockpit (ATC) to locate potential functional and performance issues.

D. The ABAP Trace (SAT) and the ABAP Profiling perspective to measure and compare runtime consumption

What made SAP HANA possible?

There are 2 correct answers to this question.

A. CPU with single core network

B. Improved hardware technology

C. Technology and innovations

D. RAM limitation

What allows you to resolve errors quickly or warnings reported about the code? Please choose the correct answer.

A. ABAP debugger

B. Quick Fix

C. Code execution

D. Debug perspective

What is the main purpose of SAML for SAP HANA Studio? Choose the correct answer

A. To support scenarios where clients are not directly connected to the SAP HANA Database

B. The SAP HANA database supports login of Owners only

C. SAML may be selected as an Owner's authentication method when creating users in the SAP HANA Studio

D. The assertion is issued by a user after the client was successfully authenticated

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

A. Distribution

B. Export

C. Read

D. Update

E. Create

What are the Performance Rules and Guidelines for ABAP on SAP HANA? There are 2 correct answers to this question.

A. To reduce main memory consumption and to improve insert performance

B. It is beneficial to move data-intensive calculations into the database

C. To Keep all the loads away from the DB

D. It is beneficial for maximizing your search into database

What are the features of New Open SQL? There are 2 correct answers to this question.

A. Supports arithmetic and string expressions

B. Supports conditional expressions

C. Supports Code adjustment model

D. Supports specific units of database

How to call the stored procedures in ABAP code? Please choose the correct answer.

A. Open SQL

B. Native SQL

C. Only SQL

D. CDS view

Which of the following are performance recommendations when using SAP HANA? There are 2 correct answers to this question.

A. Define indexes on the columns that are used in calculations.

B. Move data-intensive calculations from the database to an application server.

C. Avoid transferring large result sets between database and client applications.

D. Filter data in lower layers.