SAP Certified Development Specialist - ABAP for SAP HANA 2.0

QUESTION NO: 1
In SAP HANA SQL, you want to create a table whose definition should NOT be visible in the catalog? Which of the following table types fulfill this requirement? Please choose the correct answer.

A. LOCAL TEMPORARY B. ROW C. COLUMN D. GLOBAL TEMPORARY

Correct Answer: A

QUESTION NO: 2
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. The Data Definition Language B. The Data Control Language C. Data Manipulation Language D. The Database Language E. Data Transferred Language

Correct Answer: A,B,C

QUESTION NO: 3
What is the scope of the AbapCatalog.Buffering annotation in a Core Data Services (CDS) view?

A. The CDS views used in the FROM clause B. The entire CDS view C. The elements in the projection list of the CDS view D. The set of key fields specified in the additional annotation AbapCatalog.buffering.numberOfKeyFie

Correct Answer: B

QUESTION NO: 4
Which components can be a part of a calculation view? (2 answers)

A. Tables B. Attribute View C. Analytic View D. BAPIs

Correct Answer: A,B

QUESTION NO: 5
What are functions of the ABAP Managed Database Procedure (AMDP) framework? (2 right answers)

A. It creates the database procedure when the AMDP is first called. B. It deletes obsolete versions of the database procedure asynchronously C. It deletes obsolete versions of the database procedure synchronously D. It creates the database procedure when the AMDP is first activated.

Correct Answer: A,B

QUESTION NO: 6
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. Group rows B. Search in content C. Display diagrams D. Double-click on rows E. Edit cells

Correct Answer: A,B,C

QUESTION NO: 7
List down the three main concepts of the SAP HANA database There are 3 correct answers to this question

A. Compression B. Tools combinations C. Partitioning D. Object store E. Column Store

Correct Answer: A,C,E

QUESTION NO: 8
Which of the following categories of parameters can you use in the definition of an ABAP manage database procedure (AMDP)?
There are 3 correct answers to this question.

A. Receiving B. Exporting C. Importing D. Changing E. Returning

Correct Answer: B,C,D

QUESTION NO: 9
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 alias of the CASE construct used in the SELECT list B. None; the GROUP BY list is added automatically 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

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