Online Access Free E_HANAAW_12 Practice Test

Which of the following tool is introduced as a holistic quality assurance tool?
Choose the correct answer

• A.BW system
• B.ABAP Test Cockpit (ATC)
• C.DBMS Cockpit
• D.DBA Cockpit

What are the two types of editors available in ADT?
There are 2 correct answers to this question.

• A.SAP (GUI)
• B.Eclipse (native)
• C.ABAP (native)
• D.Client (native)

You create a check variant in the Code Inspector which includes the check 'Search problematic Select * statements'.
SAP HANA is used as the database. In the check parameters, which value would you use for the percentage of fields that are effectively used?
Please choose the correct answer.

• A.The same value as on a traditional, row-store only based database
• B.A lower value than on a traditional, row-store only based database
• C.A higher value than on a traditional, row-store only based database
• D.A value that you calculate based on the number of tables

When using ABAP Database Connectivity (ADBC) to issue native SQL calls to the database, which of the following methods of class CL_SQL_RESULT_SET retrieves the tabular result of the native SQL call?
Please choose the correct answer.

• A.NEXT_PACKAGE
• B.SET_PARAM
• C.SET_PARAM_TABLE
• D.GET_METADATA

What are the benefits of using the SQL Monitor (transaction SQLM)?
There are 2 correct answers to this question.

• A.It schedules ABAP programs to monitor and log all database accesses.
• B.It collects monitoring data asynchronously without additional database interaction.
• C.It displays the database execution plan for all SQL statements.
• D.It can be active in a production system with minimal performance overhead.