E_HANAAW_18 Online Practice Questions and Answers

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

Which data sources can you use for SAP list viewer with integrated data access? There are 3 correct answers to this question.

A. CDS View

B. Database procedure

C. External view

D. Database Table

E. Internal table

Which code-to-data capability is responsible for the Optimizations and Translation of "Open SQL SELECT FOR ALL ENTRIES clauses into native SQL?. Please choose the correct answer.

A. Database Optimization

B. Transparent Optimizations

C. HANA Specific features

D. Buffer system Optimization

You import an ABAP workbench request into a SAP SYSTEM P81. The ABAP workbench request contains a single SAP HANA VIEW CA_CUSTOMER that belongs to package 2HA400_00. WHICH PREREQISITIES are mandatory for an implicit deployment of the SAP HANA view onto the database? There are 2 correct answers to this question.

A. View CA_CUSTOMER has deployment mode A.

B. Package ZHA400_00 Is listed in table SNHI_DUP_PREWORK

C. SYSTEM P81 has SAP HANA has primary database

D. PACKAGE ZHA400J30 HAS deployment Mode A

You have created a CDS view and used alias names for some of its elements. In which of the following cases is the alias name mandatory? Note: There are 3 correct answers to this question.

A. CAST( 'USO' AS abap.cuky) AS currency_key

B. SUM( revenue ) AS total_revenue

C. Crtdby AS created_by

D. CASE order type WHEN 'A' THEN 1 ELSE 0 END AS Order_type

E. ASSOCIATION TO sflight AS_flights

In ABAP Development Tools for SAP NetWeaver, you execute the ABAP Test Cockpit on an ABAP program to find performance optimization potential.

Where can you find the result of the static code checks?

A. In the Problems view

B. In the Project Explorer view

C. In the Performance Analysis view

D. In the Outline view of the ABAP Performance perspective

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 execute a Native SQL query statement to retrieve a list of information using the corresponding ABAP Database Connectivity (ADBC) API method.

Which additional steps are necessary to retrieve the result set into an internal table? 2 answers

A. Close the CL_SQL_STATEMENT object to release the resources.

B. Use an Open SQL query that uses the JOIN between the result set and the internal table as a data source.

C. Bind a reference to the internal table as an output parameter to the CL_SQL_RESULT_SET instance.

D. Fetch the result using the next_package method of class CL_SQL_RESULT_SET.

E. Fetch the result using the fetch method of class CL_SQL_EXECUTE.

Which of the following are classes of the ABAP Database Connectivity (ADBC) API? 2 answers

A. CL_SQL_EXECUTE_QUERY

B. CL_SQL_RESULT_SET

C. CL_SQL_STATEMENT

D. CL_EXEC_SQL

E. CL_ADBC_SQL_STATEMENT

What is the system privilege required to drop analytic privilege?

A. CREATE STRUCTURED PRIVILEGE

B. STRUCTUREDPRIVILEGE ADMIN

C. PRIVILEGE ADMIN

D. CREATE PRIVILEGE

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

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

How can you consume a Core Data Services (CDS) view? 2 answers

A. Use the Data Preview in ABAP Development Tools for SAP NetWeaver.

B. Use it as a data source in the FROM clause of an Open SQL query.

C. Use the ABAP language statement WRITE and the CDS view name as the argument.

D. Use the CDS maintenance transaction (SCDSV).

Which of the below statements are true for SAP HANA Studio? (3 answers)

A. SAP HANA Studio can be used to manage the SAP HANA database, to create and manage user authorizations, to create new or modify existing models of data etc

B. SAP HANA Studio is an Eclipse-based, integrated development environment (IDE) that is used to develop artifacts in a HANA server.

C. SAP HANA Studio is a client tool, which can be used to access local or remote HANA system.

D. SAP HANA Studio is integrated in SAP GUI > 7.40

What is an attribute view and what are its practices? There are 3 correct answers to this question.

A. May contain filters

B. Used in diagrammatic Projections

C. May use in calculation views

D. Used to join tables

E. May contains flow charts