SAP E_HANAAW_17 Exam Practice Questions and Answers

Question 6 of 40

Which task can you perform with the SQL Monitor (transaction SQLM)?

A.

Capture the SQL profile of an application

B.

Search the problematic SELECT * statements

C.

Display the execution plan of an SQL statement

D.

Combine static and dynamic performance analysis results

Question 7 of 40

Which functional problem can you detect when using the Runtime Check Monitor (SRTCM)?

A.

Use of Native SQL and DB Hints

B.

Existence check for Secondary Indexes

C.

Direct access to Table Pools/Cluster

D.

Missing ORDER BY or SORT after SELECT

Question 8 of 40

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

A.

Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement

B.

Perform all calculations and aggregations in the ABAP layer

C.

Ensure the WHERE clause contains at least one index field

D.

Ensure the access to buffered tables uses the SAP table buffer

Question 9 of 40

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

A.

All classical open SQL statements in your program will become invalid

B.

All ABAP variables must be escaped with a preceding @ sign

C.

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

D.

All arithmetic expressions can be used for all types of variables

Question 10 of 40

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

A.

The full-text index is always updated asynchronously

B.

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

C.

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

D.

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