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 feature can you use to improve the performance of data transformation in the Extract, Transform and Load (ETL) process?

A. Service Adaptation Description Language (SADL)

B. Process Agent Framework (PAF)

C. ABAP Messaging Channels (AMC)

D. ABAP Managed Database Procedures (AMDP)

Which rules does SAP recommended to improve the performance of ABAP report on SAP HANA? There are 2 correct answers to this question.

A. Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement

B. Use array variants of INSERT UPDATE MODIFY and DELETE

C. Use a nested SELECT statement instead of SELECT FOR ALL ENTRIES

D. Perform all calculations and aggregations in the ABAP layer

You want to debug an ABAP program using ABAP development tools (ADT). How do you launch the debugger? Please choose the correct answer.

A. Choose the debug as option in the context menu of the ABAP program

B. Create a debug configuration for the ABAP application and run the program

C. Set a breakpoint in the ABAP program and execute the program

D. Choose the Run --> Debug options in the menu

Which of the following information is mandatory in the definition of an association in a Core Data Services (CDS) view?

A. The filter condition for the association

B. The cardinality of the association

C. The alias for the association

D. The target entity of the association

Which of the statements are true for SQLScript? (2 answers)

A. SQLScript is an open standard.

B. SQLScript is used to push down data intensive logic into the database.

C. SQLScript is a collection of extensions to SQL.

List down the elements involved in User Management and Security in SAP Hana? There are 3 correct answers to this question

A. Manage users

B. Assign Job security

C. Assign security

D. Work Management

E. Create users

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

Which of the following ABAP language elements are mandatory for the implementation of a method as an ABAP Managed Database Procedure? 3 answers

A. FOR db (db = HDB...)

B. LANGUAGE dbjang (dbjang = SQLSCRIPT...)

C. BY DATABASE PROCEDURE

D. CLIENT SPECIFIED

E. AUTHORIZATION db_auth (db_auth = SYSTEM ...)

You create a check variant in the Code Inspector which includes the check 'Search problematic Select *

statements'. SAP HANA is used as the db.

In the check parameters, which value would you use for the percentage of fields that are effectively used?

Please choose the correct answer.

A. A value that you calculate based on the number of tables

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

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

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