ABAP on HANA

Question 1

What are the three main capabilities added by HANA

Answer 1

Accelerate
Extend
Innovate

Question 2

What are the steps to transition code to HANA in AS ABAP

Answer 2

Detect
Optimize
Innovate

Question 3

What are the two new parts of an ABAP approach on HANA

Answer 3

Move calculations to the Database and transfer only results to program.
Code to data in HANA vs Data to code in non-HANA

Question 4

Prior to NW 7.4 sp02, how were HANA artifacts accessed from ABAP?

Answer 4

Using native SQL commands

Question 5

Describe 3 things in the bottom up approach with proxy objects

Answer 5

HANA Views expose external views
HANA stored procedures expose Database Procedure Proxy
HANA Delivery Units transport to the SAP HANA transport container

Question 6

Database procedure proxy’s are great, right?

Answer 6

No SAP only recommends using them if no other method is available

Question 7

Since 7.4 SP05 two new objects exist to support AS ABAP and code to data. What are they?

Answer 7

CDS to deploy HANA views

ABAP Managed Database Procedures to deploy HANA stored procedures

Question 8

How has the database oriented programming model been improved

Answer 8

Better SQL-92 support in Open SQL

Extended View definitions

Question 9

Give some examples of the transparent optimizations made in the ABAP stack to facilitate faster data access and presentation

Answer 9

A new data exchange protocol between the database and the ABAP stack
Optimization of the SELECT INTO and SELECT SINGLE
Optimization of the FOR ALL ENTRIES