E_HANAAW_18 ABAP for SAP HANA 2.0 Questions and Answers

dumps2023-06-06T10:26:58+08:00

If you are preparing for your SAP Certified Development Specialist – ABAP for SAP HANA 2.0 E_HANAAW_18 exam, the online SAP E_HANAAW_18 exam questions and answers are good material. There are 40 questions in real SAP certification E_HANAAW_18 exam, and you have 90 minutes to answer all the questions. The cut score for SAP E_HANAAW_18 exam is 56%. The test language is English. Free E_HANAAW_18 ABAP for SAP HANA 2.0 exam questions are below.

Page 1 of 2

1. You developed an ABAP Managed Database Procedure (AMDP). You want to allow the enhancement of this AMDP using a Business Add-In (BAdI).

Which of the following objects must you create? Note: There are 3 correct answers to this question.

A BAdI fallback implementation

A BAdI definition

A database procedure

An enhancement spot

A BAdI sample implementation

2. When using an SAP HANA full text search, what do you have to keep in mind?

The LIKE operator is required in your SELECT statement to implement fuzzy logic.

SAP HANA has to be the primary database to create a full text search.

The SCORE () function is required to ensure the best hits of your search appear on top.

The full-text index is always updated asynchronously.

3. Which task can you perform with the SQL Monitor (transaction SQLM)?

Capture the SQL profile of an application.

Search for problematic SELECT * statements.

Combine static and dynamic performance analysis results.

Display the execution plan of an SQL statement.

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

Replace UP TO n ROWS additions.

Replace ORDER BY additions.

Specify the schema for every table.

Replace CORRESPONDING FIELDS additions.

Add explicit client handling.

5. You import an ABAP workbench request into an SAP system P81. The ABAP workbench request contains a single SAP HANA view CA_CUSTOMER that belongs to SAP HANA content package ZHA400_00.

Which prerequisites are mandatory for an implicit deployment of the SAP HANA view onto the database? Note: There are 2 correct answers to this question.

View CA_CUSTOMER has deployment mode

Package ZHA400_00 has deployment mode

System P81 has SAP HANA as primary database.

Package ZHA400_00 is listed in table SNHI DUP PREWOR

6. 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?

HISTORY COLUMN

GLOBAL TEMPORARY

LOCAL TEMPORARY

ROW

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

All classical open SQL statements in your program will become invalid.

All ABAP variables must be escaped with a preceding @ sign.

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

All arithmetic expressions can be used for all types of variables.

8. Which step of the Guided Performance Analysis should you perform in the production system?

Executing a check run with ABAP Test Cockpit (ATC)

Collecting data with SQL Monitor (SQLM)

Performing an inspection with Code Inspector (SCI)

Building a work list with SQL Performance Tuning Worklist (SWLT)

9. Which of the following repository objects can you edit only in ABAP Development Tools in Eclipse, and NOT in the classical ABAP Workbench? Note: There are 3 correct answers to this question.

Data Definition

ABAP class with new Open SQL Syntax

Full-text index

Database Procedure Proxy

ABAP class with SQL script coding

10. Your development team needs to include SAP HANA objects into an ABAP workbench request. You want to use SAP HANA Transport for ABAP (HTA), and NOT the SAP HANA Transport Container (HTC).

Why would you choose HTA? Note: There are 2 correct answers to this question.

Because you use the technique that is recommended by SA

Because you automatically add changed objects to the transport request.

Because you can manually re-deploy objects after a failed import.

Because you always transport entire SAP HANA content packages.

Page 2 of 2

11. 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?

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

Create an input parameter for the ADDRESS field.

Exclude the ADDRESS field from the union.

Create a restricted column for the ADDRESS field.

Map the ADDRESS field to a constant value.

E_HANAAW_18 ABAP for SAP HANA 2.0 Questions and Answers

E_HANAAW_18 ABAP for SAP HANA 2.0 Questions and Answers

Share this post

Leave a Reply Cancel reply

Related Posts