Online Access Free C-HANASUP-1 Exam Questions

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 Catalog tree and select the schema
  3.Expand the Table tree
  4.Select Open Definition and delete the index
• B.Execute a DROP INDEX SQL statement from the SQL console
• C.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
• D.Execute a CE_CONVERSION statement from a stored procedure

You are working with a multimode SAP HANA database. How can you verify that the indexserver hosts are online?

• A.Select the Landscape tab of the SAP HANA Administration Console
  Navigate to the Configuration subtab.
  In the Active column, identify the rows with the value "YES"
• B.Select the Landscape tab of the SAP HANA Administration Console In the Show dropdown list, select Service In the Service column/identify the rows with the value" indexserver"
• C.Select the Landscape tab of the SAP HANA Administration Console
  Navigate to the Configuration subtab.
  In the Host Status column, identify the rows with the value "OK"
• D.Select the Landscape tab of the SAP HANA Administration Console Navigate to the Services subtab In the Service column, identify the rows with the value "indexserver", and in the Active column, identify the rows with

Which part of an expensive statement trace would you investigate to identify possible performance improvements?

• A.Statement length
• B.Statement string
• C.ALLOC_MEM_SIZE_COLSTORE
• D.TOTAL_LOCK_WAIT_TIME

How can you identify often-used SQL statements? Note: 2 correct answers

• A.Review the Sessions subtab in the Performance tab of the SAP HANA studio Administration editor
• B.Review the SQL Plan Cache subtab in the Performance tab of the SAP HANA studio Administration editor
• C.Create an SQL query on the view SYS.M_SQL_PLAN_CACHE
• D.Create an SQL query on the view SYS.M_CONNECTION_STATISTICS

An SAP HANA developer receives an error when running an SAP HANA Predictive Analysis Library procedure. In which of the following files can you find more information?

• A.Statistics server log
• B.Script server log
• C.Index server log
• D.Name server log