SAP E_HANAAW_18 Exam Questions Simulate Actual E_HANAAW_18 Exam

E_HANAAW_18 exam dumps questions are designed to simulate the actual exam. This means that you will get a feel for the types of questions you can expect to see on the exam, as well as the format and difficulty level. In addition, SAP Certified Development Specialist E_HANAAW_18 dumps are often accompanied by detailed explanations and answers. This means that if you get a question wrong, you can learn from your mistake and understand why the correct answer is the right one. Test free online E_HANAAW_18 exam dumps below.

Page 1 of 2

1. You want to execute a native SQL statement in your program.

Why should you use ABAP Database Connectivity (ADBC)? Note: There are 2 correct answers to this question.

It supports locking and commit handling.

It has syntax check at compile time.

It supports exception handling.

It supports where-used list.

 Loading...

2. Which rules does SAP recommend to improve the performance of ABAP reports on SAP HANA? Note: There are 2 correct answers to this question.

Ensure the access to buffered tables uses the SAP table U buffer.

Perform all calculations and aggregations in the ABAP U layer.

Ensure the WHERE clause contains at least one index field.

Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement.

 Loading...

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

 Loading...

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

 Loading...

5. You have created a CDS view and used alias names for some of its elements. In which of the following cases is the alias name mandatory? Note: There are 3 correct answers to this question.

CASE ordertype WHEN 'A' THEN 1 ELSE 0 END AS order_type

CAST( 'USD' AS abap.cuky ) AS currency_key

crtdby AS created_by

SUM( revenue ) AS total_revenue

ASSOCIATION TO sflight A

flights

 Loading...

6. You define a Core Data Services (CDS) view to merge the results of queries using the UNION keyword.

What must the column lists of these queries contain? Note: There are 2 correct answers to this question.

Columns of compatible types

The same number of columns

All key fields

Columns of identical types

 Loading...

7. What is the purpose of an ABAP project in ABAP Development Tools for Eclipse? Note: There are 2 correct answers to this question.

It represents the connection to an ABAP system.

It represents the connection to the SAP HANA server.

It is used to transport ABAP repository objects.

It provides access to all ABAP repository objects in an ABAP system.

 Loading...

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

 Loading...

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

 Loading...

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

Minimize the number of database accesses.

Minimize the amount of transferred data.

Keep unnecessary load away from the database.

Minimize the search overhead.

 Loading...

Page 2 of 2

11. Which of the following features were added to the ABAP dictionary to support the SAP HANA database? Note: There are 3 correct answers to this question.

De-pooling and de-clustering

Storage type for tables

Definition of enhancement category

Change of data class

Definition of full-text indexes

 Loading...

12. Why would you implement Smart Data Access (SDA)?

To replicate data between SAP ECC and SAP HANA

To define caching rules based on usage patterns

To generate delta images when sources cannot provide this function

To provide real-time access to remote data sources

 Loading...

 Loading...