What do you have to consider when you want to unpartition an SAP HANA table? (Choose three)

Unpartitioning blocks concurrent read access to the table during the process.

A. An exclusive lock on the table is required.

B. Unpartitioning can table a long time to complete.

C. Only read access is allowed during the unpartitioning process.

D. Only tables of more than 2 billion rows can be unpartitioned.

Which system privilege do you need to modify the global_allocation_limit parameter?

A. SERVICE_ADMIN

B. MONITOR_ADMIN

C. SESSION_ADMIN

D. INIFILE_ADMIN

Your customer is designing a role exclusively for performing database backups of the SAP HANA database.

Which system privileges must be assigned to this role? (Choose two).

A. INIFILE ADMIN

B. CATALOG READ

C. BACKUP ADMIN

D. EXPORT

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 Content tree and select the package

3.

Expand the Package tree

4.

Select a package and delete it

B. Execute a CE_CONVERSION statement from a stored procedure

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

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

A. Review the SQL Plan Cache subtab in the Performance tab of the SAP HANA studio Administration editor

B. Create an SQL query on the view SYS.M_SQL_PLAN_CACHE

C. Review the Sessions subtab in the Performance tab of the SAP HANA studio Administration editor

D. Create an SQL query on the view SYS.M_CONNECTION_STATISTICS