SAP E_HANAAW_17 Exam Questions

Question 6 of 38

Which rules does SAP recommend to improve the performance of ABAP reports on SAP HANA? (Choose two.)

Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement

Perform all calculations and aggregations in the ABAP layer

Ensure the WHERE clause contains at least one index field

Ensure the access to buffered tables uses the SAP table buffer

Correct Answer: C, D

Question 7 of 38

What must you take into consideration when you use the new Open SQL syntax (available as of SAP NetWeaver 7.4 SP05)? (Choose two.)

All classical open SQL statements in your program will become invalid

All ABAP variables must be escaped with a preceding @ sign

All fields in the GROUP BY clause must be separated by commas

All arithmetic expressions can be used for all types of variables

Correct Answer: B, C

Question 8 of 38

When using an SAP HANA full text search, what do you have to keep in mind?

The full-text index is always updated asynchronously

SAP HANA has to be the primary database to create a full text search

The LIKE operator is required in your SELECT statement to implement fuzzy logic

The SCORE ( ) function is required to ensure the best hits of your search appear on top

Correct Answer: D

Question 9 of 38

You use ABAP Database Connectivity (ADBC) to issue native SQL calls to the database.
Which method of class CL_SQL_RESULT_SET retrieves the entire result set of the native SQL call?

EXECUTE_QUERY

NEXT_PACKAGE

SET_PARAM_TABLE

Correct Answer: B

Question 10 of 38

You want to move some of the logic of an ABAP program into an ABAP-managed database procedure (AMDP). To do so, you need to translate Open SQL statements into SAP HANA Native SQL.
Which of the following are necessary adjustments? (Choose three.)

Replace CORRESPONDING FIELDS additions

Add explicit client handling

Specify the schema for every table

Replace ORDER BY additions

Replace UP TO n ROWS additions

Correct Answer: A, B, E