Certified Development Specialist - ABAP for SAP HANA 2.0 (E-HANAAW-18) Free Practice Test

Question 1

You analyze 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 dat a. 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. Program X was executed in the background.

B. SQL Monitor was activated for a specific application server.

C. SQL Monitor was activated with a filter that excludes database table Y.

D. Database table Y is a buffered table.

E. The data has NOT yet been transferred to the SQL Monitor database tables.

Correct Answer: B,C,E

Question 2

What must you take into consideration when you use the new Open SQL syntax (available as of SAP NetWeaver 7.4 SP05)? Note: There are 2 correct answers to this question.

A. All classical open SQL statements in your program will become invalid.

B. All ABAP variables must be escaped with a preceding @ sign.

C. All arithmetic expressions can be used for all types of variables.

D. All fields in the GROUP BY clause must be separated by commas.

Correct Answer: B,D

Question 3

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. A database procedure

B. A BAdI sample implementation

C. A BAdI definition

D. A BAdI fallback implementation

E. An enhancement spot

Correct Answer: C,D,E

Question 4

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.

A. It has syntax check at compile time.

B. It supports where-used list.

C. It supports exception handling.

D. It supports locking and commit handling.

Correct Answer: B,C

Question 5

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.

A. Search in content

B. Group rows

C. Edit cells

D. Double-click on rows

E. Display diagrams

Correct Answer: A,B,D

Welcome to TestSimulate

SAP Certified Development Specialist - ABAP for SAP HANA 2.0 (E-HANAAW-18) Free Practice Test