E-HANAAW-18 Exam Training Practice Tests (SAP Certified Development Specialist

Question 1

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 fields in the GROUP BY clause must be separated by commas. B. All classical open SQL statements in your program will become invalid. C. All ABAP variables must be escaped with a preceding @ sign. D. All arithmetic expressions can be used for all types of variables.

Correct Answer: A,C

Question 2

In a graphical calculation view, you want to implement a union between two result sets that differ only in the fact that one of the two has one additional field named ADDRESS. How can you achieve this in a union node? Note: There are 2 correct answers to this question.

A. Create an input parameter for the ADDRESS field. B. Map the ADDRESS field to a constant value. C. Create a restricted column for the ADDRESS field. D. Exclude the ADDRESS field from the union.

Correct Answer: B,D

Question 3

You are using ABAP Development Tools, and you have placed your cursor on a method name in a class. What key do you use to navigate between a method definition and its implementation?

A. F2 B. F3 C. F4 D. F1

Correct Answer: B

Question 4

You define and implement an ABAP Managed Database Procedure (AMDP). What do you have to list after the USING clause? Note: There are 3 correct answers to this question.

A. SAP HANA views used in the procedure body B. AMDPs used in the procedure body C. ABAP Dictionary views used in the procedure body D. ABAP Dictionary tables used in the procedure body E. functions used in the procedure body

Correct Answer: B,C,D

Question 5

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.

A. Keep unnecessary load away from the database. B. Minimize the search overhead. C. Minimize the number of database accesses. D. Minimize the amount of transferred data.

Correct Answer: C,D

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