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

The Left-Right approach

The Near-Far approach

The Top-Down approach

The Inside-Out approach

PERFORMANCE_OPT

CHECK_PERFORMANCE

FUNCTIONAL_DB

PERFORMANCE_DB

BAPIs

Analytic View

Tables

Attribute View

It represents SAP HANA's data dictionary.

It contains the design-time artifacts.

All the physical tables and views can be found under the Catalog node.

Bigger Data Set

Better Compression

Better parallel Processing

Faster Data Access

Active clusters for all servers

Shared file systems for only one server

Services-Name and index server on all nodes

High availability configuration

Changes to Delta Container

You need to refresh the content of the container manually

Automatic release of units

Take snapshot manually before releasing of the container

Automatic release of units

Changes to Delta Container

You need to refresh the content of the container manually

Take snapshot manually before releasing of the container

Convert crosstab cells to formula

Analyze data with the design pane

Suggests style sets for crosstabs

Sort data by characteristics

Use the UP TO n ROWS addition

Use the tilde symbol (-) to separate qualifier from column name

Use a Comma-separated column list

Specify the database schema if it is not the user's default schema

Explicitly handle the client field

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

Create a new version of the database when the AMDP is first activated

Delete the obsolete versions of the database procedure synchronously

Delete the obsolete versions of the database procedure asynchronously

Create a new version of the database when the AMDP is first called

You must include the name of the SAP HANA view in the name of the external view.

You can only use native SQL to consume the external view

You must know the underlying tables and join conditions of the SAP HANA view.

You must use the ABAP Development tools (ADT) TO CREATE the external view

Attribute view

Schema view

Column view

Analytical view

Supports arithmetic and string expressions

Supports Code adjustment model

Supports specific units of database

Supports conditional expressions

Service Adaptation Description Language (SADL)

Process Agent Framework (PAF)

ABAP Messaging Channels (AMC)

ABAP Managed Database Procedures (AMDP)

Assembly

O

C++

Java

Referential Join

Language join

Text Join

It is not possible to fetch language-specific data in HANA

Keep unnecessary load away from the database.

Minimize the number of database accesses

Minimize the amount of transferred data

Minimize the search overhead.

ABAP system fields such as sy-langu or sy-mandt \/ CI String constants and literal values

Aggregation functions over fields of ABAP Dictionary tables used in the FROM clause

A field from the structural output of an ABAP Managed Database Procedure used in the FROM clause

A field from the projection list of another CDS view used in the FROM clause

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

Analytic privileges

Package privileges

Application privileges

Object privileges

System privileges

Returning

Receiving

Exporting

Changing

Importing