Free SAP Certified Development Specialist – ABAP for SAP HANA 2.0 Exam E_HANAAW_18 Exam Practice Test

You are programming a report that reads data from a secondary HANA database (DB). What do you need to consider in your SQL statement? Note: There are 2 correct answers to this question.

• You have to use native SQL when reading data from the secondary D
• You have to specify the DB connection explicitly in your statement.
• You have to specify the DB schema explicitly in your statement.
• All tables and fields you are using must exist in the ABAP Dictionary of the secondary DB.

You developed an ABAP Managed Database Procedure (AMDP). You want to allow the enhancement of this AMDP using a Business Add-In (BAdI). Which of the following objects must you create? Note: There are 3 correct answers to this question.

• A BAdI fallback implementation
• A BAdI definition
• A database procedure
• An enhancement spot
• A BAdI sample implementation

Which of the following features does the ABAP Test Cockpit offer that the ABAP Code Inspector does NOT offer? Note: There are 2 correct answers to this question.

• Flexible schedule of check runs
• Enhanced distribution of results
• Documented checks
• Configuration of check variants

You use ABAP Database Connectivity (ADBC) to issue native SQL calls to the database. Which method of class CL_SQL_RESULT_SET retrieves the entire result set of the native SQL call?

• SET_PARAM_TABLE
• NEXT
• EXECUTE_QUERY
• NEXT_PACKAGE

Which of the following features were added to the ABAP dictionary to support the SAP HANA database? Note: There are 3 correct answers to this question.

• De-pooling and de-clustering
• Storage type for tables
• Definition of enhancement category
• Change of data class
• Definition of full-text indexes

You want to execute a native SQL statement in your program. Why should you use ABAP Database Connectivity (ADBC)? Note: There are 2 correct answers to this question.

• It supports locking and commit handling.
• It has syntax check at compile time.
• It supports exception handling.
• It supports where-used list.

Which functional problem can you detect when using the Runtime Check Monitor (SRTCM)?

• Direct access to Table Pools/Cluster
• Missing ORDER BY or SORT after SELECT
• Use of Native SQL and DB Hints
• Existence check for Secondary Indexes

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.

• Minimize the number of database accesses.
• Minimize the amount of transferred data.
• Keep unnecessary load away from the database.
• Minimize the search overhead.

You define a Core Data Services (CDS) view to merge the results of queries using the UNION keyword. What must the column lists of these queries contain? Note: There are 2 correct answers to this question.

• Columns of compatible types
• The same number of columns
• All key fields
• Columns of identical types

What are some of the features available for SAP List Viewer with Integrated Data Access (ALV IDA)? Note: There are 3 correct answers to this question.

• Group rows
• Edit cells
• Search in content
• Display diagrams
• Double-click on rows