E_HANAAW_18 Online Practice Questions and Answers

Explain the Enterprise Information System of- SAP HANA Implementation Scenarios? There are 3 correct answers to this question

A. HANAAccelerators

B. All HANA Combinations on one platform

C. HANA Modeling

D. All SAP applications on one SAP HANA platform

E. Business Suite on HANA/ BW on SAP HANA

Which is better from performance point of view?

A. SQLScript Procedure

B. Modeling Views

One of your SAP systems needs to be migrated from its current database to an SAP HANA database. You want to avoid any functional issues after the migration.

What should you search for and if necessary replace in the existing custom ABAP code? There are 3 correct answers to this question.

A. Direct access to a cluster on the database

B. Left outer joins in open SQL statements

C. Native SQL statements

D. Code that relies on implicit database sorting

E. ORDER BY Clauses in Open SQL statements

What are the principles of Using HANA Transport Containers properly? There are 3 correct answers to this question.

A. Import of Transport Request

B. To create Transport container of delivery unit

C. Automatic update for all export methods

D. Release of Transport request

E. Takes a 'snapshot' of all SAP HANA objects of delivery unit

What are the Possible Approaches with AS ABAP < 7.4 SP02? There are 2 correct answers to this question

A. SQL units

B. Consume using native SQL

C. Stored Procedures

D. Interaction with Database

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. Write only

D. Read-update

Which SQL syntax is used to create a read only procedure?

A. READS SQL DATA

B. READS PROCEDURE

C. NO-SIDE-EFFECT

D. READ-ONLY

In ADT which setting below to a specific project rather than the entire workbench. Choose the correct answer

A. Code completion option

B. Statement Template options

C. Editor shortcut options

D. Code formatting option

Which of the below statements are true for SAP HANA Studio? (3 answers)

A. SAP HANA Studio can be used to manage the SAP HANA database, to create and manage user authorizations, to create new or modify existing models of data etc

B. SAP HANA Studio is an Eclipse-based, integrated development environment (IDE) that is used to develop artifacts in a HANA server.

C. SAP HANA Studio is a client tool, which can be used to access local or remote HANA system.

D. SAP HANA Studio is integrated in SAP GUI > 7.40

You changed an SAP HANA object that you transported using an SAP HANA Transport container. You want to release the transport request with your changes.

In which sequence do you perform activities in the ABAP development system immediately before the release? Please choose the correct answer.

A. Open the SAP HANA transport containerSelect take snapshot and Save Activate the SAP HANA Transport Container

B. Open the SAP HANA delivery unit Select take snapshot and Save Activate the SAP HANA Delivery unit Activate the SAP HANA transport container

C. Open the ABAP transport request Select take snapshot and Save Activate the SAP HANA transport container

D. Open the package Select take snapshot and Save Activate the SAP HANA Delivery unit Activate the SAP HANA transport container