Note! Following E_HANAAW_17 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

E_HANAAW_17 Exam Dumps - SAP Certified Development Specialist - ABAP for SAP HANA 2.0

Question # 4

You plan a database migration to SAP HANA and want to check your ABAP coding for potential functional regressions.

Which Code Inspector check variant can you use?

PREV_FUNC_REG

FUNCTIONAL_DB

FUNCTIONAL_CHECK

PERFORMANCE DB

Full Access

Question # 5

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.

Column store

Development Store

Row store

Technology store

Re-use component store

Full Access

Question # 6

You want to implement business logic on the database layer.

Which approach do you follow when implementing an ABAP Managed Database Procedure?

The Left-Right approach

The Near-Far approach

The Top-Down approach

The Inside-Out approach

Full Access

Question # 7

You have created a CDS view as follows: define view zha400 as select from spfli association (*) to sflight as_flights On spfli.carrid =_flights.carrid and spfli.connid=_flights.connid

{

...

}

Given that table sflight also contains the field planetype, how must you address the fields carrid and planetype from table SFLIGHT?

carrid and _flights.planetype

_ flights.carrid and planetype

carrid and planetype

flights.carrid and _flight.s .planetype

Full Access

Question # 8

Which of the following is true?

ABAP

OSQL

Oc#

Java

Full Access

Question # 9

What are the steps involved in supporting a database oriented programming model? There are 2 correct answers to this question.

A new and advanced Open SQL

Core Data services

Buffer system services

Advanced and specific models

Full Access

Question # 10

Which SQL syntax is used to create a read only procedure?

READS SQL DATA

READS PROCEDURE

NO-SIDE-EFFECT

READ-ONLY

Full Access

Question # 11

What are the Perspectives and Views of SAP HANA Studio? There are 2 correct answers to this question.

Open system properties

Administration console

Development properties

System Properties

Full Access

Question # 12

What must you take into consideration when you use the new open SQL syntax (available as of SAP Net weaver 7.4 SP05)? There are 2 correct answers to this question.

All arithmetic expressions can be used for all type of variables

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

All Keywords are case sensitive.

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

Full Access

Question # 13

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

Fewer data duplication and movement

Exploit structured contents in SQL

Easy to use modeling tool

Large number of toolkits are available

Full Access

Question # 14

The new bottlenecks avoided by addressing two challenges, what are they? There are 2 correct answers to this question.

Avoid idiling CPU cores

Avoid CPU cache misses

Avoid optimizing data

Avoid single network

Full Access

Question # 15

Which of the following ABAP transactions can you use to detect SQL performance optimization potential in your ABAP code? 2 ans

SQLM

SE09

SWLT

ST22

SE3S

Full Access

Question # 16

Which of the following statements are true about "Content"?

It represents SAP HANA's data dictionary.

It contains the design-time artifacts.

All the physical tables and views can be found under the Catalog node.

Full Access

Question # 17

You created and activated database procedure. How can you call this procedure? There are 2 correct answers to this question.

By another database procedure

By using Sap Analysis for Microsoft office

By a script-based calculation view

By a core data services view

Full Access

Question # 18

Which is not a Golden Rule for Open SQL? Please choose the correct answer.

Minimize the Number of Database Accesses

Reduce the Database Load

Minimize the Amount of Data Transferred

Keep the result set large

Full Access

Question # 19

Which of the following information is mandatory in the definition of an association in a Core Data Services (CDS) view?

The filter condition for the association

The cardinality of the association

The alias for the association

The target entity of the association

Full Access

Question # 20

What are the features associated with ABAP CDS? (3 Ans) There are 3 correct answers to this question.

Read

Create

Delete/Edit Table

Update

Full Access

Question # 21

What allows you to resolve errors quickly or warnings reported about the code? Please choose the correct answer.

Code execution

Quick Fix

Debug perspective

ABAP debugger

Full Access

Question # 22

Why is not a key factor of ALV for HAN A? Please choose the correct answer.

The data display is restricted to a maximum of 2 billion cell

To supply suitable values for any input parameters

To activate and execute the program in the application

Derived column headings from the data element

Full Access

Question # 23

How can you consume a Core Data Services (CDS) view? 2 ans

Use the Data Preview in ABAP Development Tools for SAP NetWeaver.

Use it as a data source in the FROM clause of an Open SQL query.

Use the ABAP language statement WRITE and the CDS view name as the argument.

Use the CDS maintenance transaction (SCDSV).

Full Access

Question # 24

How many result sets are returned when an SAP HANA database procedure is called using the CALL WITH OVERVIEW statement?

Please choose the correct answer.

As many result sets as there are input parameters in the procedure

Two result sets

One result set

As many result sets as there are table output parameters in the procedure

Full Access

Question # 25

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.

select from snwd_so {so_id( sum(net_amount) as sum_amount} order by sojd

select from snwd_so {so_id( sum(net_amount) as sum_amount} group by sojd

select from snwd_so {sojd, sum(net_amount) as sum_amount}

select from snwd_so {so_id( sum(net_amount) as sum_amount} group by net_amount

Full Access

Question # 26

You changed an SAP HANA object that you transported using an SAP HANA Transport container. You want to release the transport request with your changes. In which sequence do you perform activities in the ABAP development system immediately before the release? Please choose the correct answer.

Open the SAP HANA transport containerSelect take snapshot and Save

Activate the SAP HANA Transport Container

Open the SAP HANA delivery unit Select take snapshot and Save Activate the SAP HANA Delivery unit

Activate the SAP HANA transport container

Open the ABAP transport request Select take snapshot and Save

Activate the SAP HANA transport container

Open the package Select take snapshot and Save Activate the SAP HANA Delivery unit

Activate the SAP HANA transport container

Full Access