C_HANASUP_1 Online Practice Questions and Answers

Which parameters can you configure for an expensive statement trace? (Choose two)

A. Passport trace level

B. Threshold duration

C. Trace status

D. Trace file

An SAP HANA developer receives an error when running an SAP HANA Predictive Analysis Library procedure.

In which of the following files can you find more information?

A. Script server log

B. Index server log

C. Name server log

D. Statistics server log

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

What do you have to consider when you want to unpartition an SAP HANA table? (Choose three)

Unpartitioning blocks concurrent read access to the table during the process.

A. An exclusive lock on the table is required.

B. Unpartitioning can table a long time to complete.

C. Only read access is allowed during the unpartitioning process.

D. Only tables of more than 2 billion rows can be unpartitioned.

You want to enable a new database user to view and delete trace files.

Which of the following standard roles must you assign to the user?

A. SUPPORT

B. CONTENT ADMIN

C. MONITORING

D. MODELING

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

A. Administration editor -> System Information -> Component memory usage.

B. ALTER SYSTEM RESET MONITOERING VIEW SYS.M HEAP_MEMORY_RESET.

C. ALTER SYSTEM RESET MONITOERING VIEW SYS.M_DATA_VOLUMES.

D. Administration editor -> Landscape -> Services -> Reset Memory Statistics from the context menu.

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?

A. The index server service has been stopped.

B. The host's actual role is different from its configured role.

C. The host of the service is configured as a worker host.

D. The host of the service is configured as a standby host.

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

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.

An ABAP program in SAP ECC is being optimized for the SAP HANA database. You have been asked to identify expensive SQL statements of this program that run for longer than one second.

What do you have to do to identify these expensive SQL statements? (Choose two)

A. Filter expensive SQL statements by DB user.

B. Enable expensive SQL statements tracing.

C. Set the trace level.

D. Set the threshold duration.