Free Certified Development Specialist – ABAP for SAP HANA 2.0 Exam E_HANAAW_17 Exam Practice Test

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?

• All plug-ins provided by SAP Development Tools for Eclipse
• SAP HANA Tools
• ABAP Development Tools for SAP NetWeaver
• None; everything is preconfigured

SAP HANA: Delivers Across 5 Dimensions. These five dimensions lead to certain goals HANAhas to meet. What are thesegoals?There are 2 correct answers to this question.

• Analytical DBMS features
• Support for system tables
• High Performance and Scalability
• Hybrid data and management system

What all are the steps to perform -To enable type-ahead for an input field on a screen? There are 3 correct answers to this question.

• Process on all the input fields
• Automatic updates of all the input fields
• Check Pre-Requisites
• Identify Elementary Search Help
• Switch on proposal search for input fields

ANSI SQL owns features and adds languages. These languages divided into three parts. What are they? There are 3 correct answers to this question.

• Data Manipulation Language
• The Data Control Language
• The Database Language
• The Data Definition Language
• Data Transferred Language

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.

• CAST( 'USO' AS abap.cuky) AS currency_key
• SUM( revenue ) AS total_revenue
• Crtdby AS created_by
• CASE order type WHEN 'A' THEN 1 ELSE 0 END AS Order_type
• ASSOCIATION TO sflight AS_flights

Before migrating to SAP HANA, which Code Inspector check do you have to consider to avoid functional regressions?

• Standard Web Dynpro checks
• Search for DB operations across modularization units
• SELECT statements that bypass the table buffer
• Use of the ADBC interface

Which functional problem can you detect when using the Runtime Check Monitor (SRTCM )?

• Existence check for secondary indexes
• Use of Native SQL and DB Hints
• Missing ORDER BY or SORT after SELECT
• Direct access to table pools/cluster

What should you do to follow the code-to-data approach to programming? There are 3 correct answers to this question.

• Use native SQL to access SAP HANA built-in functions.
• Perform expensive calculations on the database.
• Aggregate data on the database, and transfer the results to the ABAP layer.
• Perform expensive calculations on the ABAP application server.
• Transfer all data from the database to the ABAP layer, and then aggregate the results.

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

• Only Windows 8
• Red Hat Enterprise Linux (RHEL)
• SUSE Linux Enterprise Server
• Both Linux and Window 8

Open SQL largely standardized, three sub-languages. What are these sub-languages? There are 3 correct answers to this question

• Data Evaluation Language(DEL)
• The Data Definition Language (DDL)
• Data Transferring Language(DTL)
• The Data Control Language (DCL)
• Data Manipulation Language (DML)