E-HANAAW-14 by SAP Actual Free Exam Questions And Answers

Question 1

Which of the following tools and programming techniques use the SQL data definition language? There are 2 correct answers to this question.

A. Core data services (CDS) data definition

B. Open SQL

C. ABAP Dictionary

D. Core data service (CDS) access control

Discussion 0

Correct Answer: B,D Vote an answer

Question 2

Which tools can you use to provide input data for the SQL performance tuning work list (Transaction SWLT)?
There are 3 correct answers to this question.

A. Data base performance monitor (transaction DB50)

B. SQL Trace (transaction ST05)

C. SQL monitor (transaction SQLM)

D. ABAP test cockpit (transaction ATC)

E. Code inspector (transaction SCI)

Discussion 0

Correct Answer: C,D,E Vote an answer

Question 3

Which of the following repository object can you edit only in ABAP Development tools in Eclipse and not in the Classical ABAP workbench?
There are 3 correct answers to this question.

A. External view

B. Full-text index

C. Core Data service (CDS) view

D. Database procedure proxy

E. ABAP program containing new Open SQL

Discussion 0

Correct Answer: A,C,D Vote an answer

Question 4

Discuss the main capabilities of SAP BusinessObjects Analysis for Office? There are 2 correct answers to this question

A. Sort data by characteristics

B. Suggests style sets for crosstabs

C. Analyze data with the design pane

D. Convert crosstab cells to formula

Discussion 0

Correct Answer: C,D Vote an answer

Question 5

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. You need to refresh the content of the container manually

B. Take snapshot manually before releasing of the container

C. Automatic release of units

D. Changes to Delta Container

Discussion 0

Correct Answer: A,B Vote an answer

Question 6

The SAP HANA database is a hybrid in-memory database that combines Few technologies within.
What are these technologies?
There are 3 correct answers to this question

A. Value-based database technology

B. Column-based database technology

C. Object-based database technology

D. Time-based database technology

E. Row-based database technology

Discussion 0

Correct Answer: A,C,E Vote an answer

Question 7

What are the basic principles of ALV SAP HANA? There are 2 correct answers to this question.

A. Only retrieve the database data which is to be displayed on screen

B. To ensure that the user chooses the data on the selection screen is displayed

C. Data described declaratively instead of passing big internal tables

D. The ALV Optimization for SAP HANA to display data on the screen

Discussion 0

Correct Answer: A,C Vote an answer

Question 8

What are the elements of ABAP Database Integration? There are 3 correct answers to this question.

A. Client database handling

B. DB client-server

C. DB For ABAP

D. Application server

E. Other DB

Discussion 0

Correct Answer: C,D,E Vote an answer

Question 9

How many result sets are returned when an SAP HANA database procedure is called using the CALL WITH OVERVIEW statement?
Please choose the correct answer.

A. Two result sets

B. One result set

C. As many result sets as there are table output parameters in the procedure

D. As many result sets as there are input parameters in the procedur

Discussion 0

Correct Answer: B Vote an answer

Question 10

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

A. Read

B. As a Data Calculator

C. Transferring data

D. As a means to define

E. Manipulate data

Discussion 0

Correct Answer: A,D,E Vote an answer

Question 11

What are the steps involved in supporting a database oriented programming model? There are 2 correct answers to this question.

A. A new and advanced Open SQL

B. Advanced and specific models

C. Core Data services

D. Buffer system services

Discussion 0

Correct Answer: A,C Vote an answer

Question 12

You define a core data services (CDS) View. For which of the following expressions and built in functions must you provide alias?
There are 3 correct answers to this question.

A. CASE expression

B. CASTE Expression

C. Unit conversion

D. Nested CASE expression

E. Currency Conversion

Discussion 0

Correct Answer: A,C,E Vote an answer

Question 13

What are the uses of SQL Trace (ST05)? There are 3 correct answers to this question.

A. Locate database performance issues

B. Locate work base issues

C. Display record of all database access

D. Applying Code inspector

E. Detect redundant or identical select statements

Discussion 0

Correct Answer: A,C,E Vote an answer

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

Contact Us

Useful Links

Latest Updated