E_HANAAW_14 by SAP Valid Free Exam Practice Test

Question 1

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

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

Correct Answer: A,C

Question 2

What all are the steps to perform -To enable type-ahead for an input field on a screen? There are 3 correct answers to this question.

A. Check Pre-Requisites B. Process on all the input fields C. Automatic updates of all the input fields D. Identify Elementary Search Help E. Switch on proposal search for input fields

Correct Answer: A,D,E

Question 3

Name some perspectives that are available in the SAP HANA Studio? (3 ans)

A. The technology & innovation perspective B. The information perspective C. The Resources perspective D. The Administration Console perspective E. The SAP HANA Modeler Perspective

Correct Answer: C,D,E

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

Correct Answer: A,B,D

Question 5

You have an SQLScript procedure with a table input parameter it_books. You want to use the parameter on the right-hand side of an assignment operator within the procedure. How do you refer to the parameter? Please choose the correct answer.

A. @it_books B. :it_books C. {it.books} D. it_books

Correct Answer: B

Question 6

What are the components of The Enterprise Procurement Model Demo Scenario? There are 3 correct answers to this question.

A. Stock B. Product C. Sales D. Procurement E. Services

Correct Answer: A,C,D

Question 7

SAP HANA DB Migration: you want to avoid any functional issues after the migration? There are 3 correct answers to this question.

A. Left outer joins in open SQL statements B. Direct access to a cluster on the database C. Code that relies on implicit database sorting D. Native sql statement E. Order by clause in open SQL statement

Correct Answer: B,C,D

Question 8

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

Correct Answer: B,C,D

Question 9

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. Definition of full-text indexes B. Storage type for tables C. Definition of an enhancement category D. Changes of data class E. De-pooling and de-clustering

Correct Answer: A,B,E

Question 10

How SAP HANA supports SQL?
There are 3 correct answers to this question.

A. Read B. As a means to define C. Transferring data D. As a Data Calculator E. Manipulate data

Correct Answer: A,B,E

Question 11

What are the benefits of using the SQL Monitor (transaction SQLM)? There are 2 correct answers to this question.

A. It schedules ABAP programs to monitor and log all database accesses. B. It collects monitoring data asynchronously without additional database interaction. C. It displays the database execution plan for all SQL statements. D. It can be active in a production system with minimal performance overhead.

Correct Answer: B,D

SAP Certified Development Specialist - ABAP for SAP HANA 2.0 - E_HANAAW_14 Exam Practice Test