E_HANAAW_17 by SAP Actual Free Exam Questions And Answers

Question 1

SAP HANA: Delivers Across 5 Dimensions. These five dimensions lead to certain goals HANAhas to meet. What are these goals?
There are 2 correct answers to this question.

A. Analytical DBMS features

B. Hybrid data and management system

C. High Performance and Scalability

D. Support for system tables

Discussion 0

Correct Answer: B,C Vote an answer

Question 2

Which of the following is latest release of SAP HANA?

A. SAP HANA 1.0 SP06

B. SAP HANA 2.0 SPS 04

C. SAP HANA 1.6 SP03

D. SAP HANA 1.0

Discussion 0

Correct Answer: B 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

What are the principles of Using HANA Transport Containers properly? There are 3 correct answers to this question.

A. To create Transport container of delivery unit

B. Release of Transport request

C. Takes a 'snapshot' of all SAP HANA objects of delivery unit

D. Import of Transport Request

E. Automatic update for all export methods

Discussion 0

Correct Answer: B,C,D Vote an answer

Question 5

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

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

B. Database administration should be restricted to skilled

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

D. Access to ERP tables must be restricted

Discussion 0

Correct Answer: B,D Vote an answer

Question 6

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 procedure

Discussion 0

Correct Answer: B Vote an answer

Question 7

Which system schema contains the information about Time data and Schema Mapping?

A. _SYS_XS

B. _SYS_REPO

C. _SYS_BIC

D. _SYS_BI

Discussion 0

Correct Answer: D Vote an answer

Question 8

You define and implement an ABAP Managed database procedure (AMDP). What do you have to list after the USING clause? (3 right answers)

A. AMDP used in the procedure body

B. SAP HANA views used in the procedure body

C. function used in the procedure body

D. ABAP Dictionary views used in the procedure body

E. ABAP Dictionary table used in the procedure body

Discussion 0

Correct Answer: A,D,E Vote an answer

Question 9

Which of the following information is mandatory in the definition of an association in a Core Data Services (CDS) view?

A. The target entity of the association

B. The filter condition for the association

C. The cardinality of the association

D. The alias for the association

Discussion 0

Correct Answer: A Vote an answer

Question 10

You apply static code checks on your ABAP coding to find performance optimization potential and receive a message about a "Problematic SELECT * statement" issue. How can you improve the performance of your ABAP code?

A. Use the Open SQL SELECT RELEVANT statement.

B. Use Native SQL to perform the SELECT * statement.

C. Use a field list containing only the relevant fields.

D. Use the ABAP pragma ##OPTIMIZE_QUERY.

Discussion 0

Correct Answer: C Vote an answer

Question 11

You created and activated database procedure. How can you call this procedure? There are 2 correct answers to this question.

A. By using Sap Analysis for Microsoft office

B. By a script-based calculation view

C. By a core data services view

D. By another database procedure

Discussion 0

Correct Answer: B,D Vote an answer

Question 12

Which of the following can be part of an analytic view? (3 answers)

A. Query transformation

B. Logical joins

C. Data foundation

D. Unions

E. Attributes

Discussion 0

Correct Answer: B,C,E Vote an answer

Question 13

In order to get language-specific data, which join is used in SAP HANA?

A. Language join

B. It is not possible to fetch language-specific data in HANA

C. Referential Join

D. Text Join

Discussion 0

Correct Answer: D Vote an answer

Question 14

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

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

Contact Us

Useful Links

Latest Updated