E_HANAAW_18 Online Practice Questions and Answers

What are the steps involved in supporting a database oriented programming model? There are 2 correct answers to this question.

A. A new and advanced Open SQL

B. Core Data services

C. Buffer system services

D. Advanced and specific models

What is the full form of HANA?

A. High-Performance Analytic Accelerator

B. High-Performance Analytic Application

C. High Accelerator Numeric Analytics

D. High-Performance Analytic Appliance

Which engine is used to execute Analytic View?

A. SQL Engine

B. Calc Engine

C. OLAP Engine

D. Join Engine

You want to execute a native SQL statement in your program. Why should you use ABAP Database Connectivity (ADBC)? (Choose Two)

A. It has syntax check as compile time.

B. It supports exception handling

C. It supports locking and commit handling

D. It supports where-used list.

What all are the steps to perform -To enable type-ahead for an input field on a screen? There are 3 correct answers to this question.

A. Process on all the input fields

B. Automatic updates of all the input fields

C. Check Pre-Requisites

D. Identify Elementary Search Help

E. Switch on proposal search for input fields

What output does the SAP HANA provide as a unique combination of hardware and software innovations? Please choose the correct answer.

A. Huge potential to optimize business applications that are running on SAP HANA

B. The ability to create new complex processes with ABAP application cloud

C. Huge potential to optimize AMDP application DATA Tables

D. Huge potential to maximize the number of disk blocks in the application

You analyse SQL Monitor data in transaction SQLMD. You know that program X accesses database table Y. You made sure that program X was executed while the SQL Monitor collected its data. But the relevant database access is NOT listed in SQLMD.

What could be the reason?

Note: There are 3 correct answers to this question.

A. SQL Monitor was activated for a specific application server

B. SQL monitor was activated with a filter that excludes database table Y

C. The data has NOT yet been transferred to the SQL monitor database tables

D. Program X was executed in the background.

E. Database table Y is a buffered table.

What is the main advantage of SQLScript? (2 answers)

A. SQLScript can be better modularized than traditional SQL

B. SQLScript code can easily be translated into modeling view

C. SQLScript is faster than traditional SQL

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

What are the different types of Variables in HANA? (3 answers)

A. Range

B. Double

C. Single Value

D. Interval

You create a check variant in the Code Inspector which includes the check 'Search problematic Select * statements'. SAP HANA is used as the db.

In the check parameters, which value would you use for the percentage of fields that are effectively used?

Please choose the correct answer.

A. A value that you calculate based on the number of tables

B. A higher value than on a traditional, row-store only based database

C. A lower value than on a traditional, row-store only based database

D. The same value as on a traditional, row-store only based database

Open SQL largely standardized, three sub-languages. What are these sub-languages? There are 3 correct answers to this question

A. Data Evaluation Language(DEL)

B. The Data Definition Language (DDL)

C. Data Transferring Language(DTL)

D. The Data Control Language (DCL)

E. Data Manipulation Language (DML)

Which statement is true for SAP HANA?

A. SAP has partnered with major hardware providers like HP, FUJITSU, CISCO, IBM, HITACHI etc. SAP only provides SAP HANA software which can run on the hardware provided by these partners

B. SAP provides both hardware and software for SAP HANA.

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

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