SAP Certified Development Specialist - ABAP for SAP HANA 2.0 (E-HANAAW-17) Free Practice Test

Question 1

Which of the statements are true for SQLScript? (2 answers)

A. SQLScript is used to push down data intensive logic into the database.

B. SQLScript is a collection of extensions to SQL.

C. SQLScript is an open standard.

Correct Answer: A,B

Question 2

You import an ABAP workbench request into a SAP SYSTEM P81. The ABAP workbench request contains a single SAP HANA VIEW CA_CUSTOMER that belongs to package 2HA400_00. WHICH PREREQISITIES are mandatory for an implicit deployment of the SAP HANA view onto the database? There are 2 correct answers to this question.

A. View CA_CUSTOMER has deployment mode A.

B. Package ZHA400_00 Is listed in table SNHI_DUP_PREWORK

C. PACKAGE ZHA400J30 HAS deployment Mode A

D. SYSTEM P81 has SAP HANA has primary database

Correct Answer: B,D

Question 3

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

A. The entire CDS view

B. The elements in the projection list of the CDS view

C. The CDS views used in the FROM clause

D. The set of key fields specified in the additional annotation AbapCatalog.buffering.numberOfKeyFie

Correct Answer: A

Question 4

What are best practices when programming in ABAP for SAP HANA? There are 2 correct answers to this question.

A. Eliminate nested SELECT statements to reduce the overall number of database accesses

B. Use repeated SELECT SINGLE statements to ensure that you only read arrow if it is really required

C. Use a column list in the SELECT clause to ensure that you only read a column if it is really required

D. Calculate aggregations using ABAP code on the application server to limit database load

Correct Answer: A,C

Question 5

What are the key points that should be kept in mind while performing the Nonautomatic update in SAP HANA Transport Container? (2 right answers)

A. You need to refresh the content of the container manually

B. Take snapshot manually before releasing of the container

C. Changes to Delta Container

D. Automatic release of units

Correct Answer: A,B

Question 6

What is the main benefit of the SQL Performance Tuning Worklist?

A. It allows you to simulate the impact of performance optimization patterns.

B. It establishes a governance process for performance optimizations.

C. It automatically translates ABAP coding to SQLScript.

D. It allows you to correlate the results of an ABAP source code analysis with SQL runtime data.

Correct Answer: D

Question 7

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 the Column Store storage type

C. SELECT * statements on tables with more than 100,000 records

D. SELECT * statements on tables with more than a specified number of fields

Correct Answer: A

Question 8

You want to implement business logic on the database layer.
Which approach do you follow when implementing an ABAP Managed Database Procedure?

A. The Inside-Out approach

B. The Left-Right approach

C. The Near-Far approach

D. The Top-Down approach

Correct Answer: D

Question 9

Which of the below statements are true for SAP HANA Studio? (3 right answers)

A. SAP HANA Studio is a client tool, which can be used to access local or remote HANA system.

B. SAP HANA Studio is an Eclipse-based, integrated development environment (IDE) that is used to develop artifacts in a HANA server.

C. SAP HANA Studio can be used to manage the SAP HANA database, to create and manage user authorizations, to create new or modify existing models of data etc

D. SAP HANA Studio is integrated in SAP GUI > 7.40

Correct Answer: A,B,C

Question 10

User STUDENT_A creates and activates a design-time Object. In which schema is the runtime object generated?

A. SYSTEM

B. STUDENT_A

C. SYS_BI

D. _SYS_BIC

Correct Answer: D

Question 11

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. Left outer joins in open SQL statements

B. Code that relies on implicit database sorting

C. ORDER BY Clauses in Open SQL statements

D. Direct access to a cluster on the database

E. Native SQL statements

Correct Answer: B,D,E

Welcome to TestSimulate

SAP Certified Development Specialist - ABAP for SAP HANA 2.0 (E-HANAAW-17) Free Practice Test