Certified Development Specialist - ABAP for SAP HANA 2.0

Question 1

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?

A. ROW

B. LOCAL TEMPORARY

C. HISTORY COLUMN

D. GLOBAL TEMPORARY

Correct Answer: B

Question 2

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. Add explicit client handling.

B. Replace UP TO n ROWS additions.

C. Specify the schema for every table.

D. Replace CORRESPONDING FIELDS additions.

E. Replace ORDER BY additions.

Correct Answer: A,B,C

Question 3

Which tools can you use to provide input data for the SQL Performance Tuning Worklist (transaction SWLT)? Note: There are 3 correct answers to this question.

A. SQL Trace (transaction: ST05)

B. Code Inspector (transaction: SCI)

C. SQL Monitor (transaction: SQLM)

D. Database Performance Monitor (transaction: DB50)

E. ABAP Test Cockpit (transaction: ATC)

Correct Answer: B,C,E

Question 4

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. CASE ordertype WHEN 'A' THEN 1 ELSE 0 END AS order_type

B. ASSOCIATION TO sflight AS .flights

C. CAST( 'USD' AS abap.cuky ) AS currency_key

D. crtdby AS created_by

E. SUM( revenue ) AS total_revenue

Correct Answer: A,C,E

Question 5

Which rules does SAP recommend to improve the performance of ABAP reports on SAP HANA? Note: There are 2 correct answers to this question.

A. Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement.

B. Ensure the access to buffered tables uses the SAP table U buffer.

C. Ensure the WHERE clause contains at least one index field.

D. Perform all calculations and aggregations in the ABAP U layer.

Correct Answer: A,C

SAP Certified Development Specialist - ABAP for SAP HANA 2.0 - E-HANAAW-18 Exam Practice Test

Latest Update

Useful Links

Contact Us