C_HANATEC_14 Online Practice Questions and Answers

Due to a hardware failure, you are using a different host to recover a crashed SAP HANA database. Which

of the following configuration files must you use for the recovery?

There are 2 correct answers to this question.

Response:

A. sapprofile.ini

B. xsengine.ini

C. nameserver.ini

D. Indexserver.ini

What is a role of the SAP HANA Cockpit?

Choose the correct answer.

Response:

A. To provide KPIs to help focus on business performance

B. To provide key system performance information for one of more HANA instances

C. To provide an application developer collaboration hub

You need to analyze resource usage and forecast the requirements for your SAP HANA database. Which

app do you start in SAP HANA cockpit 2.0?

Please choose the correct answer.

Response:

A. Monitor Expensive Statements

B. Troubleshoot Unresponsive System

C. Manage Workload Classes

D. Disk Usage

Where can you check the trace and log files when your SAP HANA database is NOT available?

There are 2 correct answers to this question

Response:

A. In the Trace app of the SAP HANA Web-based Development Workbench

B. In the Troubleshoot Unresponsive System app of SAP HANA cockpit 2.0

C. In the Diagnosis Files app of the SAP HANA cockpit for offline administration

D. In the /usr/sap//HDB//trace path on the operating system

In single-host SAP HANA systems, you can use plain attached storage devices, such as Small Computers

System Interface hard drives, solid-state drives (SSDs), or storage area networks (SANs).

However, to build a multi-host system with failover capabilities, the storage must ensure which of the

following conditions?

There are 2 correct answers to this question. Response:

A. The standby host has file access

B. SYSTEM users replaced by standby host

C. The failed worker host no longer has access to write to files

D. The standby host has access to write to files

What are some of the characteristics of the design-time role?

There are 3 correct answers to this question.

Response:

A. The role is granted through the execution of stored procedures.

B. The role is revoked if the grantee user is deleted.

C. The role is created by technical user _SYS_REPO.

D. The role can be transported between systems.

E. The role is granted and revoked directly by the database user.

You are applying SAP Support Packages during an SUM DMO run to SAP HAN.

Which options are possible to select in the main dialog Tool Configuration? There are 3 correct answers to

this question.

Response:

A. Expert Mode

B. Standard

C. Advanced

D. Single System

What tenant information can you monitor in the Overall Tenant Statuses app of SAP HANA cockpit 2.0?

Please choose the correct answer.

Response:

A. Security status

B. Used memory

C. Isolation status

D. Instance number

Which best practices do you apply when you optimize the table distribution in a scale-out SAP HANA database?

There are 2 correct answers to this question. Response:

A. Cross-node joins must be avoided.

B. Table partitions can be distributed over all nodes.

C. The row store can be distributed over all nodes.

D. The columns of a table can be distributed over all nodes.

Which software components do you download to prepare the database migration option?

There are 2 correct answers to this question.

Response:

A. SPAM/SAINT

B. SAP Host Agent

C. SAPUI5

D. SAP GUI