Online Access Free E_HANAAW_18 Exam Questions

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 amount of transferred data.
• B.Minimize the number of database accesses.
• C.Keep unnecessary load away from the database.
• D.Minimize the search overhead.

You are programming a report that reads data from a secondary HANA database (DB). What do you need to consider in your SQL statement? Note: There are 2 correct answers to this question.

• A.You have to specify the DB schema explicitly in your statement.
• B.You have to specify the DB connection explicitly in your statement.
• C.You have to use native SQL when reading data from the secondary DB.
• D.All tables and fields you are using must exist in the ABAP Dictionary of the secondary DB.

Which of the following features does the ABAP Test Cockpit offer that the ABAP Code Inspector does NOT offer? Note: There are 2 correct answers to this question.

• A.Documented checks
• B.Configuration of check variants
• C.Flexible schedule of check runs
• D.Enhanced distribution of results

Which rules does SAP recommend to improve the performance of ABAP reports on SAP HANA? Note: There are 2 correct answers to this question.

• A.Ensure the access to buffered tables uses the SAP table U buffer.
• B.Ensure the WHERE clause contains at least one index field.
• C.Perform all calculations and aggregations in the ABAP U layer.
• D.Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement.

You implement an ABAP-managed database procedure (AMDP). Within this AMDP, you want to query data from calculation view CA_BOOKINGS_COUNT in SAP HANA content package ha400.primdb. How can you address the calculation view? Note There are 2 correct answers to this question.

• A._SYS_BIC."ha400.primdb/CA_BOOKINGS_COUNT"
• B."ha400.primdb: :CA_BOOKINGS_COUNT"
• C._SYS_BIC."ha400.primdb::CA_BOOKINGS_COUNT"
• D."ha400.primdb/CA_BOOKINGS_COUNT"