SAP SAP Certifications C_HANASUP_1 Questions & Answers

• Question 51:

  Which role must you grant to an SAP HANA user to enable this user for replication tasks only?

  A. REPLICATION SCHEMA>_SELECT_USER.

  B. REPLICATION SCHEMA>_DATA_PROV.

  C. MONITORING.

  D. CONTENT_ADMIN.

  Correct Answer: B

• Question 52:

  Which trace do you have to configure to identify only long-running queries in the SAP HANA database?

  A. Expensive statements trace.

  B. SQL trace.

  C. Database trace.

  D. Performance trace.

  Correct Answer: A

• Question 53:

  How do you determine the list of open transactions on an SAP HANA database? (Choose two)

  A. In the SAP HANA studio, double-click on Open Transactions in the System Information tab of the Administration editor.

  B. Run an SQL query against the view SYS.M JTRSACTIONS.

  C. In the SAP HANA studio, double-click on Transactions double-click on Open Transactions.

  D. Run an SQL query against the view SYS.TRSACTIONS_HISTORY.

  Correct Answer: AD

• Question 54:

  Your customer is designing a role exclusively for performing database backups of the SAP HANA database.

  Which system privileges must be assigned to this role? (Choose two).

  A. INIFILE ADMIN

  B. CATALOG READ

  C. BACKUP ADMIN

  D. EXPORT

  Correct Answer: BC

• Question 55:

  How can you avoid filling up the space of the log backup file area?

  A. Enable automatic log backup.

  B. Increase the value of the log_segment_size_mb parameter.

  C. Change the log_backup_timeout_s to a small value.

  D. Disable automatic log backup.

  Correct Answer: A

• Question 56:

  When you are monitoring hosts statuses, you find that the status of one of the index server services is IGNORE (gray square).

  What is the reason for this?

  A. The index server service has been stopped.

  B. The host's actual role is different from its configured role.

  C. The host of the service is configured as a worker host.

  D. The host of the service is configured as a standby host.

  Correct Answer: D

• Question 57:

  You have an application that runs on the SAP HANA database. The application loads relatively large volumes of data for hint to the database.

  Which mergedog configuration parameter in the indexserver.ini file must you set to accomplish this?

  A. smart_merge_enabled.

  B. max_delta_memsize.

  C. auto_ merge_decision_func.

  D. mermory_merge_ decision_func.

  Correct Answer: A

• Question 58:

  How do you Configure an end-to-end trace in the SAP HANA studio Administration console?

  A. 1. Select the Trace Configuration tab.

  2. Edit the configuration for user-specific trace.

  B. 1. Select the Configuration tab.

  2. Edit the scriptserver.ini trace parameter.

  C. 1. Select the Trace Configuration tab.

  2. Edit the sap_passport configuration.

  D. 1. Select the Trace Configuration tab.

  2. Edit the global database trace configuration.

  Correct Answer: C

• Question 59:

  How can you find default values for SAP HANA configuration settings?

  A. Double-click the Database Information row in the System information tab in the Administration editor.

  B. Go to the Configuration tab in the Administration editor and inspect the Default column.

  C. Go to the Configuration tab in the Administration editor and inspect the System column.

  D. Right-click on a configuration setting in the Configuration tab in the Administration editor.

  Correct Answer: B

• Question 60:

  Which of the following allow you to reset the peak used memory? (Choose two)

  A. Administration editor -> System Information -> Component memory usage.

  B. ALTER SYSTEM RESET MONITOERING VIEW SYS.M HEAP_MEMORY_RESET.

  C. ALTER SYSTEM RESET MONITOERING VIEW SYS.M_DATA_VOLUMES.

  D. Administration editor -> Landscape -> Services -> Reset Memory Statistics from the context menu.

  Correct Answer: BD