SAP E-HANAAW-16 Actual Free Exam Questions & Community Discussion

Exam Code/Number: E-HANAAW-16
Exam Name/Title: SAP Certified Development Specialist - ABAP for SAP HANA 2.0
Certification Provider: SAP
Corresponding Certification: SAP Certified Development Specialist

Exam Questions: 240
Updated On: Jul 11, 2026

Question #1

What views will be most efficient for General Modeling Principles? There are 2 correct answers to this question

A. Column view

B. Attribute view

C. Analytical view

D. Schema view

Discussion 0

Correct Answer: B,C Vote an answer

Question #2

What are the benefits includes with SAP HANA Full Text Search? There are 2 correct answers to this question

A. Easy to use modeling tool

B. Fewer data duplication and movement

C. Large number of toolkits are available

D. Exploit structured contents in SQL

Discussion 0

Correct Answer: A,B Vote an answer

Question #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? Please choose the correct answer.

A. COLUMN

B. LOCAL TEMPORARY

C. GLOBAL TEMPORARY

D. ROW

Discussion 0

Correct Answer: B Vote an answer

Question #4

What is the purpose of an ABAP project in ABAP Development tools for eclipse? (2 right answers)

A. It represents the connection to an ABAP system

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

C. It is used to transport ABAP repository objects

D. It represents the connection to the SAP HANA server

Discussion 0

Correct Answer: A,B Vote an answer

Question #5

What is the language SAP HANA is developed in?

A. Java

B. O

C. Assembly

D. C++

Discussion 0

Correct Answer: D Vote an answer

Question #6

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?
There are 2 correct answers to this question.

A. Map the ADDRESS field to a constant value

B. Create an input parameter for the ADDRESS field

C. Create a restricted column for the ADDRESS field

D. Exclude the ADDRESS field from the union

Discussion 0

Correct Answer: A,D Vote an answer

Question #7

What are the two different kinds of Identifiers used to represent names used in SQL statement? There are 2 correct answers to this question

A. Numeric identifiers

B. Undelimited Identifiers

C. Limited identifiers

D. Delimited identifiers

Discussion 0

Correct Answer: B,D Vote an answer

Question #8

Discuss the main capabilities of SAP BusinessObjects Analysis for Office? There are 2 correct answers to this question

A. Suggests style sets for crosstabs

B. Convert crosstab cells to formula

C. Sort data by characteristics

D. Analyze data with the design pane

Discussion 0

Correct Answer: B,D Vote an answer

Question #9

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

Discussion 0

Correct Answer: C,D Vote an answer

Question #10

You create a check variant in the Code Inspector which includes the check 'Search problematic Select * statements'. SAP HANA is used as the db In the check parameters, which value would you use for the percentage of fields that are effectively used?
Please choose the correct answer.

A. A higher value than on a traditional, row-store only based database

B. A lower value than on a traditional, row-store only based database

C. The same value as on a traditional, row-store only based database

D. A value that you calculate based on the number of tables

Discussion 0

Correct Answer: B Vote an answer

Question #11

Which data provisioning methods can you use when you need real time replications? There are 2 correct answers to this question.

A. SAP Landscape transformation Replication server (SAP SLT)

B. SAP HANA Direct extractor connection (SAP DXC)

C. SAP Replication server

D. SAP Data services

Discussion 0

Correct Answer: A,C Vote an answer

Question #12

Which system schema contains the column views of activated objects?

A. _SYS_BI

B. _SYS_XS

C. _SYS_REPO

D. _SYS_BIC

Discussion 0

Correct Answer: D Vote an answer

Question #13

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.

Discussion 0

Correct Answer: A,B Vote an answer

Question #14

User STUDENT_A create and activates a design-time object. In which schema is the run object generated?
Please choose the correct answer

A. _SYS_BI

B. _SYS_BIC

C. SYSTEM

D. STUDENT_A

Discussion 0

Correct Answer: B Vote an answer

Download Free SAP E-HANAAW-16 Demo

Simply submit your e-mail address below to get started with our free demo of your SAP E-HANAAW-16 exam.