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

Question 1

What can you include in the projection list of a Core Data Services (CDS) view? 3 ans

A. ABAP system fields such as sy-langu or sy-mandt \/ CI String constants and literal values B. A field from the projection list of another CDS view used in the FROM clause C. A field from the structural output of an ABAP Managed Database Procedure used in the FROM clause D. Aggregation functions over fields of ABAP Dictionary tables used in the FROM clause

Correct Answer: B,C,D

Question 2

How can you enhance an existing ABAP Search Help with a type-ahead function?

A. Modify the search help with the Native SQL command ALTER SEARCH HELP. B. Enhance the lookup table with an additional ACCURACY field and insert an accuracy value. C. Use the fuzzy-search exit in transaction SE11. D. Use the enhanced options in transaction SE11.

Correct Answer: D

Question 3

What are the steps involved in supporting a database oriented programming model? There are 2 correct answers to this question.

A. Advanced and specific models B. Core Data services C. Buffer system services D. A new and advanced Open SQL

Correct Answer: B,D

Question 4

What are functions of the ABAP Managed Database Procedure (AMDP) framework? (2 right answers)

A. It creates the database procedure when the AMDP is first called. B. It deletes obsolete versions of the database procedure asynchronously C. It deletes obsolete versions of the database procedure synchronously D. It creates the database procedure when the AMDP is first activated.

Correct Answer: A,B

Question 5

You want to implement business logic on the database layer.
Which approach do you follow when implementing an ABAP Managed Database Procedure?

A. The Top-Down approach B. The Near-Far approach C. The Inside-Out approach D. The Left-Right approach

Correct Answer: A

Question 6

Open SQL largely standardized, three sub-languages. What are these sub-languages? There are 3 correct answers to this question

A. Data Transferring Language(DTL) B. Data Evaluation Language(DEL) C. The Data Definition Language (DDL) D. Data Manipulation Language (DML) E. The Data Control Language (DCL)

Correct Answer: C,D,E

Question 7

Which TADIR object type is used for the definition of a Core Data Services (CDS) view?

A. R3TR TABL B. R3TR DDLS C. R3TR VIEW D. R3TR DDIC

Correct Answer: B

Question 8

You want to execute a native SQL statement in your program. Why should you use ABAP Database Connectivity (ADBC)? (Choose Two)

A. It supports exception handling B. It has syntax check as compile time. C. It supports where-used list. D. It supports locking and commit handling

Correct Answer: A,D

Question 9

Why is a security concept in SAP HANA required? There are 2 correct answers to this question

A. Editing of SAP HANA data models should only be possible for "Users" of the model B. Need to have selected users in SAP HANA for Information Management C. Access to ERP tables must be restricted D. Database administration should be restricted to skilled

Correct Answer: C,D

Question 10

You use ABAP database connectivity (ADBC) to issue native SQL calls to the database, the native SQL call? Which of the following methods of class CL_SQL_RESULT_SET retrieves the tabular result of the native SQL call? Please choose the correct answer.

A. EXECUTE_QUERY B. SET_PARAM_TABLE C. SET_PARAM D. NEXT_PACKAGE

Correct Answer: D

Question 11

Which of the following repository object can you edit only in ABAP Development tools in Eclipse and not in the Classical ABAP workbench?
There are 3 correct answers to this question.

A. Full-text index B. Core Data service (CDS) view C. ABAP program containing new Open SQL D. External view E. Database procedure proxy

Correct Answer: B,D,E

Question 12

What is the main purpose of Analytic Privilege?

A. Restrict users to access database tables B. Restrict user to access modeling view C. Restrict row level access so that user will be able to see only certain portion of the data

Correct Answer: C

Question 13

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

A. The data display is restricted to a maximum of 2 billion cell B. To supply suitable values for any input parameters C. To activate and execute the program in the application D. Derived column headings from the data element

Correct Answer: C

Question 14

What are the features associated with ABAP CDS? (3 Ans) There are 3 correct answers to this question.

A. Update B. Read C. Create D. Delete/Edit Table

Correct Answer: A,B,C

Question 15

You want to debug an ABAP program using ABAP development tools (ADT). How do you launch the debugger? Please choose the correct answer.

A. Choose the debug as option in the context menu of the ABAP program B. Choose the Run --> Debug options in the menu C. Create a debug configuration for the ABAP application and run the program D. Set a breakpoint in the ABAP program and execute the program

Correct Answer: D

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