E_HANAAW_17 Online Practice Questions and Answers

What are the key points that should be kept in mind while performing the Non-automatic update in SAP HANATr.Cont.? There are 2 correct answers to this question.

A. Automatic release of units

B. Changes to Delta Container

C. You need to refresh the content of the container manually

D. Take snapshot manually before releasing of the container

What should you do to follow the code-to-data approach to programming? 2 answers

A. Perform expensive calculations on the database

B. Transfer all data from the database to the ABAP layer, and then aggregate the results.

C. Perform expensive calculations on the ABAP application server.

D. Aggregate data on the database, and transfer the results to the ABAP layer.

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

Which Code Inspector check variant can you use?

A. PERFORMANCE_OPT

B. CHECK_PERFORMANCE

C. FUNCTIONAL_DB

D. PERFORMANCE_DB

What are the steps that supported several tools, which in total result in a Guided Performance Optimization? There are 2 correct answers to this question.

A. Tools analyzing performance at run-time, to determine if critical constructs

B. A new tool called SQL Monitor to determine the priority if different programs access the database intensively

C. A selection Code Inspector (SCI) and ABAP Test Cockpit (ATC) to locate potential functional and performance issues.

D. The ABAP Trace (SAT) and the ABAP Profiling perspective to measure and compare runtime consumption

Which of the following is true?

A. ABAP

B. OSQL

C. Oc#

D. Java

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

What are the Possible Approaches with AS ABAP < 7.4 SP02? There are 2 correct answers to this question

A. SQL units

B. Consume using native SQL

C. Stored Procedures

D. Interaction with Database

In SAP HANA SQL, you want to create a table whose definition should NOT be visible in the catalog? Which of the following table types fulfill this requirement? Please choose the correct answer.

A. ROW

B. GLOBAL TEMPORARY

C. COLUMN

D. LOCAL TEMPORARY

What are the key points that should be kept in mind while performing the Nonautomatic update in SAP HANA Transport Container? (2 answers)

A. Changes to Delta Container

B. You need to refresh the content of the container manually

C. Automatic release of units

D. Take snapshot manually before releasing of the container

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 below has huge negative impact on performance? (2 answers)

A. Mixing up SQL statement and CE functions

B. Join on calculated column

C. Inner Join

You follow the Code-to-Data paradigm in your ABAP coding.

Which of the following scenarios conflicts with the SQL performance guideline "Keep unnecessary load away from the database"?

A. Perform business logic and aggregations on database table content, then transfer the results to the application layer.

B. Perform join operations on database tables, then transfer the results to the application layer.

C. Perform calculations on data transferred to the database layer, then transfer the results back to the application layer.

D. Perform text search operations on database table content, then transfer the results to the application layer.

How many result sets are returned when an SAP HANA database procedure is called using the CALL WITH OVERVIEW statement?

Please choose the correct answer.

A. As many result sets as there are input parameters in the procedure

B. Two result sets

C. One result set

D. As many result sets as there are table output parameters in the procedure

Which conditional expressions can be used in Core Data Services (CDS) views? 2 answers A. CASE statements in the projection list

B. IF statements in the projection list

C. WHILE statements in the WHERE clause

D. COALESCE functions in the projection list

E. CASE statements in the HAVING clause

What should you do to follow the code-to-data approach to programming? There are 3 correct answers to this question.

A. Use native SQL to access SAP HANA built-in functions.

B. Perform expensive calculations on the database.

C. Aggregate data on the database, and transfer the results to the ABAP layer.

D. Perform expensive calculations on the ABAP application server.

E. Transfer all data from the database to the ABAP layer, and then aggregate the results.