Free SAP Certified Development Specialist – ABAP for SAP HANA 2.0 Exam E_HANAAW_18 Exam Practice Test

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.

• Because you use the technique that is recommended by SAP.
• Because you automatically add changed objects to the transport request.
• Because you can manually re-deploy objects after a failed import.
• Because you always transport entire SAP HANA content packages.

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.

• "ha400.primdb/CA_BOOKINGS_COUNT"
• "ha400.primdb: :CA_BOOKINGS_COUNT"
• _SYS_BIC."ha400.primdb/CA_BOOKINGS_COUNT"
• _SYS_BIC."ha400.primdb::CA_BOOKINGS_COUNT"

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

• Debugger scripting
• Watch points
• Conditional breakpoints
• Memory usage analysis

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.

• CASE ordertype WHEN 'A' THEN 1 ELSE 0 END AS order_type
• CAST( 'USD' AS abap.cuky ) AS currency_key
• crtdby AS created_by
• SUM( revenue ) AS total_revenue
• ASSOCIATION TO sflight AS .flights

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

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

Which task does the ABAP Managed Database Procedure (AMDP) framework perform?

• Deploy a new version of the database procedure when the AMDP is first called.
• Deploy the database procedure whenever the AMDP is called.
• Deploy the database procedure when the AMDP is first activated.
• Deploy the database procedure whenever the AMDP is activated.

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.

• ABAP Test Cockpit (transaction: ATC)
• SQL Trace (transaction: ST05)
• Database Performance Monitor (transaction: DB50)
• SQL Monitor (transaction: SQLM)
• Code Inspector (transaction: SCI)

You want to move some of the logic of an ABAP program into an ABAP-managed database procedure (AMDP). To do so, you need to translate Open SQL statements into SAP HANA Native SQL. Which of the following are necessary adjustments? Note: There are 3 correct answers to this question.

• Replace UP TO n ROWS additions.
• Replace ORDER BY additions.
• Specify the schema for every table.
• Replace CORRESPONDING FIELDS additions.
• Add explicit client handling.

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

• Direct access to Table Pools/Cluster
• Missing ORDER BY or SORT after SELECT
• Use of Native SQL and DB Hints
• Existence check for Secondary Indexes

What is the purpose of an ABAP project in ABAP Development Tools for Eclipse? Note: There are 2 correct answers to this question.

• It represents the connection to an ABAP system.
• It represents the connection to the SAP HANA server.
• It is used to transport ABAP repository objects.
• It provides access to all ABAP repository objects in an ABAP system.