1. When using a secondary database connection, the default schema is derived from the database user which is stored in the secondary database connection. True False.
2. Which of the following are potential functional issues when migrating ABAP code to SAP HANA?
Choose the correct answers. (A) Use of native SQL or DB Hints (B) Use of secondary database connections (C) Coding that assumes that a SELECT result is always sorted (D) The existence of customer-specific cluster tables (E) The existence of table appends.
3. Where do you define a set of Code Inspector checks which you want to perform?
Choose the correct answer. (A) In a Code Inspector object list (B) In a Code Inspector object check variant (C) In a Code Inspector inspection.
4. When migrating to SAP HANA, every SELECT statement immediately becomes faster. True False.
5. Because SAP HANA stores all data in memory, buffering of data on the application server becomes less important. True False.
6. Which of the following patterns are known to potentially cause performance issues when accessing SAP HANA database?
Choose the correct answers. (A) Use of SELECT ... FOR ALL ENTRIES (B) Use of joins with more than 3 tables (C) Use of SELECT statements in loops (D) Use of SELECT * for tables with many fields.
7. Which of the following are steps in the recommended sequence for a guided performance analysis?
Choose the correct answers. (A) Do static code checks with Code Inspector or ABAP Test Cockpit (B) Collect runtime data with SQL Monitor (C) Collect runtime data with Runtime Analysis (D) Combine runtime data and static check result in SQL Performance Tuning Worklist.
8. Which part of a guided performance analysis is done with the SQL Monitor tool?
Choose the correct answer. (A) Collect runtime data in the productive system (B) Do static SQL checks in the productive system (C) Do static SQL checks in the development system (D) Combine runtime data and static check results.
9. Why are SQL Monitor measurements not immediately visible?.
10. Which of the SQL performance rules become more important with SAP HANA?
Choose the correct answers. (A) Keep the result set small (B) Minimize amount of transferred data (C) Minimize number of database accesses (D) Minimize search overhead (E) Keep unnecessary load away from the DB.
11. Which of the SQL performance rules become less important with SAP HANA?
Choose the correct answers. (A) Keep the result set small (B) Minimize amount of transferred data (C) Minimize number of database accesses (D) Minimize search overhead (E) Keep unnecessary load away from the DB.
|
