SAP Certified Support Associate - SAP HANA 1.0 - C-HANASUP-1 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

In the Administration editor in the SAP HANA studio, which reports can you use to first investigate
(1)
And then release (2) deadlocks?

A. The Diagnosis Files tab The Sessions subtab of the Performance tab B. The System information tab The Sessions subtab of the Performance tab C. The System information tab The Threads subtab of the Performance tab D. The Diagnosis Files tab The Job Progress tab

Discussion 0

Correct Answer: A Vote an answer

Question 2

Which of the following prerequisites must be met before you can specify a valid file destination for a database backup in a multiple-host environment? (Choose two)

A. Shared storage is used B. The configuration path for the data backup is valid for all hosts C. The root user has write access to the file destination D. The data backup file system is different from the log backup system

Discussion 0

Correct Answer: A,B Vote an answer

Question 3

An ABAP program in SAP ECC is being optimized for the SAP HANA database. You have been asked to identify expensive SQL statements of this program that run for longer than one second.
What do you have to do to identify these expensive SQL statements? (Choose two)

A. Set the trace level. B. Enable expensive SQL statements tracing. C. Filter expensive SQL statements by DB user. D. Set the threshold duration.

Discussion 0

Correct Answer: A,B Vote an answer

Question 4

Which of the following can you use to delete an index in SAP HANA? (Choose two)

A. 1.
Open the SAP HANA studio
2.Expand the Content tree and select the package
3.Expand the Package tree
4.Select a package and delete it B. 1.
Open the SAP HANA studio
2.Expand the Catalog tree and select the schema
3.Expand the Table tree
4.Select Open Definition and delete the index C. Execute a CE_CONVERSION statement from a stored procedure D. Execute a DROP INDEX SQL statement from the SQL console

Discussion 0

Correct Answer: B,D Vote an answer

Question 5

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. Select the Analysis tab to visualize data in the Data Preview of the long-running query. C. Paste the long-running query into the SQL Console and double-click it. D. Add a filter to display long-running queries in the SQL Plan Cache tab of the Performance Administration view.

Discussion 0

Correct Answer: A Vote an answer

Question 6

How can you perform a manual backup of the Sap HANA database? (Choose two)

A. Select Backup in the SAP HANA studio B. Execute SQL statements in the SQL Console C. Run a backup via the Administration Console in the SAP HANA database D. Run the stored procedure SYS UPDATE_LANDSCAPE_CONFIGURATION

Discussion 0

Correct Answer: A,B Vote an answer

Question 7

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 in the Volume Size (MB) column B. The value in the Total Disk Size (MB) column. C. The value of the Total Disk Size (MB) column minus the value of the Log Volume Size (MB) column. D. The value of the Volume Size (MB) column minus the value of the Used Disk Size (MB) column.

Discussion 0

Correct Answer: B Vote an answer

Question 8

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

A. CONTENT_ADMIN. B. REPLICATION SCHEMA>_SELECT_USER. C. REPLICATION SCHEMA>_DATA_PROV. D. MONITORING.

Discussion 0

Correct Answer: C Vote an answer

Question 9

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

Discussion 0

Correct Answer: A,D Vote an answer