SAP Certified Development Specialist - ABAP for SAP HANA 2.0

Question 1

You are working with ABAP Development Tools (ADT) For Eclipse. Which of the following options belongs to the settings of a specific ABAP project rather than the entire Eclipse workbench?

A. Editor shortcut key options

B. Statement template options

C. Code completion options

D. Code formatting options

Correct Answer: D

Question 2

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.

A. Open the package Select take snapshot and Save Activate the SAP HANA Delivery unit Activate the SAP HANA transport container

B. Open the ABAP transport request Select take snapshot and Save
Activate the SAP HANA transport container

C. Open the SAP HANA delivery unit Select take snapshot and Save Activate the SAP HANA Delivery unit Activate the SAP HANA transport container

D. Open the SAP HANA transport containerSelect take snapshot and Save
Activate the SAP HANA Transport Container

Correct Answer: D

Question 3

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. SQL monitor (transaction SQLM)

B. Data base performance monitor (transaction DB50)

C. SQL Trace (transaction ST05)

D. ABAP test cockpit (transaction ATC)

E. Code inspector (transaction SCI)

Correct Answer: A,D,E

Question 4

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

A. To activate and execute the program in the application

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

C. Derived column headings from the data element

D. To supply suitable values for any input parameters

Correct Answer: A

Question 5

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?

A. None; the GROUP BY list is added automatically

B. The alias of the CASE construct used in the SELECT list

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

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

Correct Answer: C

Question 6

In order to get language-specific data, which join is used in SAP HANA?

A. It is not possible to fetch language-specific data in HANA

B. Language join

C. Referential Join

D. Text Join

Correct Answer: D

Question 7

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

A. Minimize the Amount of Data Transferred

B. Minimize the Number of Database Accesses

C. Keep the result set large

D. Reduce the Database Load

Correct Answer: C

Question 8

Which recent software innovations are applied in SAP HANA? 3 ans

A. Columnar data storage

B. Improved data compression algorithms

C. Random Undefined Multi-Memory Swapping (RUMMS)

D. Automated de-installation at system shutdown

E. Insert Only approach

Correct Answer: A,B,E

Question 9

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. ABAP Development Tools for SAP NetWeaver

C. SAP HANA Tools

D. None; everything is preconfigured

Correct Answer: D

Question 10

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

A. Modell-ll services

B. Core Data Services

C. Conditional services

D. ITe services

Correct Answer: B

Question 11

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 packages

C. Update resources

D. Update resources

Correct Answer: A

Question 12

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

A. Data Evaluation Language(DEL)

B. The Data Definition Language (DDL)

C. Data Transferring Language(DTL)

D. Data Manipulation Language (DML)

E. The Data Control Language (DCL)

Correct Answer: B,D,E

Question 13

HANA modeling views can be created under

A. Schema

B. Content

C. File System

D. Catalog

Correct Answer: B

Question 14

Explain the Authorization Concept and the types of privileges associated with it? There are 3 correct answers to this question

A. Analytic privileges

B. System privileges

C. Package privileges

D. Object privileges

E. Application privileges

Correct Answer: A,B,D

Question 15

You are using a calculated column COUNTS within your Dimension Calculation View and an aggregation node. This is the data that goes into the aggregation node:

A. AT Vienna 11
AT Vienna 15
DE Berlin 13

B. AT Vienna 26
DE Berlin 26

C. AT Vienna 11
DE Berlin 13

D. AT Vienna 11
AT Vienna 15
DE Berlin 13
DE Berlin 13

Correct Answer: C

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

Latest Update

Useful Links

Contact Us