Free SAP E_HANAAW_18 Exam Dumps Questions & Answers

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.

• A.  SQL Monitor was activated for a specific application server.
• B.  SQL Monitor was activated with a filter that excludes database table Y.
• C.  Database table Y is a buffered table.
• D.  Program X was executed in the background.
• E.  The data has NOT yet been transferred to the SQL Monitor database tables.

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?

• A.  carrid and planetype
• B.  _flights.carrid and planetype
• C.  _flights.carrid and_flights.planetype
• D.  carrid and _flights.planetype

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.

• A.  All classical open SQL statements in your program will become invalid.
• B.  All arithmetic expressions can be used for all types of variables.
• C.  All ABAP variables must be escaped with a preceding @ sign.
• D.  All fields in the GROUP BY clause must be separated by commas.

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.

• A.  Database Performance Monitor (transaction: DB50)
• B.  ABAP Test Cockpit (transaction: ATC)
• C.  Code Inspector (transaction: SCI)
• D.  SQL Trace (transaction: ST05)
• E.  SQL Monitor (transaction: SQLM)

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.

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