C_HANASUP_1 Exam Questions

Which of the following can you determine using the Backup catalog report? (Choose two)

For which purposes can you use the Table locks system report?

How can you set configurations at the system level using the SAP HANA studio?

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

Which of the following are prerequisites for the integration of SAP Solution Manager and SAP HANA? (Choose two)

You have an application that runs on the SAP HANA database. The application loads relatively large volumes of data for hint to the database. Which mergedog configuration parameter...

How do you Configure an end-to-end trace in the SAP HANA studio Administration console?

How can you find default values for SAP HANA configuration settings?

Which of the following allow you to reset the peak used memory? (Choose two)

You have enabled an SQL trace. The resulting trace file is rather large. You have downloaded the trace file to your local computer and want to remove it from this system. Which ste...

When you are monitoring hosts statuses, you find that the status of one of the index server services is IGNORE (gray square). What is the reason for this?

How do you determine the list of open transactions on an SAP HANA database? (Choose two)

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).

How can you avoid filling up the space of the log backup file area?

You want to partition a large table in an SAP HANA database. One of the columns on which you want to base the partition is non-primary key column YEAR. Which partitioning method ca...

Which role must you grant to an SAP HANA user to enable this user for replication tasks only?

You want to configure an SQL trace with trace level set to ALL_WITH_RESULTS. How can you limit the size of the trace file? (Choose two).

You have to set the alert levels for CPU utilization: Low alert-75% Medium alert-85% High alert-95% You have opened the ConfigureCheck threshold tab in the Administration editor of...

How do you display the available disk space (in %) for data from the Volumes tab of the SAP HANA editor?

Which SAP Solution Manager 7.1 capabilities enhance transport management in CTS/CTS+? (Choose three)

You receive an alert: "XYZ TABLE has a record count of 508000408. How can you prevent the alert from being generated again? (Choose two).

On an SAP HANA production system /the log area has grown and the file system is now full. This has resulted in a database freeze. Which parameters must you set to avoid this situat...

You have just finish the baseline installation of an SAP HANA sever. Which activity should you perform next?

You are asked to configure the SAP HANA database to recompile every query prior execution. What do you have to disable to accomplish this?

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

When you deploy the SAP HANA client package on UNIX, which drivers are installed?) 3 answers)

When you configure an SQL trace with trace level ALL, which of the following are recorded to the trace file? (Choose three)

You want to regularly back up the data area of an SAP HANA instance. What must you do to configure a scheduled back up script? (Choose three)

You want to investigate a long-running query. How can you generate a graphical view of the cached SQL plan?

Which of the following tasks can you perform only with system privilege TRACE ADMIN? (Choose two)

Which user do you need to start SAP HANA?

You have assigned the BACKUP ADMIN system privilege to a database user. The user still cannot perform a backup. Which of the following system privilege must you additionally assign...

Which of the following are performance trace options? (Choose three)

How can you find the data and time of invalid logon attempts?

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

What information about a column store table can you fine in the Open Definition report? (Choose two).

You are operating a secondary instance of an SAP HANA database in a high-availability scenario. Where can you check the status of the secondary system replication?

Why do you configure a standby host?

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

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

Which steps are required to identify dominant SQL statements? (Choose two)

What does a data snapshot do?

How can you perform a manual backup of the Sap HANA database? (Choose two)

What does peak used memory represent?

How can you set configurations at the host level using the SAP HANA studio?

In the Administration editor in the SAP HANA studio, which reports can you use to first investigate (1) And then release (2) deadlocks?

Which of the following can you use to schedule a periodic SAP HANA database backup?

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

Which of the following prerequisites must be met before you can specify a valid file destination for a database backup in a multiple-host environment? (Choose two)

For what purpose do you visualize a query plan?