C_HANASUP_1 Online Practice Questions and Answers

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

A. The path for the backup files

B. Whether a recovery is possible

C. Which backup files are obsolete

D. When to execute the net backup

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 role must you grant to an SAP HANA user to enable this user for replication tasks only?

A. REPLICATION SCHEMA>_SELECT_USER.

B. REPLICATION SCHEMA>_DATA_PROV.

C. MONITORING.

D. CONTENT_ADMIN.

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.

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 to the user?

A. CATALOG READ

B. EXPORT

C. REPO EXPORT

D. LOG ADMIN

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

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

On which of the following operating systems is installation of the SAP HANA client supported? Note: There are 3 correct answers

A. Solaris

B. Microsoft Windows

C. z/OS

D. AIX

E. OSX

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.