C_HANASUP_1 Online Practice Questions and Answers

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

Which part of an expensive statement trace would you investigate to identify possible performance improvements?

A. Statement string

B. Statement length

C. TOTAL_LOCK_WAIT_TIME

D. ALLOC_MEM_SIZE_COLSTORE

Which column do you use to identify long-running SQL statements within the SQL Plan Cache view?

A. TOTAL_EXECUTION_OPEN_TIME

B. AVG_EXECUTION_OPEN_TIME

C. TOTAL_EXECUTION _TIME

D. AVG_EXECUTION_TIME

Which is the dominant statement (see attached table)?

A. Statement2

B. Statement3

C. Statement1

D. Statement4

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

A. Enable automatic log backup.

B. Increase the value of the log_segment_size_mb parameter.

C. Change the log_backup_timeout_s to a small value.

D. Disable automatic log backup.

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

A. Adjust the script command line parameters to restrict backup to data only.

B. Copy the scheduled backup script to the appropriate operating system level directory.

C. Import the scheduled backup script using the SAP HANA studio.

D. Adjust parameters within the scheduled backup script.

E. Configure scheduled backup script in a stored procedure in the SAP HANA studio.

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

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

A. hdbsql

B. SAP HANA studio

C. Transaction DBACOCKPIT

D. Transaction LTR

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)

A. Shared storage is used

B. The data backup file system is different from the log backup system

C. The configuration path for the data backup is valid for all hosts

D. The root user has write access to the file destination

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"

Your SAP HANA project has gone live. The client requires to build a new sandbox environment, using a copy of the production data, for prototyping and technical upgrades

What is the SAP recommended approach to meet the requirement?

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

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

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

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

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

A. To move updated records from delta storage to column store

B. To move new records from SAP ECC tables to delta storage

C. To move merge data from row tables to column store

D. To move inserted records from delta storage to column store

E. To move deleted records from delta storage to column store