top of page
Writer's pictureSeema Iyer

Introduction to SAP Certified Development Specialist - ABAP for SAP HANA Exam

ABAP for SAP HANA (E_HANAAW_14) preparation guide helps you to get focused on exam. This guide also helps you to be on E_HANAAW_14 exam track to get certified with good score in the final exam.


E_HANAAW_14 ABAP for SAP HANA Exam Summary

Exam Syllabus: E_HANAAW_14 SAP Certified Development Specialist - ABAP for SAP HANA


1. Guided Performance Analysis (> 12%)

Perform Guided Performance Analysis using appropriate tools to determine which ABAP applications should be optimized when migrating to SAP HANA.

Books: HA400 OR SAP LH LR "ABAP for SAP HANA"


2. Integration of SAP HANA Coding into ABAP Programs (> 12%)

Approach the code-to-data paradigm using 'top-down' techniques, using Core Data Services views and ABAP managed database procedures

Books: HA400 OR SAP LH LR "ABAP for SAP HANA"


3. Implications of SAP HANA on ABAP Programming (> 12%)

Evaluate and identify the implications of SAP HANA on ABAP development, use the extended Open SQL syntax and use the appropriate techniques in ABAP to access Database functionality

Books: HA400 OR SAP LH LR "ABAP for SAP HANA"


4. SAP HANA Basics and Technical Concepts (8% - 12%)

Explain the fundamental technical concepts of SAP HANA.

Books: HA100 OR SAP LH LR "ABAP for SAP HANA"


5. SAP HANA Information Models & Database Procedures (8% - 12%)

Create basic SAP HANA Information Models and Database Procedures.

Books: HA300 OR SAP LH LR "ABAP for SAP HANA"


6. SAP Development Tools for SAP NetWeaver (8% - 12%)

Describe and use SAP Development tools, including SAP HANA Studio and ABAP development tools.

Books: HA100, BC404 OR SAP LH LR "ABAP for SAP HANA"


7. ABAP Programming based on SAP HANA Artefacts (8% - 12%)

Create and use external views, database procedure proxies and HANA Transport containers (HTCs)

Books: HA400 OR SAP LH LR "ABAP for SAP HANA"


SAP E_HANAAW_14 Certification Sample Questions and Answers

To make you familiar with ABAP for SAP HANA (E_HANAAW_14) certification exam structure, we have prepared this sample question set. We suggest you to try our Sample Questions for ABAP for HANA E_HANAAW_14 Certification to test your understanding of SAP E_HANAAW_14process with real SAP certification exam environment.


E_HANAAW_14ABAP for SAP HANA Sample Questions:-

01. Your customer wants to migrate to SAP HANA and you want to identify which business processes should be optimized. Which of the following steps must you perform to get this information?

There are 2 correct answers to this question.

a) Combine the results of the SQL Monitor with the results of an ABAP runtime analysis.

b) Activate the new SQL Monitor in a productive system.

c) Combine the results of the SQL Monitor with the results of a static source code analysis.

d) Activate the new SQL Monitor in a development system.


02. What must you do when you define and implement an ABAP Managed Database Procedure (AMDP)?

There are 3 correct answers to this question.

a) Use scalar types for all AMDP method parameters.

b) Mark the AMDP method as a READ-ONLY database procedure.

c) List all ABAP Dictionary tables used in the procedure body in the USING clause.

d) Specify the database system and the language.

e) Define all method parameters to be passed by value.


03. Explain The Authorization Concept and the types of privileges associated with it?

There are 3 correct answers to this question.

a) System privileges

b) Object privileges

c) Analytic privileges

d) Delta privileges

e) Application privileges


04. You have an SQLScript procedure with a table input parameter it_books. You want to use the parameter on the right-hand side of an assignment operator within the procedure. How do you refer to the parameter?

Please choose the correct answer.

a) {it_books}

b) :it_books

c) @it_books

d) it_books


05. What are the benefits of using the SQL Monitor (transaction SQLM)?

There are 2 correct answers to this question.

a) It collects monitoring data asynchronously without additional database interaction.

b) It can be active in a production system with minimal performance overhead.

c) It displays the database execution plan for all SQL statements.

d) It schedules ABAP programs to monitor and log all database accesses.


06. In which of the following situations could a row store table be more suitable than a column store table?

There are 2 correct answers to this question.

a) The table contains data that you want to aggregate.

b) The table contains only a small number of records.

c) The table contains mainly distinct values per column across rows.

d) The table contains text that you want to search.


07. Which features does the source code editor provide in ABAP Development Tools for SAP NetWeaver?

There are 2 correct answers to this question.=

a) Screen editing

b) Quickfix

c) Form-based class builder

d) Content assistance


08. Your ABAP program contains an Open SQL join of two client-dependent tables. You want to replace this with a native SQL SELECT statement. Which of the following changes to the SELECT statement can you use to retrieve the same data as before?

There are 2 correct answers to this question.

a) Include the client field in the WHERE condition.

b) Use the CLIENT SPECIFIED addition.

c) Include the client field in the join condition.

d) Include the client field in the field list.


09. What should you do to follow the code-to-data approach to programming?

There are 3 correct answers to this question.

a) Perform expensive calculations on the database.

b) Transfer all data from the database to the ABAP layer, and then aggregate the results.

c) Aggregate data on the database, and transfer the results to the ABAP layer.

d) Perform expensive calculations on the ABAP application server.

e) Use native SQL to access SAP HANA built-in functions.


10. 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


Solutions:

QUESTION: 01- Answer: b, c

QUESTION: 02- Answer: c, d, e

QUESTION: 03- Answer: a, b, c

QUESTION: 04- Answer: b

QUESTION: 05- Answer: a, b

QUESTION: 06- Answer: b, c

QUESTION: 07- Answer: b, d

QUESTION: 08- Answer: a, c

QUESTION: 09- Answer: a, c, e

QUESTION: 10- Answer: c, d

675 views0 comments

Comments


bottom of page