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

Question 1

Which Of the Golden Rules for Open SQL performance have become more important With SAP HANA?
Note: There are 2 correct answers to this question.

A. Minimize the number of database accesses

B. Minimize the search overhead.

C. Keep unnecessary load away from the database.

D. Minimize the amount of transferred data

Discussion 0

Correct Answer: A,D Vote an answer

Question 2

What is the main purpose of Analytic Privilege?

A. Restrict user to access modeling view

B. Restrict row level access so that user will be able to see only certain portion of the data

C. Restrict users to access database tables

Discussion 0

Correct Answer: B Vote an answer

Question 3

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 4

Which rules does SAP recommended to improve the performance of ABAP report on SAP HANA? There are 2 correct answers to this question.

A. Perform all calculations and aggregations in the ABAP layer

B. Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement

C. Use a nested SELECT statement instead of SELECT FOR ALL ENTRIES

D. Use array variants of INSERT UPDATE MODIFY and DELETE

Discussion 0

Correct Answer: C,D Vote an answer

Question 5

One of your SAP systems needs to be migrated from its current database to an SAP HANA database. You want to avoid any functional issues after the migration. What should you search for and if necessary replace in the existing custom ABAP code? There are 3 correct answers to this question.

A. Code that relies on implicit database sorting

B. ORDER BY Clauses in Open SQL statements

C. Left outer joins in open SQL statements

D. Native SQL statements

E. Direct access to a cluster on the database

Discussion 0

Correct Answer: A,D,E Vote an answer

Question 6

What all are the Types of Applications based on SAP HANA? There are 2 correct answers to this question.

A. Innovation based on SAP HANA

B. New or Native SAP HANA

C. Data Mart based on SAP HANA

D. Server based on SAP HANA

Discussion 0

Correct Answer: B,C Vote an answer

Question 7

You have defined the following SQLScript procedure: CREATE PROCEDURE LANGUAGE SQLSCRIPT SQL SECURITY DEFINER READS SQL DATA.
Which type of database procedures can be called in this SQLScript procedure? Please choose the correct answer.

A. Write only

B. Read only

C. Read-update

D. Read-write

Discussion 0

Correct Answer: B Vote an answer

Question 8

Which components can be a part of a calculation view? (2 answers)

A. Tables

B. BAPIs

C. Analytic View

D. Attribute View

Discussion 0

Correct Answer: A,D Vote an answer

Question 9

What is an attribute view and what are its practices? There are 3 correct answers to this question.

A. Used to join tables

B. May contain filters

C. May contains flow charts

D. May use in calculation views

E. Used in diagrammatic Projections

Discussion 0

Correct Answer: A,B,D Vote an answer

Question 10

According to the performance analysis recommendations; which steps are recommended after doing a database migration to SAP HANA?

A. Switch the storage type of you custom database tables to column store and use the database utility (SE14) to perform the database table conversion.

B. Perform regular performance scans on the ABAP coding delivered by SAP as part of your development process.

C. Activate your ABAP custom coding, which was deactivated before the database migration, using U transaction SFW5.

D. Perform regular performance scans on your ABAP custom coding as part of the development process.

Discussion 0

Correct Answer: D Vote an answer

Question 11

How can you enhance an existing ABAP Search Help with a type-ahead function?

A. Modify the search help with the Native SQL command ALTER SEARCH HELP.

B. Enhance the lookup table with an additional ACCURACY field and insert an accuracy value.

C. Use the enhanced options in transaction SE11.

D. Use the fuzzy-search exit in transaction SE11.

Discussion 0

Correct Answer: C Vote an answer

Question 12

Which of the following objects can you use in the ABAP layer when using the top-down approach to bring code to data? There are 2 correct answers to this question

A. ABAP managed database procedures

B. Core data services views

C. Stored procedure

D. Calculation views

Discussion 0

Correct Answer: A,B Vote an answer

Question 13

What views will be most efficient for General Modeling Principles? There are 2 correct answers to this question

A. Attribute view

B. Column view

C. Analytical view

D. Schema view

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