C-HANASUP-1 by SAP Valid Free Exam Practice Test

Question 1

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. Unpartitioning can table a long time to complete. B. An exclusive lock on the table is required. C. Only tables of more than 2 billion rows can be unpartitioned. D. Only read access is allowed during the unpartitioning process.

Correct Answer: B,C,D

Question 2

In the Volumes tab of the SAP HANA studio Administration Console, which of the following provides you with the total disk space (in MB)?

A. The value of the Volume Size (MB) column minus the value of the Used Disk Size (MB) column. B. The value in the Volume Size (MB) column C. The value in the Total Disk Size (MB) column. D. The value of the Total Disk Size (MB) column minus the value of the Log Volume Size (MB) column.

Correct Answer: C

Question 3

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 Services subtab In the Service column, identify the rows with the value "indexserver", and in the Active column, identify the rows with 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 Active column, identify the rows with the value "YES" D. 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"

Correct Answer: D

Question 4

In the SAP HANA studio, which of the following SQL thread details can you monitor by using the Threads subtab of the Performance tab of the Administration editor? (Choose three)

A. The blocking status B. The service name C. The SQL statement D. The generated data E. The visual execution plan

Correct Answer: A,B,D

Question 5

What are the purposes of executing a delta merge operation in an SAP HANA database? (Choose three)

A. To move merge data from row tables to column store B. To move new records from SAP ECC tables to delta storage C. To move deleted records from delta storage to column store D. To move inserted records from delta storage to column store E. To move updated records from delta storage to column store

Correct Answer: C,D,E

Question 6

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

A. SERVICE_ADMIN B. SESSION_ADMIN C. MONITOR_ADMIN D. INIFILE_ADMIN

Correct Answer: D

Question 7

For what purpose do you visualize a query plan?

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

Correct Answer: C

Question 8

In SAP HANA, the automatic backup is disabled. The log area has grown and now the file system is full. The database has frozen. After you stop the database , what do you have to do to restart SAP HANA?

A. 1.
Initialize the log area from the file system folder.
2.Restart the server.
3.Execute the log backup into the SAP HANA studio.
4.Refresh the global.ini file. B. 1.
Restart the server.
2.Copy the log into a new folder.
3.Execute the log backup into the SAP HANA studio.
4.Update the global.ini file with the new folder path. C. 1.
Restart the server
2.Execute the log backup in the SAP HANA studio.
3.Copy the log into a new folder.
4.Update the global.ini file with the new folder path. D. 1.
Copy the log into a new folder.
2.Update the global.ini file with the new folder path.
3.Restart the server and execute the log backup in the SAP HANA studio.
4.Copy the log to the initial folder and restore the global.ini file.

Correct Answer: D

Question 9

Which of the following are minimum requirements for the installation of an SAP HANA server? (Choose two)

A. <WORKING_DIRECTORY>has 200MB or more of free disk space B. <WORKING_DIRECTORY>is empty before the start of the installation C. <WORKING_DIRECTORY>has 100MB or more of free disk space D. <WORKING_DIRECTORY> contains sapprofile.ini

Correct Answer: A,B

SAP Certified Support Associate - SAP HANA 1.0 - C-HANASUP-1 Exam Practice Test