E_HANAAW_17 SAP Certified Development Specialist - ABAP for SAP HANA 2.0 Questions and Answers

System Defined Schema

User Defined Schema

SLT Derived Schema

Dynamic Schema

:it_books

it_books

{it.books}

@it_books

SQL Engine

Calc Engine

OLAP Engine

Join Engine

Restrict users to access database tables

Restrict row level access so that user will be able to see only certain portion of the data

Restrict user to access modeling view

Database Optimization

Transparent Optimizations

HANA Specific features

Buffer system Optimization

Collect all the data and perform parallel processing in ABAP

Creating and consuming all the contents from network

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

Keep load from the database

SQL units

Consume using native SQL

Stored Procedures

Interaction with Database

It has syntax check as compile time.

It supports exception handling

It supports locking and commit handling

It supports where-used list.

It establishes a governance process for performance optimizations.

It automatically translates ABAP coding to SQLScript.

It allows you to correlate the results of an ABAP source code analysis with SQL runtime data.

It allows you to simulate the impact of performance optimization patterns.

_SYS_BI

_SYS_REPO

_SYS_XS

_SYS_BIC

CL_SQL_EXECUTE_QUERY

CL_SQL_RESULT_SET

CL_SQL_STATEMENT

CL_EXEC_SQL

CL_ADBC_SQL_STATEMENT

It collects monitoring data asynchronously without additional database interaction.

It schedules ABAP programs to monitor and log all database accesses.

It displays the database execution plan for all SQL statements.

It can be active in a production system with minimal performance overhead.

When you require aggregation and analysis of values

When the table has a small number of records

When there are mainly distinct values in the table

When you want to enable a full-text-search of the table

SQLM

SE09

SWLT

ST22

SE3S

Calculate aggregations using ABAP code on the application server to limit database load

Eliminate nested SELECT statements to reduce the overall number of database accesses

Use a column list in the SELECT clause to ensure that you only read a column if it is really required

Use repeated SELECT SINGLE statements to ensure that you only read arrow if it is really required

ABAP Dictionary views used in the procedure body

ABAP Dictionary table used in the procedure body

AMDP used in the procedure body

function used in the procedure body

SAP HANA views used in the procedure body

It deletes obsolete versions of the database procedure synchronously

It deletes obsolete versions of the database procedure asynchronously

It creates the database procedure when the AMDP is first called.

It creates the database procedure when the AMDP is first activated.

Manage users

Assign Job security

Assign security

Work Management

Create users

Read

Create

Delete/Edit Table

Update

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.

A value that you calculate based on the number of tables

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

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

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

carrid and _flights.planetype

_ flights.carrid and planetype

carrid and planetype

flights.carrid and _flight.s .planetype

Because you can manually re-deploy objects after a failed import

Because you always transport entire SAP HANA content packages

Because you use the technique that is recommended by SAP

Because you automatically add changed objects to the transport request