Online Access Free C-HANASUP-1 Exam Questions

DRAG DROP
Which descriptions on the left match the join types in the dropdown box on the right?

Correct Answer:

Explanation:

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

• A.Execute a CE_CONVERSION statement from a stored procedure
• B.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
• C.Execute a DROP INDEX SQL statement from the SQL console
• D.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

Why do you configure a standby host?

• A.To ensure high performance during replication and reading processes
• B.To add more capacity disk storage
• C.To reduce recovery time from an outage
• D.To share storage between several active data centers

Which of the following can you use to schedule a periodic SAP HANA database backup?

• A.Transaction DBACOCKPIT
• B.hdbsql
• C.SAP HANA studio
• D.Transaction LTR

Which steps are required to identify dominant SQL statements? (Choose two)

• A.Go to the SQL Plan Cache tab on the Performance tab
• B.Sort SQL plan cache by total execution time, from largest to smallest
• C.Sort expensive statements by total execution time; from largest to smallest
• D.Go to the Expensive Statements Trace tab on the Performance tab