SAP Certified Development Specialist - ABAP for SAP HANA 2.0 (E_HANAAW_17) Free Practice Test

Question 1

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

A. Data Manipulation Language (DML)

B. The Data Control Language (DCL)

C. Data Transferring Language(DTL)

D. Data Evaluation Language(DEL)

E. The Data Definition Language (DDL)

Correct Answer: A,B,E

Question 2

What is the system privilege required to drop analytic privilege?

A. STRUCTUREDPRIVILEGE ADMIN

B. CREATE PRIVILEGE

C. PRIVILEGE ADMIN

D. CREATE STRUCTURED PRIVILEGE

Correct Answer: A

Question 3

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

A. To supply suitable values for any input parameters

B. To activate and execute the program in the application

C. Derived column headings from the data element

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

Correct Answer: B

Question 4

An Analytic Privilege consists of several restrictions. What are they? There 3 correct answers to this question

A. Validity restrictions

B. Activity restrictions

C. Analytic restrictions

D. View restrictions

E. Cube restrictions

Correct Answer: A,B,E

Question 5

HANA modeling views can be created under

A. Content

B. Catalog

C. File System

D. Schema

Correct Answer: A

Question 6

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. The name of the gross amount column that is used in the CASE statement

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

C. None; the GROUP BY list is added automatically

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

Correct Answer: B

Question 7

What are the different types of Calculation View? (2 answers)

A. Graphical Calculation View

B. Scripted Calculation View

C. OLAP Calculation View

D. Text-Based Calculation

Correct Answer: A,B

Question 8

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

A. SQLM

B. SE3S

C. SE09

D. ST22

E. SWLT

Correct Answer: A,E

Question 9

You want to move some of the logic of an ABAP program into an ABAP-managed database procedure (AMDP). To do so, you need to translate Open SQL statements into SAP HANA Native SQL Which of the following are necessary adjustments? Note: There are 3 correct answers to this question.

A. Replace CORRESPONDING FIELDS additions

B. Add explicit client handling

C. Replace ORDER BY additions

D. Specify the schema for every table

E. Replace UP TO n ROWS additions

Correct Answer: A,B,E

Welcome to TestSimulate

SAP Certified Development Specialist - ABAP for SAP HANA 2.0 (E_HANAAW_17) Free Practice Test