E_HANAAW_17 Sample Questions Answers

Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement

Use array variants of INSERT UPDATE MODIFY and DELETE

Use a nested SELECT statement instead of SELECT FOR ALL ENTRIES

Perform all calculations and aggregations in the ABAP layer

Data Manipulation Language

The Data Control Language

The Database Language

The Data Definition Language

Data Transferred Language

Database Optimization

Transparent Optimizations

HANA Specific features

Buffer system Optimization

Get all the data you need on the application server and do your processing in ABAP

Creating and consuming all the contents from network

Keep load from the database

Collect all the data and perform Parallel processing in ABAP

In the Project Explorer view, right-click the program and choose Run As —► ABAP Application from the context menu.

Use the Open Development Object dialog (CTRL+SHIFT+A) and enter /Execute in the search field.

Open the ABAP program in the ABAP Development perspective and execute it using the shortcut F8.

Open the ABAP program in the ABAP Development perspective and execute it using the shortcut Fl.

Call transaction SRUN_ADT and enter the name of the ABAP program.

Service Adaptation Description Language (SADL)

Process Agent Framework (PAF)

ABAP Messaging Channels (AMC)

ABAP Managed Database Procedures (AMDP)

CL_SQL_EXECUTE_QUERY

CL_SQL_RESULT_SET

CL_SQL_STATEMENT

CL_EXEC_SQL

CL_ADBC_SQL_STATEMENT

ROW

GLOBAL TEMPORARY

COLUMN

LOCAL TEMPORARY

High-Performance Analytic Accelerator

High-Performance Analytic Application

High Accelerator Numeric Analytics

High-Performance Analytic Appliance

Create an input parameter for the ADDRESS field

Exclude the ADDRESS field from the union

Create a restricted column for the ADDRESS field

Map the ADDRESS field to a constant value

Convert crosstab cells to formula

Analyze data with the design pane

Suggests style sets for crosstabs

Sort data by characteristics

_SYS_BIC

_SYS_REPO

_SYS_XS

_SYS_BI

Use the enhanced options in transaction SE11.

Use the fuzzy-search exit in transaction SE11.

Modify the search help with the Native SQL command ALTER SEARCH HELP.

Enhance the lookup table with an additional ACCURACY field and insert an accuracy value.

Standard Web Dynpro checks

Search for DB operations across modularization units

SELECT statements that bypass the table buffer

Use of the ADBC interface

SQLScript is an open standard.

SQLScript is used to push down data intensive logic into the database.

SQLScript is a collection of extensions to SQL.

R3TR TABL

R3TR VIEW

R3TR DDLS

R3TR DDIC

Core Data Services

ITe services

Conditional services

Modell-ll services

Server based on SAP HANA

Innovation based on SAP HANA

New or Native SAP HANA

Data Mart based on SAP HANA

CROSS JOIN

INNER JOIN

REFERENTIAL JOIN

LEFT OUTER JOIN

RIGHT OUTER JOIN

SELECT * statements where fewer than a specified percentage of all fields are effectively used

SELECT * statements on tables with more than a specified number of fields

SELECT * statements on tables with more than 100,000 records

SELECT * statements on tables with the Column Store storage type

Active clusters for all servers

Shared file systems for only one server

Services-Name and index server on all nodes

High availability configuration

Process on all the input fields

Automatic updates of all the input fields

Check Pre-Requisites

Identify Elementary Search Help

Switch on proposal search for input fields

Direct access to a cluster on the database

Left outer joins in open SQL statements

Native SQL statements

Code that relies on implicit database sorting

ORDER BY Clauses in Open SQL statements