Which Of the Golden Rules for Open SQL performance have become more important With SAP HANA?

Note: There are 2 correct answers to this question.

A. Keep unnecessary load away from the database.

B. Minimize the number of database accesses

C. Minimize the amount of transferred data

D. Minimize the search overhead.

For which purpose can you use literal values in an Open SQL statement?

A. To perform a generic existence check

B. To provide a default value for a database table column

C. To alias the result of an arithmetic expression

D. To comment your development directly in the coding

You use native SQL to access the SAP HANA database. What should you do to retrieve the correct data? There are 3 correct answers to this question.

A. Use the UP TO n ROWS addition

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

C. Use a Comma-separated column list

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

E. Explicitly handle the client field

Discuss the basic approach of classical ABAP programming? There are 2 correct answers to this question.

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

B. Creating and consuming all the contents from network

C. Keep load from the database

D. Collect all the data and perform Parallel processing in ABAP

You plan a database migration to SAP HANA and want to check your ABAP coding for potential functional

regressions.

Which Code Inspector check variant can you use?

A. PREV_FUNC_REG

B. FUNCTIONAL_DB

C. FUNCTIONAL_CHECK

D. PERFORMANCE DB

Which option in SAP NetWeaver Gateway Service Builder (transaction SEGW) can be used to implement the consumption of a Core Data Services view?

A. "Map to Data source"

B. "Consume CDS view"

C. "Relate to Business Entity"

D. "Read from DDL source"

Which system schema contains the list of Activated and inactive Objects? 2 answers

A. Used to access local or remote database system

B. Maintain, Monitor and test secondary database connection

C. Use Schema for the Connections

D. Maintain only HANA specific objects

In ADT which setting below to a specific project rather than the entire workbench. Choose the correct answer

A. Code completion option

B. Statement Template options

C. Editor shortcut options

D. Code formatting option

You want to move some of the logic of an ABAP program into an ABAP-managed database procedure

(AMDP). To do so, you need to translate Open SQL statements into SAP HANA Native SQL.

Which of the following are necessary adjustments? Note: There are 3 correct answers to this question.

A. Replace UP TO n ROWS additions

B. Specify the schema for every table

C. Replace ORDER BY additions

D. Replace CORRESPONDING FIELDS additions

E. Add explicit client handling

What is the purpose of an ABAP project in ABAP Development tools for eclipse? (2 answers)

A. It provides access to all ABAP repository objects in an ABAP system.

B. It represents the connection to an ABAP system

C. It represents the connection to the SAP HANA server

D. It is used to transport ABAP repository objects