C-HANASUP-1 試験問題を無料オンラインアクセス

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

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

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

How can you improve performance of SAP HANA information models? (Choose two)

• A.Use filters at table level instead of analytic views.
• B.Use the JOIN operator instead of the UNION operator in calculation views.
• C.Use calculated columns in calculation views instead of calculated measures in attribute views.
• D.Use CE_FUNCTIONS instead of SQL statements in calculation views.

Why do you configure a standby host?

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

Your SAP HANA database performs slowly. Which of the following might be reasons for the performance decrease? (Choose two).

• A.Too many information models have been created.
• B.Backup jobs are running.
• C.Many replication jobs are running.
• D.Large tables are updated with frequent delta merges