C_HANASUP_1 Online Practice Questions and Answers

Which of the following are held in SAP HANA used memory? (Choose two)

A. Free memory pool

B. Temporary computations

C. Heap memory

D. Column and row tables

Which of the following events can trigger a delta merge? (Choose two)

A. Memory consumption of delta storage drops below a specified limit.

B. The delta log for a columnar table drops below a defined limit.

C. The delta log for a columnar table exceeds a defined limit.

D. Memory consumption of delta storage exceeds a specified limit.

You granted a user the system privileges INIFILE ADMIN and DATA ADMIN.

What does this allow the user to do?

A. Modify the nameserver_history.trc files.

B. Reset the backup.log file.

C. Modify configuration files.

D. Reset the log.txt file

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 situation in the future? (Choose two)

A. enable_auto_log_backup = no

B. enable_auto_log_backup = yes

C. log_mode = overwrite

D. log_mode = normal

You are asked to configure the SAP HANA database to recompile every query prior execution.

What do you have to disable to accomplish this?

A. The SQL trace

B. The SQL result cache

C. The expensive statements trace

D. The SQL plan cache

What does a data snapshot do?

A. It creates a backup of the database

B. It generates a frozen point-in-time set of data

C. It writes data from memory to the persistence layer

D. It clones the database to an exportable file

What does peak used memory represent?

A. The point when an automatic delta merge will be triggered

B. The point when SAP HANA switches to virtual memory

C. The maximum used memory authorized by the SAP HANA license

D. The maximum values of used memory over time

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

A. Update settings in the_SYS_REPO.CHANGES table

B. Enter values in the Host column in the Configuration tab in the Administration editor

C. Update settings in the _SYS_REPO.CHANGE_ENTRIES table

D. Right-click on a row in the Host column of the Configuration tab in the Administration editor. Select Configure Table and change settings

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

A. The Diagnosis Files tab The Job Progress tab

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

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

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

You have selected SAP HANA as product in SAP Solution Manager and checked the prerequisites.

What are the next steps to configure SAP HANA as a managed system in SAP Solution Manager?

A. 1. Assign diagnosis agents.

2.

Create logical components.

3.

Enter system parameters

4.

Enter landscape parameters.

5.

Check configuration.

B. 1. Check configuration.

2.

Create logical components.

3.

Assign diagnosis agents.

4.

Enter system parameters.

5.

Enter landscape parameters.

C. 1. Assign diagnosis agents.

2.

Enter system parameters.

3.

Enter landscape parameters.

4.

Create logical components.

5.

Check configuration.

D. 1. Assign diagnosis agents.

2.

Check configuration.

3.

Create logical components.

4.

Enter system parameters.

5.

Enter landscape parameters.