Online Access Free C_HANASUP_1 Practice Test

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

• A.Execute a CERATE INDEX SQL statement from the SQL console.
• 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 create an index
• C.Execute a CE_PROJECTION statement from a stored procedure.
• D.1.
  Open the SAP HANA studio
  2.Expand the Content tree and select the package.
  3.Expand the Package tree.
  4.Select New and then Decision table.

You are supporting an SAP Netweaver BW Powered by HANA system that is in productive operation.
Inadvertently, a table was deleted. The last data backup was three days ago. You need to recover the system to the point before the table deletion.
What do you have to do accomplish this?

• A.Recover the database from the last known backup and reload the deleted table.
• B.Reinstall the SAP HANA database and recover the database from the last known backup.
• C.Restore the SAP HANA database from backup and apply the logs to recover to a point in time.
• D.Drop the table in the SAP HANA database and import the table from another system.

In the Administration Editor of the SAP HANA studio, how can you identify SQL statements with lock contention?

• A.Check the Overall Workload report of the System Information tab.
• B.Check the Record Locks report of the System Information tab.
• C.Filter on the LOCK_WAIT_COUNT column in the Expensive Statements Trace tab of the Performance tab.
• D.Filter on the DURATION_MICROSEC column in the Expensive Statements Trace tab of the Performance tab.

For what purpose do you visualize a query plan?

• A.To investigate which engines are executing an SQL query
• B.To generate a new execution plan on SQL queries
• C.To analyze query results
• D.To update SAP HANA database statistics

Which is the dominant statement (see attached table)?

• A.Statement2
• B.Statement4
• C.Statement1
• D.Statement3