SAP E_HANAAW_17 Exam Dumps

SAP Certified Development Specialist - ABAP for SAP HANA 2.0

814 Reviews

Exam Code	E_HANAAW_17
Exam Name	SAP Certified Development Specialist - ABAP for SAP HANA 2.0
Questions	174 Questions Answers With Explanation
Update Date	06, 30, 2026
Price	Was : $81 Today : $45 Was : $99 Today : $55 Was : $117 Today : $65

Add To Cart

Demo Questions

Question # 1

You want to develop an ABAP application for SAP HANA using the front-end image of your Amazon Web Service (AWS) trial system. Which plug-ins do you need to add to the existing Eclipse installation?

A. All plug-ins provided by SAP Development Tools for Eclipse
B. SAP HANA Tools
C. ABAP Development Tools for SAP NetWeaver
D. None; everything is preconfigured

Show Answer

Question # 2

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. Create a debug configuration for the ABAP application and run the program
C. Set a breakpoint in the ABAP program and execute the program
D. Choose the Run --> Debug options in the menu 

Show Answer

Question # 3

Which components can be a part of a calculation view? (2 answers)

A. BAPIs
B. Analytic View
C. Tables
D. Attribute View

Show Answer

Question # 4

Which data sources can you use for SAP list viewer with integrated data access? There are 3 correct answers to this question.

A. CDS View
B. Database procedure
C. External view
D. Database Table
E. Internal table

Show Answer

Question # 5

You want to define an ABAP Core Data Services (CDS) view that totals the NET_AMOUNT column for each sales order (column SOJD). Which SELECT statement would you use in the definition? Please choose the correct answer.

A. select from snwd_so {so_id( sum(net_amount) as sum_amount} order by sojd  
B. select from snwd_so {so_id( sum(net_amount) as sum_amount} group by sojd
C. select from snwd_so {sojd, sum(net_amount) as sum_amount}
D. select from snwd_so {so_id( sum(net_amount) as sum_amount} group by net_amount

Show Answer

Question # 6

Which of the following categories of parameters can you use in the definition of an ABAP manage database procedure (AMDP)?There are 3 correct answers to this question.  

A. Returning
B. Receiving
C. Exporting
D. Changing
E. Importing

Show Answer

Question # 7

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

A. Convert crosstab cells to formula
B. Analyze data with the design pane
C. Suggests style sets for crosstabs
D. Sort data by characteristics

Show Answer

Question # 8

List down the elements involved in User Management and Security in SAP Hana? There are 3 correct answers to this question 

A. Manage users
B. Assign Job security
C. Assign security
D. Work Management 
E. Create users

Show Answer

Question # 9

You plan a database migration to SAP HANA and want to check your ABAP coding for performance optimization potential.Which Code Inspector check variant can you use?  

A. PERFORMANCE_OPT
B. CHECK_PERFORMANCE
C. FUNCTIONAL_DB
D. PERFORMANCE_DB

Show Answer

Question # 10

You have defined the following SQLScript procedure: CREATE PROCEDURE LANGUAGE SQLSCRIPT SQL SECURITY DEFINER READS SQL DATA. Which type of database procedures can be called in this SQLScript procedure? Please choose the correct answer. 

A. Read-write
B. Read only
C. Write only
D. Read-update

Show Answer

Question # 11

Which of the following objects can you use in the ABAP layer when using the top-down approach to bring code to data? There are 2 correct answers to this question

A. Calculation views
B. ABAP managed database procedures\
C. Stored procedure
D. Core data services views

Show Answer

Question # 12

Which system schema contains the information about Time data and Schema Mapping?

A. _SYS_REPO
B. _SYS_BIC
C. _SYS_BI
D. _SYS_XS

Show Answer

Question # 13

What are the types of schemas in HANA? (3 correct) 

A. System Defined Schema
B. User Defined Schema
C. SLT Derived Schema
D. Dynamic Schema

Show Answer

Question # 14

DB-Specific Properties that allows switching between storage types when running on an SAP HANA database. What are these storage types? There are 2 correct answers to this question.

A. Column store
B. Development Store
C. Row store
D. Technology store
E. Re-use component store

Show Answer

Question # 15

You define and implement an ABAP Managed database procedure (AMDP). What do you have to list after the USING clause? (3 right answers)

A. ABAP Dictionary views used in the procedure body
B. ABAP Dictionary table used in the procedure body
C. AMDP used in the procedure body
D. function used in the procedure body
E. SAP HANA views used in the procedure body

Show Answer

Question # 16

What is the operating system supported by HANA? (2 correct answers)

A. Only Windows 8
B. Red Hat Enterprise Linux (RHEL)
C. SUSE Linux Enterprise Server
D. Both Linux and Window 8

Show Answer

Question # 17

Which of the below statements are true for SAP HANA Studio? (3 right answers) 

A. SAP HANA Studio can be used to manage the SAP HANA database, to create and manage user authorizations, to create new or modify existing models of data etc
B. SAP HANA Studio is an Eclipse-based, integrated development environment (IDE) that is used to develop artifacts in a HANA server.
C. SAP HANA Studio is a client tool, which can be used to access local or remote HANA system.
D. SAP HANA Studio is integrated in SAP GUI > 7.40  

Show Answer

Question # 18

What is the language SAP HANA is developed in?

A. Assembly
B. O
C. C++
D. Java

Show Answer

Question # 19

What are the principles of Using HANA Transport Containers properly? There are 3 correct answers to this question. 

A. Import of Transport Request
B. To create Transport container of delivery unit
C. Automatic update for all export methods
D. Release of Transport request
E. Takes a 'snapshot' of all SAP HANA objects of delivery unit

Show Answer

Question # 20

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

A. Attribute view
B. Schema view
C. Column view
D. Analytical view

Show Answer

Question # 21

Analytic Privilege can be applied to (3 Answers)

A. Calculation views
B. Attribute views
C. Analytic views
D. Table
E. SQL View

Show Answer

Question # 22

Which system schema contains the list of Activated and inactive Objects?

A. _SYS_BIC
B. _SYS_REPO
C. _SYS_XS
D. _SYS_BI

Show Answer

Question # 23

List down the three main concepts of the SAP HANA database There are 3 correct answers to this question 

A. Column Store
B. Tools combinations
C. Object store
D. Partitioning
E. Compression

Show Answer

Question # 24

You execute a Native SQL query statement to retrieve a list of information using the corresponding ABAP Database Connectivity (ADBC) API method.Which additional steps are necessary to retrieve the result set into an internal table? 2 ans 

A. Close the CL_SQL_STATEMENT object to release the resources.
B. Use an Open SQL query that uses the JOIN between the result set and the internal table as a data source.
C. Bind a reference to the internal table as an output parameter to the CL_SQL_RESULT_SET instance.
D. Fetch the result using the next_package method of class CL_SQL_RESULT_SET.
E. Fetch the result using the fetch method of class CL_SQL_EXECUTE. 

Show Answer

Question # 25

Which tools can you use to provide input data for the SQL performance tuning work list (Transaction SWLT)? There are 3 correct answers to this question.

A. Data base performance monitor (transaction DB50)
B. Code inspector (transaction SCI)
C. SQL Trace (transaction ST05)
D. SQL monitor (transaction SQLM)
E. ABAP test cockpit (transaction ATC)

Show Answer