SAP e-hanaaw-17 practice test

Certified Development Specialist - ABAP for SAP HANA 2.0 Exam Exam


Question 1

You want to execute a native SQL statement in your program. Why should you use ABAP Database
Connectivity (ADBC)? (Choose Two)

  • A. It has syntax check as compile time.
  • B. It supports exception handling
  • C. It supports locking and commit handling
  • D. It supports where-used list.
Answer:

BC

Discussions

Question 2

What are the Functions of Transaction DBACOCKPIT There are 2 correct answers to this question.

  • A. Use Schema for the Connections
  • B. Maintain, Monitor and test secondary database connection
  • C. Maintain only HANA specific objects
  • D. Used to access local or remote database system
Answer:

B, D

Discussions

Question 3

What are the key points that should be kept in mind while performing the Non-automatic
update in SAP HANATr.Cont.? There are 2 correct answers to this question.

  • A. Automatic release of units
  • B. Changes to Delta Container
  • C. You need to refresh the content of the container manually
  • D. Take snapshot manually before releasing of the container
Answer:

C, D

Discussions

Question 4

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 Control Language
  • C. The Database Language
  • D. The Data Definition Language
  • E. Data Transferred Language
Answer:

A, B, D

Discussions

Question 5

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

  • A. Supports arithmetic and string expressions
  • B. Supports Code adjustment model
  • C. Supports specific units of database
  • D. Supports conditional expressions
Answer:

A, D

Discussions

Question 6

You create a check variant in the Code Inspector which includes the check 'Search problematic Select
* statements'. SAP
HANA is used as the db
In the check parameters, which value would you use for the percentage of fields that are effectively
used?
Please choose the correct answer.

  • A. A value that you calculate based on the number of tables
  • B. A higher value than on a traditional, row-store only based database
  • C. A lower value than on a traditional, row-store only based database
  • D. The same value as on a traditional, row-store only based database
Answer:

C

Discussions

Question 7

When are referential joins executed in analytical views? Choose the correct answer

  • A. When all the tables are optimized
  • B. When fields are selected
  • C. When fields are optimized
  • D. When fields from both the tables are requested
Answer:

D

Discussions

Question 8

What is the main function of Static Code Analysis? Please choose the correct answer.

  • A. To detect code that would lead to functional or performance issues When migrating to SAP HANA
  • B. Integrates with SAP Solution Manager
  • C. Integrated into ABAP Development Tools and ABAP Workbench
  • D. ABAP source code with performance optimization potential
Answer:

A

Discussions

Question 9

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

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

B

Discussions

Question 10

Which of the following feature were added to the ABAP Dictionary to support the SAP HANA
database? There are 3 correct answers to this question.

  • A. De-pooling and de-clustering
  • B. Changes of data class
  • C. Definition of full-text indexes
  • D. Definition of an enhancement category
  • E. Storage type for tables
Answer:

A, C, E

Discussions
To page 2