SAP Certified Development Specialist - ABAP for SAP HANA 2.0

Question 1

The new bottlenecks avoided by addressing two challenges, what are they? There are 2 correct answers to this question.

A. Avoid optimizing data

B. Avoid single network

C. Avoid CPU cache misses

D. Avoid idiling CPU cores

Correct Answer: C,D

Question 2

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

A. All ABAP variables must be escaped with a proceeding @ sign.

B. All Keywords are case sensitive.

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

D. All arithmetic expressions can be used for all type of variables

Correct Answer: A,C

Question 3

You are implementing an ABAP Managed Database Procedures (AMDP) for SAP HANA. What do you have to do in the corresponding ABAP class? Please choose the correct answer.

A. Implement the interface IF_AMDP_MARKER_HDB.

B. Declare the ABAP class as a sub-class of CL_AMDP_RUNTIME_HDB.

C. Implement the ABAP AMDPJHDB Event Handler.

D. Set the visibility of the corresponding class method in the declaration section to PUBLIC.

Correct Answer: A

Question 4

What are the supported joins in CDS view? There are 2 correct answers to this question.

A. Operators join

B. Injection

C. Upper join

D. Left outer join

Correct Answer: B,D

Question 5

What do you have to consider if you want to use Native SQL in your ABAP programs to access an SAP HANA DB? There are 2 correct answer to this question.

A. Hashed or sorted tables must be used with the INTO CORRESPONDING FIELDS keyword

B. The ABAP system check the syntax of the Native SQL statements

C. Client handling needs to be done explicitely in the Native SQL statement

D. The database independency of your report can be lost

Correct Answer: C,D

Question 6

Which of the following are view annotations for a CDS view? There are 3 correct answers to this question.

A. Environment

B. Semantics

C. Client handling

D. Buffering type

E. Access control

Correct Answer: C,D,E

Question 7

Which code-to-data capability supports- Extended view definitions and Better SQL-92 standard support in open SQL? Please choose the correct answer.

A. SAP HANA specific features

B. Database for sophisticated analysis

C. New SQL parser used in model

D. Database oriented programming model

Correct Answer: D

Question 8

Why is not a key factor of ALV for HAN A? Please choose the correct answer.

A. To activate and execute the program in the application

B. The data display is restricted to a maximum of 2 billion cell

C. Derived column headings from the data element

D. To supply suitable values for any input parameters

Correct Answer: A

Question 9

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 table output parameters in the procedure

B. Two result sets

C. One result set

D. As many result sets as there are input parameters in the procedur

Correct Answer: C

Question 10

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

A. Interaction with Database

B. SQL units

C. Stored Procedures

D. Consume using native SQL

Correct Answer: C,D

Question 11

What are the Guidelines for optimizing ABAP code running on HANA? There are 3 correct answers to this question.

A. Technical settings

B. Open SQL settings

C. High-speed data analysis

D. Column store

E. DB specific properties

Correct Answer: A,D,E

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

Latest Update

Useful Links

Contact Us