Free SAP E-HANAAW-18 Exam 2023 Practice Materials Collection [Q15-Q36]

Q15. User STUDENT_A creates and activates a design-time object. In which schema is the runtime object generated?

Q16. You developed an ABAP Managed Database Procedure (AMDP). You want to allow the enhancement of this AMDP using a Business Add-In (BAdI). Which of the following objects must you create? Note: There are 3 correct answers to this question.

Q17. Which step of the Guided Performance Analysis should you perform in the production system?

Q18. Which of the following tools and programming techniques use the SQL Data Definition Language? Note: There are 2 correct answers to this question.

Q19. How many result sets are returned when an SAP HANA database procedure is called using the CALL…WITH OVERVIEW statement?

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

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

Q22. In a graphical calculation view, you want to implement a union between two result sets that differ only in the fact that one of the two has one additional field named ADDRESS. How can you achieve this in a union node? Note: There are 2 correct answers to this question.

Q23. Which of the following takes advantage of the computing power of multiple CPUs used by SAP HANA?

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

Q25. 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.

Q26. 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?

Q27. Your development team needs to include SAP HANA objects into an ABAP workbench request. You want to use SAP HANA Transport for ABAP (HTA), and NOT the SAP HANA Transport Container (HTC). Why would you choose HTA? Note: There are 2 correct answers to this question.

Q28. What are some of the features available for SAP List Viewer with Integrated Data Access (ALV IDA)? Note: There are 3 correct answers to this question.

Q29. 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.

Q30. You define and implement an ABAP Managed Database Procedure (AMDP). What do you have to list after the USING clause? Note: There are 3 correct answers to this question.