SAP SAP Certifications C_HANASUP_1 Questions & Answers

• Question 31:

  Which of the following are performance trace options? (Choose three)

  A. Trace execution plans

  B. Optimizer performance

  C. Activate function profiler

  D. Performance trace duration

  E. Start kernel profiler tracing

  Correct Answer: ACD

• Question 32:

  How can you find the data and time of invalid logon attempts?

  A. Query SYS.M_EVENTS.

  B. Query SYS.M _CONNECTION_STATISTICS.

  C. In the Administration editor, select the System information tab and look at the Connection attempts and status report.

  D. In the Administration editor, select the System information tab and look at the Connections report.

  Correct Answer: B

• Question 33:

  In the Volumes tab of the SAP HANA studio Administration Console, which of the following provides you with the total disk space (in MB)?

  A. The value of the Volume Size (MB) column minus the value of the Used Disk Size (MB) column.

  B. The value in the Total Disk Size (MB) column.

  C. The value in the Volume Size (MB) column

  D. The value of the Total Disk Size (MB) column minus the value of the Log Volume Size (MB) column.

  Correct Answer: B

• Question 34:

  Which of the following tasks can you perform only with system privilege TRACE ADMIN? (Choose two)

  A. Delete trace files

  B. Start a Python

  C. Start SQL traces

  D. Delete SYS.P_SQLSCRIPTTRACE_.

  Correct Answer: AC

• Question 35:

  Which user do you need to start SAP HANA?

  A. Any user with the SESSION ADMIN system privilege.

  B. Linux user root

  C. Linux user adm user

  D. Any user with the SERVICE ADMIN system privilege

  Correct Answer: C

• Question 36:

  You have assigned the BACKUP ADMIN system privilege to a database user. The user still cannot perform a backup.

  Which of the following system privilege must you additionally assign to the user?

  A. CATALOG READ

  B. EXPORT

  C. REPO EXPORT

  D. LOG ADMIN

  Correct Answer: A

• Question 37:

  You want to investigate a long-running query.

  How can you generate a graphical view of the cached SQL plan?

  A. Right-click on the statement and select Visualize Plan in the SQL Plan Cache tab of the Performance Administration view.

  B. Add a filter to display long-running queries in the SQL Plan Cache tab of the Performance Administration view.

  C. Select the Analysis tab to visualize data in the Data Preview of the long-running query.

  D. Paste the long-running query into the SQL Console and double-click it.

  Correct Answer: A

• Question 38:

  You want to regularly back up the data area of an SAP HANA instance.

  What must you do to configure a scheduled back up script? (Choose three)

  A. Adjust the script command line parameters to restrict backup to data only.

  B. Copy the scheduled backup script to the appropriate operating system level directory.

  C. Import the scheduled backup script using the SAP HANA studio.

  D. Adjust parameters within the scheduled backup script.

  E. Configure scheduled backup script in a stored procedure in the SAP HANA studio.

  Correct Answer: CDE

• Question 39:

  When you deploy the SAP HANA client package on UNIX, which drivers are installed?) 3 answers)

  A. ODBC

  B. JDBC

  C. ODBO

  D. SQLDBC

  E. ADO

  Correct Answer: ABD

• Question 40:

  When you configure an SQL trace with trace level ALL, which of the following are recorded to the trace file? (Choose three)

  A. Unique constraint violations

  B. Data returned by queries

  C. Unique indexes used

  D. Overall execution time of each statement

  E. Number of records affected

  Correct Answer: ADE