SAP SAP Certifications C_HANASUP_1 Questions & Answers

• Question 61:

  You have enabled an SQL trace. The resulting trace file is rather large. You have downloaded the trace file to your local computer and want to remove it from this system.

  Which steps must you perform to accomplish this?

  A. 1. Delete the SQL trace file from the Diagnosis Files tab.

  2. Deactive SQL trace in the Trace Configuration tab.

  B. 1. Deactive SQL trace in the Trace Configuration tab,

  2. Delete the SQL trace file from the Diagnosis Files tab.

  C. 1. Open the SQL trace file and delete the contents.

  2. Deactive SQL trace in the Trace Configuration tab.

  D. 1. Deactive SQL trace in the Trace Configuration tab.

  2. Open the SQL trace file and delete the contents.

  Correct Answer: B

• Question 62:

  Which column do you use to identify long-running SQL statements within the SQL Plan Cache view?

  A. TOTAL_EXECUTION_OPEN_TIME

  B. AVG_EXECUTION_OPEN_TIME

  C. TOTAL_EXECUTION _TIME

  D. AVG_EXECUTION_TIME

  Correct Answer: D

• Question 63:

  Which is the dominant statement (see attached table)?

  A. Statement2

  B. Statement3

  C. Statement1

  D. Statement4

  Correct Answer: B

• Question 64:

  Which system privilege do you need to modify the global_allocation_limit parameter?

  A. SERVICE_ADMIN

  B. MONITOR_ADMIN

  C. SESSION_ADMIN

  D. INIFILE_ADMIN

  Correct Answer: D

• Question 65:

  Which of the following are prerequisites for the integration of SAP Solution Manager and SAP HANA? (Choose two)

  A. Register SAP HANA in the System Landscape Directory.

  B. Create a connection to SAP HANA in the managed system configuration.

  C. Configure SAP NetWeaver Landscape Virtualization Management.

  D. Configure SAP Early Watch Alets for SAP HANA.

  Correct Answer: AB

• Question 66:

  In the Administration Editor of the SAP HANA studio, how can you identify SQL statements with lock contention?

  A. Check the Overall Workload report of the System Information tab.

  B. Filter on the DURATION_MICROSEC column in the Expensive Statements Trace tab of the Performance tab.

  C. Check the Record Locks report of the System Information tab.

  D. Filter on the LOCK_WAIT_COUNT column in the Expensive Statements Trace tab of the Performance tab.

  Correct Answer: D

• Question 67:

  You want to enable a new database user to view and delete trace files.

  Which of the following standard roles must you assign to the user?

  A. SUPPORT

  B. CONTENT ADMIN

  C. MONITORING

  D. MODELING

  Correct Answer: A

• Question 68:

  An SAP HANA administrator has asked you to retrieve size information for one table How can you retrieve this information? (Choose two).

  A. 1. Open the Catalog node.

  2.

  Open the Table Definition.

  3.

  Select Runtime Information.

  B. 1. Open the Administration Console.

  2.

  Select Volumes.

  3.

  Select Storage from the dropdown list

  C. 1. Open the Administration Console.

  2.

  Select System Information.

  3.

  Select Size of Tables on Disk.

  D. 1. Open the Catalog node.

  2.

  Open the Table Definition.

  3.

  Select Further Properties.

  Correct Answer: AB

• Question 69:

  Your SAP HANA database performs slowly. Which of the following might be reasons for the performance decrease? (Choose two).

  A. Many replication jobs are running.

  B. Backup jobs are running.

  C. Too many information models have been created.

  D. Large tables are updated with frequent delta merges

  Correct Answer: AD

• Question 70:

  How can you restore a default parameter configuration setting in the SAP HANA studio? (Choose two)

  A. In the context menu of a configuration parameter, choose Configure Table, and the Restore Default.

  B. In the context menu of a configuration parameter, choose Change, and then Restore Default.

  C. In the context menu of a configuration parameter, choose Delete.

  D. Choose Window-Preference-Administration Console and select Restore Defaults.

  Correct Answer: BC