E-HANAAW-17 by SAP Valid Free Exam Practice Test

Question 1

Which rules does SAP recommended to improve the performance of ABAP report on SAP HANA? There are 2 correct answers to this question.

A. Perform all calculations and aggregations in the ABAP layer B. Use a nested SELECT statement instead of SELECT FOR ALL ENTRIES C. Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement D. Use array variants of INSERT UPDATE MODIFY and DELETE

Correct Answer: B,D

Question 2

Which tasks does the ABAP managed database (AMDP) framework perform? There are 2 correct answers to this question.

A. Delete the obsolete versions of the database procedure synchronously B. Delete the obsolete versions of the database procedure asynchronously C. Create a new version of the database when the AMDP is first activated D. Create a new version of the database when the AMDP is first called

Correct Answer: B,D

Question 3

Which of the following can be part of an analytic view? (3 answers)

A. Logical joins B. Query transformation C. Unions D. Attributes E. Data foundation

Correct Answer: A,D,E

Question 4

Which of the following is true?

A. ABAP B. Java C. Oc# D. OSQL

Correct Answer: D

Question 5

Which TADIR object type is used for the definition of a Core Data Services (CDS) view?

A. R3TR VIEW B. R3TR DDIC C. R3TR DDLS D. R3TR TABL

Correct Answer: C

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 alias of the CASE construct used in the SELECT list B. The CASE statement as provided in the SELECT list without its alias C. None; the GROUP BY list is added automatically D. The name of the gross amount column that is used in the CASE statement

Correct Answer: B

Question 7

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.

A. Column store B. Re-use component store C. Technology store D. Development Store E. Row store

Correct Answer: A,E

Question 8

Which character is used to escape host variables in the new Open SQL syntax?

A. : (colon) B. * (asterisk) C. @ (at) D. ~ (tilde)

Correct Answer: C

Question 9

Which of the following is latest release of SAP HANA?

A. SAP HANA 1.6 SP03 B. SAP HANA 1.0 C. SAP HANA 1.0 SP06 D. SAP HANA 2.0 SPS 04

Correct Answer: D

Question 10

What do you understand by the SAP HANA Software Optimization? Please choose the correct answer.

A. Speed up the processing within the database B. Provide combinations of objects and partitioning C. Huge potential for hybrid database D. Bring logic to where the data is calculated first then only move to results

Correct Answer: D

Question 11

What are the two Profitability Analysis available with CO-PA Scenario in SAP HANA Modeling? There are 2 correct answers to this question

A. Account-based Profitability B. Product-based Profitability C. Costing-based Profitability D. Service-based profitability

Correct Answer: A,C

Question 12

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

A. Conditional services B. ITe services C. Core Data Services D. Modell-ll services

Correct Answer: C

SAP Certified Development Specialist - ABAP for SAP HANA 2.0 - E-HANAAW-17 Exam Practice Test