Labour Day Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: geek65

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

E_HANAAW_17 SAP Certified Development Specialist - ABAP for SAP HANA 2.0 Questions and Answers

Questions 4

In an Open SQL query, you select the sum of sales order gross amounts and a CASE statement to flag sa order gross amounts below a certain value. What information has to be provided in the GROUP BY list?

Options:

A.

The CASE statement as provided in the SELECT list without its alias

B.

The alias of the CASE construct used in the SELECT list

C.

None; the GROUP BY list is added automatically

D.

The name of the gross amount column that is used in the CASE statement

Buy Now
Questions 5

One of your SAP systems needs to be migrated from its current database to an SAP HANA database. You want to avoid any functional issues after the migration. What should you search for and if necessary replace in the existing custom ABAP code? There are 3 correct answers to this question.

Options:

A.

Direct access to a cluster on the database

B.

Left outer joins in open SQL statements

C.

Native SQL statements

D.

Code that relies on implicit database sorting

E.

ORDER BY Clauses in Open SQL statements

Buy Now
Questions 6

You perform a static code check using the Code Inspector (SCI). In your SCI variant, you select the Search problematic SELECT * statement check. What does this check report? Please choose the correct answer.

Options:

A.

SELECT * statements where fewer than a specified percentage of all fields are effectively used

B.

SELECT * statements on tables with more than a specified number of fields

C.

SELECT * statements on tables with more than 100,000 records

D.

SELECT * statements on tables with the Column Store storage type

Buy Now
Questions 7

You want to implement business logic on the database layer.

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

Options:

A.

The Left-Right approach

B.

The Near-Far approach

C.

The Top-Down approach

D.

The Inside-Out approach

Buy Now
Questions 8

What are the key points that should be kept in mind while performing the Nonautomatic update in SAP HANA Transport Container? (2 right answers)

Options:

A.

Changes to Delta Container

B.

You need to refresh the content of the container manually

C.

Automatic release of units

D.

Take snapshot manually before releasing of the container

Buy Now
Questions 9

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

Options:

A.

By another database procedure

B.

By using Sap Analysis for Microsoft office

C.

By a script-based calculation view

D.

By a core data services view

Buy Now
Questions 10

What are the steps that supported several tools, which in total result in a Guided Performance Optimization? There are 2 correct answers to this question.

Options:

A.

Tools analyzing performance at run-time, to determine if critical constructs

B.

A new tool called SQL Monitor to determine the priority if different programs access the database intensively

C.

A selection Code Inspector (SCI) and ABAP Test Cockpit (ATC) to locate potential functional and performance issues.

D.

The ABAP Trace (SAT) and the ABAP Profiling perspective to measure and compare runtime consumption

Buy Now
Questions 11

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

Options:

A.

Used to access local or remote database system

B.

Maintain, Monitor and test secondary database connection

C.

Use Schema for the Connections

D.

Maintain only HANA specific objects

Buy Now
Questions 12

Analytic Privilege can be applied to (3 Answers)

Options:

A.

Calculation views

B.

Attribute views

C.

Analytic views

D.

Table

E.

SQL View

Buy Now
Questions 13

What are the features of New Open SQL? There are 2 correct answers to this question.

Options:

A.

Supports arithmetic and string expressions

B.

Supports Code adjustment model

C.

Supports specific units of database

D.

Supports conditional expressions

Buy Now
Questions 14

Why is a security concept in SAP HANA required? There are 2 correct answers to this question

Options:

A.

Need to have selected users in SAP HANA for Information Management

B.

Access to ERP tables must be restricted

C.

Editing of SAP HANA data models should only be possible for "Users" of the model

D.

Database administration should be restricted to skilled

Buy Now
Questions 15

How will you hide the attributes that are not required for client consumption? Choose the correct answer

Options:

A.

By setting the hidden property flag of the attribute in the View

B.

By setting the hidden property flag of the attribute provider

C.

By setting the hidden property flag of the attribute column

D.

By setting the hidden property flag of the attribute in the Semantics screen

Buy Now
Questions 16

Which JOIN types can be used in the definition of a Core Data Services (CDS) view? 2 ans

Options:

A.

LEFT OUTER JOIN

B.

CROSS JOIN

C.

FULL OUTER JOIN

D.

RIGHT OUTER JOIN

E.

REFERENTIAL JOIN

Buy Now
Questions 17

How can you check if Core Data Services (CDS) views with scalar input parameters can be used in Open SQL queries in your system?

Options:

A.

Use the static method use_features of class cl_abap_dbfeatures.

B.

Perform a static code check using the FUNCTIONAL_DB variant.

C.

Check the Open SQL statement in the Explain SQL Statement transaction (SDBE).

D.

Check the value of the ABAP system field sy-cdsfeatures.

Buy Now
Questions 18

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.

Options:

A.

Column store

B.

Development Store

C.

Row store

D.

Technology store

E.

Re-use component store

Buy Now
Questions 19

What are the Functions of Transaction DBACOCKPIT There are 2 correct answers to this question.

Options:

A.

Use Schema for the Connections

B.

Maintain, Monitor and test secondary database connection

C.

Maintain only HANA specific objects

D.

Used to access local or remote database system

Buy Now
Questions 20

Discuss the basic approach of classical ABAP programming. Two answers

Options:

A.

Collect all the data and perform parallel processing in ABAP

B.

Creating and consuming all the contents from network

C.

Get all the data you need on the application server and do your processing in ABAP

D.

Keep load from the database

Buy Now
Questions 21

Which form of services is responsible for defining and consuming semantically rich data models. Please choose the correct answer.

Options:

A.

Core Data Services

B.

ITe services

C.

Conditional services

D.

Modell-ll services

Buy Now
Questions 22

Which of the following is latest release of SAP HANA?

Options:

A.

SAP HANA 1.0 SP06

B.

SAP HANA 1.0

C.

SAP HANA 1.6 SP03

D.

SAP HANA 2.0 SPS 04

Buy Now
Questions 23

You import an ABAP workbench request into a SAP SYSTEM P81. The ABAP workbench request contains a single SAP HANA VIEW CA_CUSTOMER that belongs to package 2HA400_00. WHICH PREREQISITIES are mandatory for an implicit deployment of the SAP HANA view onto the database? There are 2 correct answers to this question.

Options:

A.

View CA_CUSTOMER has deployment mode A.

B.

Package ZHA400_00 Is listed in table SNHI_DUP_PREWORK

C.

SYSTEM P81 has SAP HANA has primary database

D.

PACKAGE ZHA400J30 HAS deployment Mode A

Buy Now
Questions 24

Which of the following feature were added to the ABAP Dictionary to support the SAP HANA database? There are 3 correct answers to this question.

Options:

A.

De-pooling and de-clustering

B.

Changes of data class

C.

Definition of full-text indexes

D.

Definition of an enhancement category

E.

Storage type for tables

Buy Now
Questions 25

What are the different types of Variables in HANA? (3 right answers)

Options:

A.

Range

B.

Double

C.

Single Value

D.

Interval

Buy Now
Questions 26

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

Options:

A.

Delimited identifiers

B.

Limited identifiers

C.

Undelimited Identifiers

D.

Numeric identifiers

Buy Now
Exam Code: E_HANAAW_17
Exam Name: SAP Certified Development Specialist - ABAP for SAP HANA 2.0
Last Update: Mar 29, 2024
Questions: 174