Free SAP C-HANATEC141 Exam Dumps Questions & Answers

A long-running SQL query issued by an SAP NetWeaver work process also seems to use a lot of system resources.
How can you find out which ABAP module and which SAP NetWeaver user called the query?

• A.  Go to the Performance tab of SAP HANA studio
  Check the System load diagram
• B.  In SAP HANA studio, check the session overview
  Identify the logical CONNECTION ID for the SAP NetWeaver work process
  Check the columns APPLICATIONSOURCE and APPLICATIONUSER
• C.  Open Transaction Process Overview (SM50) in the SAP NetWeaver system
  Sort the list by CPU time
  Select the top entry
  Check the User and Report columns
• D.  Open Transaction Global Work Process Overview (SM66) in the SAP NetWeaver system
  Sort the list by CPU time
  Select the top entry

Which of the following is a result of using SAP HANA as an application platform?

• A.  All database queries have a sub-second response time.
• B.  The need for indexes is eliminated.
• C.  Aggregates in data models are only materialized when required.
• D.  Calculation-intensive logic is pushed down to the database.

When is the administration editor in SAP HANA studio opened automatically in diagnosis mode? (Choose two)

• A.  When the system is restarting
• B.  When the sapstartsrv service is not running
• C.  When the index server service is restarted
• D.  When an SQL connection is not available

You are using the Change and Transport System (CTS) with SAP HANA.
When is the transport strategy determined?

• A.  When the objects are attached to a transport request in the SAP HANA studio
• B.  When the export system is configured in CTS
• C.  When the SAP HANA application type is configured in CTS
• D.  When the connection to CTS is configured in SAP HANA studio

Diagram:

Which component in the attached diagram is used when you query an SAP HANA information model to populate a pivot table in Microsoft Excel?

• A.  The Transaction Manager
• B.  The Calculation Engine
• C.  The Log Volumes
• D.  The SQL Interface