March Sale Special - 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: c4sdisc65

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

Question # 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.

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

Full Access
Question # 7

What are some of the features available SAP List Viewer with integrated data access (SALV IDA)? There are 3 correct answers to this question.

A.

Display diagrams

B.

Double-click on rows

C.

Search in content

D.

Edit cells

E.

Group rows

Full Access
Question # 8

Which of the following ABAP language elements are mandatory for the implementation of a method as an ABAP Managed Database Procedure? 3 ans

A.

FOR db (db = HDB...)

B.

LANGUAGE dbjang (dbjang = SQLSCRIPT...)

C.

BY DATABASE PROCEDURE

D.

CLIENT SPECIFIED

E.

AUTHORIZATION db_auth (db_auth = SYSTEM ...)

Full Access
Question # 9

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

A.

SQLM

B.

SE09

C.

SWLT

D.

ST22

E.

SE3S

Full Access
Question # 10

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

A.

BAPIs

B.

Analytic View

C.

Tables

D.

Attribute View

Full Access
Question # 11

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.

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

Full Access
Question # 12

What are the Possible Approaches with AS ABAP < 7.4 SP02? There are 2 correct answers to this question

A.

SQL units

B.

Consume using native SQL

C.

Stored Procedures

D.

Interaction with Database

Full Access
Question # 13

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.

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

Full Access
Question # 14

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

A.

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

B.

To supply suitable values for any input parameters

C.

To activate and execute the program in the application

D.

Derived column headings from the data element

Full Access
Question # 15

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

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

Full Access
Question # 16

For which purpose can you use literal values in an Open SQL statement?

A.

To perform a generic existence check

B.

To provide a default value for a database table column

C.

To alias the result of an arithmetic expression

D.

To comment your development directly in the coding

Full Access
Question # 17

Which SAP HANA engine executes Calculation view? (2 answers)

A.

OLAP Engine

B.

Calculation Engine

C.

SQL Engine

D.

JOIN Engine

Full Access
Question # 18

You use native SQL to access the SAP HANA database. What should you do to retrieve the correct data? There are 3 correct answers to this question.

A.

Use the UP TO n ROWS addition

B.

Use the tilde symbol (-) to separate qualifier from column name

C.

Use a Comma-separated column list

D.

Specify the database schema if it is not the user's default schema

E.

Explicitly handle the client field

Full Access
Question # 19

In addition to closing the result set. what does the CLOSE method of the CL_SQL_RESULT_SET class when using ABAP Database Connectivity (ADBC) do? Please choose the correct answer.

A.

Release resources

B.

Update resources

C.

Update resources

D.

Update packages

Full Access
Question # 20

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

A.

Data Manipulation Language

B.

The Data Control Language

C.

The Database Language

D.

The Data Definition Language

E.

Data Transferred Language

Full Access
Question # 21

Which statement is true for SAP HANA?

A.

SAP has partnered with major hardware providers like HP, FUJITSU, CISCO, IBM, HITACHI etc. SAP only provides SAP HANA software which can run on the hardware provided by these partners

B.

SAP provides both hardware and software for SAP HANA.

Full Access
Question # 22

Analytic Privilege can be applied to (3 Answers)

A.

Calculation views

B.

Attribute views

C.

Analytic views

D.

Table

E.

SQL View

Full Access
Question # 23

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.

A.

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

B.

Two result sets

C.

One result set

D.

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

Full Access
Question # 24

Which engine is used to execute Analytic View?

A.

SQL Engine

B.

Calc Engine

C.

OLAP Engine

D.

Join Engine

Full Access
Question # 25

HANA modeling views can be created under

A.

Catalog

B.

Schema

C.

File System

D.

Content

Full Access