SAP Certified Development Specialist - ABAP for SAP HANA (Edition 2016) (E_HANAAW_12) Free Practice Test

Question 1

You are implementing an ABAP Managed Database Procedures (AMDP) for SAP HAN

A. Implement the interface IF_AMDP_MARKER_HDB

B. Implement the ABAP AMDP_HDB Event Handler.

C. What do you have to do in the corresponding ABAP class?
Please choose the correct answer.

D. Set the visibility of the corresponding class method in the declaration section to PUBLIC

E. Declare the ABAP class as a sub-class of CL_AMDP_RUNTIME_HDB.

Correct Answer: E

Question 2

How will you select a preference for Validation rules?
Choose the correct answer

A. Windows- Modeler - Preferences-SAP HANA-Validation Rules

B. Windows- SAP HANA-Modeler-Preferences-Validation Rules

C. Windows- Preferences-SAP HANA-Modeler-Validation Rules

D. Windows- SAP HANA-Preferences-Modeler-Validation Rules

Correct Answer: C

Question 3

Which of the following are performance recommendations when using SAP HANA?
There are 2 correct answers to this question.

A. Move data-intensive calculations from the database to an application server.

B. Filter data in lower layers.

C. Avoid transferring large result sets between database and client applications.

D. Define indexes on the columns that are used in calculations.

Correct Answer: B,C

Question 4

Why is a security concept in SAP HANA required?
There are 2 correct answers to this question

A. Access to ERP tables must be restricted

B. Database administration should be restricted to skilled

C. Editing of SAP HANA data models should only be possible for "Users." of the model

D. Need to have selected users in SAP HANA for Information Management

Correct Answer: A,B

Question 5

What are the two main methods to add a system to the SAP HANA Studio?
There are 2 correct answers to this question

A. By Resource console

B. By Importing a Landscape

C. Manually

D. Automatically

Correct Answer: C,D

Question 6

What made SAP HANA possible?
There are 2 correct answers to this question.

A. CPU with single core network

B. Technology and innovations

C. RAM limitation

D. Improved hardware technology

Correct Answer: B,D

Question 7

What are the steps that supported several tools, which in total result in a Guided Performance Optimization?
There are 2 correct answers to this question.

A. The ABAP Trace (SAT) and the ABAP Profiling perspective to measure and compare runtime consumption

B. A new tool called SQL Monitor to determine the priority if different programs access the database intensively

C. A selection Code Inspector (SCI) and ABAP Test Cockpit (ATC) to locate potential functional and performance issues.

D. Tools analyzing performance at run-time, to determine if critical constructs

Correct Answer: B,D

Question 8

What is the Limitations of ALV for SAP HANA?
There are 3 correct answers to this question.

A. No unit/ currency split if aggregating amounts/ currency values

B. All unit/ currency restricted to 10,00,00 records

C. Restricted to 10,000 records

D. Without currency /unit consideration

E. Restricted to 5000 records / unit

Correct Answer: A,C,D

Question 9

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. Data Manipulation Language

B. The Data Definition Language

C. The Data Control Language

D. Data Transferred Language

E. The Database Language

Correct Answer: A,B,C

Question 10

What are the features of New Open SQL?
There are 2 correct answers to this question.

A. Supports arithmetic and string expressions

B. Supports specific units of database

C. Supports Code adjustment model

D. Supports conditional expressions

Correct Answer: A,D

Welcome to TestSimulate

SAP Certified Development Specialist - ABAP for SAP HANA (Edition 2016) (E_HANAAW_12) Free Practice Test