C-HANASUP-1 무료 덤프문제 온라인 액세스

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

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

Which of the following can you determine using the Backup catalog report? (Choose two)

• A.The path for the backup files
• B.Whether a recovery is possible
• C.When to execute the net backup
• D.Which backup files are obsolete

You have to set the alert levels for CPU utilization:
Low alert-75%
Medium alert-85%
High alert-95%
You have opened the ConfigureCheck threshold tab in the Administration editor of the SAP HANA studio To which values do you set the alert levels in the Check Host CPU Utilization row?

• A.0.25, 0.15, 0.05
• B.25,15,5
• C.75, 85, 95
• D.0.75, 0.85, 0.95

You want to configure an SQL trace with trace level set to ALL_WITH_RESULTS.
How can you limit the size of the trace file? (Choose two).

• A.Delete the trace file if it grows too large.
• B.Specify the database user to trace.
• C.Increase the flush limit.
• D.Specify the tables and views to trace.

You want to investigate a long-running query. How can you generate a graphical view of the cached SQL plan?

• A.Add a filter to display long-running queries 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.Right-click on the statement and select Visualize Plan in the SQL Plan Cache tab of the Performance Administration view.
• D.Paste the long-running query into the SQL Console and double-click it.