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

Open the SAP HANA transport containerSelect take snapshot and Save

Activate the SAP HANA Transport Container

Open the SAP HANA delivery unit Select take snapshot and Save Activate the SAP HANA Delivery unit

Activate the SAP HANA transport container

Open the ABAP transport request Select take snapshot and Save

Activate the SAP HANA transport container

Open the package Select take snapshot and Save Activate the SAP HANA Delivery unit

Activate the SAP HANA transport container

Bigger Data Set

Better Compression

Better parallel Processing

Faster Data Access

SQL Monitor was activated for a specific application server

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

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

Program X was executed in the background.

Database table Y is a buffered table.

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

View restrictions

Analytic restrictions

Validity restrictions

Activity restrictions

Cube restrictions

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

select from snwd_so {so_id( sum(net_amount) as sum_amount} order by sojd

select from snwd_so {so_id( sum(net_amount) as sum_amount} group by sojd

select from snwd_so {sojd, sum(net_amount) as sum_amount}

select from snwd_so {so_id( sum(net_amount) as sum_amount} group by net_amount

R3TR TABL

R3TR VIEW

R3TR DDLS

R3TR DDIC

Manage users

Assign Job security

Assign security

Work Management

Create users

A new and advanced Open SQL

Core Data services

Buffer system services

Advanced and specific models

:it_books

it_books

{it.books}

@it_books

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

Active clusters for all servers

Shared file systems for only one server

Services-Name and index server on all nodes

High availability configuration

LEFT OUTER JOIN

CROSS JOIN

FULL OUTER JOIN

RIGHT OUTER JOIN

REFERENTIAL JOIN

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.

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.

By setting the hidden property flag of the attribute in the View

By setting the hidden property flag of the attribute provider

By setting the hidden property flag of the attribute column

By setting the hidden property flag of the attribute in the Semantics screen

Full-text index

Database procedure proxy

ABAP program containing new Open SQL

Core Data service (CDS) view

External view

_SYS_XS

_SYS_BI

_SYS_REP0

_SYS_BIC

To detect code that would lead to functional or performance issues When migrating to SAP HANA

Integrates with SAP Solution Manager

Integrated into ABAP Development Tools and ABAP Workbench

ABAP source code with performance optimization potential

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

Perform business logic and aggregations on database table content, then transfer the results to the application layer.

Perform join operations on database tables, then transfer the results to the application layer.

Perform calculations on data transferred to the database layer, then transfer the results back to the application layer.

Perform text search operations on database table content, then transfer the results to the application layer.

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.