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

Q24. You analyze SQL Monitor data in transaction SQLMD. You know that program X accesses database table Y. You made sure that program X was executed while the SQL Monitor collected its dat a. But the relevant database access is NOT listed in SQLMD. What could be the reason? Note: There are 3 correct answers to this question.

Q25. In SAP HANA SQL, you want to create a table whose definition should NOT be visible in the catalog. Which of the following table types fulfill this requirement?

Q26. You have created a CDS view and used alias names for some of its elements. In which of the following cases is the alias name mandatory? Note: There are 3 correct answers to this question.

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

Q28. What must you take into consideration when you use the new Open SQL syntax (available as of SAP NetWeaver 7.4 SP05)? Note: There are 2 correct answers to this question.

Q29. Which of the following repository objects can you edit only in ABAP Development Tools in Eclipse, and NOT in the classical ABAP Workbench? Note: There are 3 correct answers to this question.

Q30. Which tools can you use to provide input data for the SQL Performance Tuning Worklist (transaction SWLT)? Note: There are 3 correct answers to this question.

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

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

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

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

Q35. You created and activated a database procedure. From where can you call this procedure? Note: There are 2 correct answers to this question.

Q36. You have created a CDS view as follows: define view zha400 as
select from spfli association^] to sflight as_flights on
spfli.carrid = _flights.carrid and spfli.connid = _flights.connid { … } Given that table sflight also contains the field planetype, how must you address the fields carrid and planetype from table SFLIGHT?

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

Q38. You are debugging in ABAP Development Tools in Eclipse.
What features are available? Note: There are 2 correct answers to
this question.