E_HANAAW_18 Online Practice Questions and Answers

You use ABAP database connectivity (ADBC) to issue native SQL calls to the database, the native SQL call.

Which of the following methods of class CL_SQL_RESULT_SET retrieves the tabular result of the native SQL call? Please choose the correct answer.

A. SET_PARAM_TABLE

B. SET_PARAM

C. EXECUTE_QUERY

D. NEXT_PACKAGE

What are the key points that should be kept in mind while performing the Non-automatic update in SAP HANATr.Cont.? There are 2 correct answers to this question.

A. Automatic release of units

B. Changes to Delta Container

C. You need to refresh the content of the container manually

D. Take snapshot manually before releasing of the container

What is the central goal of using SAP HANA? Please choose the correct answer

A. Positive Impact on Business

B. Accelerate Performance

C. To set Priorities for system

D. Monitor database for record keeping

Which Of the Golden Rules for Open SQL performance have become more important With SAP HANA?

Note: There are 2 correct answers to this question.

A. Keep unnecessary load away from the database.

B. Minimize the number of database accesses

C. Minimize the amount of transferred data

D. Minimize the search overhead.

You are using a calculated column COUNTS within your Dimension Calculation View and an aggregation node. This is the data that goes into the aggregation node:

A. AT Vienna 11 AT Vienna 15 DE Berlin 13 DE Berlin 13

B. AT Vienna 11 AT Vienna 15 DE Berlin 13

C. AT Vienna 26 DE Berlin 26

D. AT Vienna 11 DE Berlin 13

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

Before migrating to SAP HANA, which Code Inspector check do you have to consider to avoid functional regressions?

A. Standard Web Dynpro checks

B. Search for DB operations across modularization units

C. SELECT statements that bypass the table buffer

D. Use of the ADBC interface

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

What all are the Types of Applications based on SAP HANA? There are 2 correct answers to this question.

A. Server based on SAP HANA

B. Innovation based on SAP HANA

C. New or Native SAP HANA

D. Data Mart based on SAP HANA

You created and activated database procedure. How can you call this procedure? There are 2 correct answers to this question.

A. By another database procedure

B. By using Sap Analysis for Microsoft office

C. By a script-based calculation view

D. By a core data services view