SAP Certified Support Associate - SAP HANA 1.0 - C_HANASUP_1 Exam Practice Test

A. The SQL plan cache

B. The expensive statements trace

C. The SQL result cache

D. The SQL trace

A. Unpartitioning can table a long time to complete.

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

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

D. An exclusive lock on the table is required.

A. Statement3

B. Statement1

C. Statement2

D. Statement4

A. Disable automatic log backup.

B. Enable automatic log backup.

C. Change the log_backup_timeout_s to a small value.

D. Increase the value of the log_segment_size_mb parameter.

A. Make a copy of the file system of the production appliance with 'tar' Create a clone in the sandbx appliance from this tar file.

B. Install a new SAP HANA instance on you own Deploy SAP HANA packages to this new sandbox instance

C. Install a new SAP HANA instance on your own Restore the production database from a data backup

D. Install a new SAP HANA instance with help from the hardware vendor Restore the production database from a data backup

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"

A. 1.
Locate the Details for Data Storage section
2.Navigate to the Data Volume Superblock Statistics subtab
3.In the Used Superbolcks column, identify the row with the largest value
4.Subtract the Used/Total Superblocks (%) value from 100

B. 1.
Locate the Details for Data Storage section
2.Navigate to the File subtab
3.In the Type column, identify the row with the value "DATA"
4.Subtract the Used/Total Size (%) value from 100

C. 1.
In the Show dropdown list; select Storage
2.In the Type column/identify the row with the value "DATA"
3.Retrieve the Available Disk Size (%) value.

D. 1.
In the Show dropdown list, select Service
2.Select the row with the master index server
3.Retrieve the Available Disk Size (%) value.

A. The Diagnosis Files tab The Job Progress tab

B. The System information tab The Sessions subtab of the Performance tab

C. The System information tab The Threads subtab of the Performance tab

D. The Diagnosis Files tab The Sessions subtab of the Performance tab

A. In the Host Status column of the Configuration subtab of the Landscape tab in the Administration editor

B. In the REPLICATION_STATUS colum of the view M_SERVICE_REPLICATION

C. In the STATUS column of the view M_SYSTEM_OVERVIEW

D. In the Host column of the Services subtab of the Landscape tab in the Administration editor