Free SAP E-HANAAW-12 Exam Dumps Questions & Answers

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

• A.Move data-intensive calculations from the database to an application server.
• B.Filter data in lower layers.
• C.Define indexes on the columns that are used in calculations.
• D.Avoid transferring large result sets between database and client applications.

Discuss the basic approach of classical ABAP programming?
There are 2 correct answers to this question.

• A.Creating and consuming all the contents from network
• B.Get all the data you need on the application server and do your processing in ABAP
• C.Keep load from the database
• D.Collect all the data and perform Parallel processing in ABAP

You have defined the following SQLScript procedure:
CREATE PROCEDURE LANGUAGE SQLSCRIPT SQL SECURITY DEFINER READS
SQL DATA
Which type of database procedures can be called in this SQLScript procedure?
Please choose the correct answer.

• A.Read-write
• B.Read only
• C.Read-update
• D.Write only

What are the Guidelines for optimizing ABAP code running on HANA?
There are 3 correct answers to this question.

• A.High-speed data analysis
• B.Column store
• C.Technical settings
• D.Open SQL settings
• E.DB specific properties

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

• A.To Keep all the loads away from the DB
• B.It is beneficial to move data-intensive calculations into the database
• C.To reduce main memory consumption and to improve insert performance
• D.It is beneficial for maximizing your search into database