What are the steps involved in supporting a database oriented programming model? There are 2 correct answers to this question.

A. A new and advanced Open SQL

B. Core Data services

C. Buffer system services

D. Advanced and specific models

Which of the following is not an element of Analytical view? Please choose the correct answer.

A. Currency conversion is not applicable

B. Join fact tables

C. Read Data from the joined database tables D. Used to Joined table

Discuss the basic approach of classical ABAP programming. 2 answers

A. Collect all the data and perform parallel processing in ABAP

B. Creating and consuming all the contents from network

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

D. Keep load from the database

You analyse SQL Monitor data in transaction SQLMD. You know that program X accesses database table Y. You made sure that program X was executed while the SQL Monitor collected its data. But the relevant database access is NOT listed in SQLMD.

What could be the reason?

Note: There are 3 correct answers to this question.

A. SQL Monitor was activated for a specific application server

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

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

D. Program X was executed in the background.

E. Database table Y is a buffered table.

You want to implement business logic on the database layer.

Which approach do you follow when implementing an ABAP Managed Database Procedure?

A. The Left-Right approach

B. The Near-Far approach

C. The Top-Down approach

D. The Inside-Out approach

What are the two types of editors available in ADT? There are 2 correct answers to this question.

A. Eclipse (native)

B. Client (native)

C. SAP (GUI)

D. ABAP (native)

Which tasks does the ABAP managed database (AMDP) framework perform? There are 2 correct answers to this question.

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

B. Delete the obsolete versions of the database procedure synchronously

C. Delete the obsolete versions of the database procedure asynchronously

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

Which SQL syntax is used to create a read only procedure?

A. READS SQL DATA

B. READS PROCEDURE

C. NO-SIDE-EFFECT

D. READ-ONLY

Which recent software innovations are applied in SAP HANA? 3 answers

A. Columnar data storage

B. Automated de-installation at system shutdown

C. Improved data compression algorithms

D. Insert Only approach

E. Random Undefined Multi-Memory Swapping (RUMMS)

You have an SQLScript procedure with a table input parameter it_books. You want to use the parameter on the right-hand side of an assignment operator within the procedure. How do you refer to the parameter? Please choose the correct answer.

A. :it_books

B. it_books

C. {it.books}

D. @it_books