E_HANAAW_16 by SAP Actual Free Exam Questions And Answers

Question 1

Which of the following are performance recommendations when using SAP HANA? There are 2 correct answers to this question.

A. Filter data in lower layers.

B. Avoid transferring large result sets between database and client applications.

C. Move data-intensive calculations from the database to an application server.

D. Define indexes on the columns that are used in calculations.

Discussion 0

Correct Answer: A,B Vote an answer

Question 2

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 3

What should you do to follow the code-to-data approach to programming? There are 3 correct answers to this question.

A. Transfer all data from the database to the ABAP layer, and then aggregate the results.

B. Aggregate data on the database, and transfer the results to the ABAP layer.

C. Use native SQL to access SAP HANA built-in functions.

D. Perform expensive calculations on the ABAP application server.

E. Perform expensive calculations on the database.

Discussion 0

Correct Answer: B,C,E Vote an answer

Question 4

Which is not a Golden Rule for Open SQL? Please choose the correct answer.

A. Minimize the Amount of Data Transferred

B. Keep the result set large

C. Minimize the Number of Database Accesses

D. Reduce the Database Load

Discussion 0

Correct Answer: B Vote an answer

Question 5

You use the ABAP trace (SAT) to measure the run time of a program. In a class, method X checks the validity of its importing parameters and calls method Y.
What pattern of gross and net run time would you expect to see the in the ABAP trace results for method X? Please choose the correct answer.

A. The gross and net run times are identical

B. The net run time is greater than the gross run time

C. The net run time is less than the gross run time

D. The net run time is equal to Zero

Discussion 0

Correct Answer: C Vote an answer

Question 6

Which system schema contains the column views of activated objects?

A. _SYS_XS

B. _SYS_REPO

C. _SYS_BIC

D. _SYS_BI

Discussion 0

Correct Answer: C Vote an answer

Question 7

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 lower value than on a traditional, row-store only based database

B. A value that you calculate based on the number of tables

C. The same value as on a traditional, row-store only based database

D. A higher value than on a traditional, row-store only based database

Discussion 0

Correct Answer: A Vote an answer

Question 8

What are the ABAP development guidelines? There are 2 correct answers to this question.

A. Improved tools for performance analysis

B. Improved hybrid components for SAP HANA

C. Consuming Only ABAP contents for SAP HANA

D. Extensions to ABAP Language

Discussion 0

Correct Answer: A,D Vote an answer

Question 9

What are the benefits associated with The SAP HANA real-time Operational analytics? There are 2 correct answers to this question

A. Simplification of massive data

B. High modeling flexibility

C. Fast insights into business activity

D. Query Speed support

Discussion 0

Correct Answer: B,C Vote an answer

Question 10

Explain the Authorization Concept and the types of privileges associated with it? There are 3 correct answers to this question

A. Application privileges

B. System privileges

C. Package privileges

D. Analytic privileges

E. Object privileges

Discussion 0

Correct Answer: B,D,E Vote an answer

Question 11

What is the main purpose of SAML for SAP HANA Studio? Choose the correct answer

A. SAML may be selected as an Owner's authentication method when creating users in the SAP HANA Studio

B. To support scenarios where clients are not directly connected to the SAP HANA Database

C. The assertion is issued by a user after the client was successfully authenticated

D. The SAP HANA database supports login of Owners only

Discussion 0

Correct Answer: B Vote an answer

Question 12

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 13

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

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

Contact Us

Useful Links

Latest Updated