C_HANASUP_1 Online Practice Questions and Answers

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

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

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

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

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 the SAP HANA studio To which values do you set the alert levels in the Check Host CPU Utilization row?

A. 25,15,5

B. 75, 85, 95

C. 0.25, 0.15, 0.05

D. 0.75, 0.85, 0.95

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

A. Diagnostics in SAP Solution Manager

B. Change analysis and reporting

C. Configuration validation checks

D. SAP NetWeaver Landscape Virtualization Management

E. Quality gate management

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

A. Create user accounts.

B. Back up the SAP HANA server.

C. Patch the SAP HANA server.

D. Create a scheduled backup.

You want to investigate a long-running query.

How can you generate a graphical view of the cached SQL plan?

A. Right-click on the statement and select Visualize Plan in the SQL Plan Cache tab of the Performance Administration view.

B. Add a filter to display long-running queries in the SQL Plan Cache tab of the Performance Administration view.

C. Select the Analysis tab to visualize data in the Data Preview of the long-running query.

D. Paste the long-running query into the SQL Console and double-click it.

You are working with a multimode SAP HANA database.

How can you identify the master indexserver? (Choose two)

A. Select the Landscape tab in the SAP HANA Administration Console Navigate to the Services subtab In the Service column, identify the row with the value "indexserver", and in the Detail column, identify the row with the value "master"

B. Select the Landscape tab in the SAP HANA Administration Console Navigate to the Configuration subtab

In the indexserver Role (Configured), identify the row with the value "MASTER 1"

C. Select the Volumes tab In the Show dropdown list, select Services Identify the master indexserver in the Service column

D. Select the Landscape tab in the SAP HANA Administration Console Navigate to the Configuration subtab In the indexserver Role (Actual) column, identify the row with the value "MASTER"

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

In a scaled-out, high-availability environment for an SAP HANA database, how can you monitor the status of the hosts in the cluster? (Choose three)

A. 1. In the SAP HANA studio, right-click to add a new system.

2.

Create an entry for each of the hosts in this environment.

3.

Log into each of the hosts.

B. 1. In the SAP HANA studio, create an entry for a standby host.

2. Verify that all SAP HANA database processes are running.

C. 1. Log into the Linux operating system of the SAP HANA appliance.

2. Run command ifconfig.

D. 1. In the SAP HANA studio, navigate to the Landscape tab.

2.

Select the Services subtab.

3.

Check the Detail column.

E. 1. Log into the Linux operating system of the SAP HANA appliance.

2.

Launch the SAP HDB Admin console.

3.

Navigate to the Management Console tab.

4.

Verify that all SAP HANA database processes are running.

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. Restore the SAP HANA database from backup and apply the logs to recover to a point in time.

B. Reinstall the SAP HANA database and recover the database from the last known backup.

C. Recover the database from the last known backup and reload the deleted table.

D. Drop the table in the SAP HANA database and import the table from another system.

In an expensive statement trace configuration, you want to identify queries that run longer than two minutes.

Which value do you enter?

A. 12 000

B. 120

C. 120000000

D. 20000