Question 1

What is the correct sequence of the following four steps when you restart the SAP HANA database system?Please choose the correct answer.

Options :

A : 1. Row tables are loaded into memory.2. Open transactions are recovered.3. Aborted transactions are rolled back.4. Column tables are loaded.

B : 1. Aborted transactions are rolled back.2. Open transactions are recovered.3. Row tables are loaded into memory.4. Column tables are loaded.

C : 1. Row tables are loaded into memory.2. Column tables are loaded.3. Open transactions are recovered.4. Aborted transactions are rolled back.

D : 1. Aborted transactions are rolled back.2. Row tables are loaded into memory.3. Open transactions are recovered.4. Column tables are loaded.

Answer: A

Question 2

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.

Options :

A : SYSTEM users replaced by standby host

B : The failed worker host no longer has access to write to files

C : The standby host has file access

D : The standby host has access to write to files

Answer: B,C

Question 3

What is a characteristic of the synchronous in-memory system replication mode in SAP HANA?

Options :

A : The primary system waits until the secondary system confirms receiving the log

B : The primary system waits until the secondary system confirms the log was persisted

C : The primary system does NOT wait for confirmation of the secondary system

D : The primary system suspends transactions processing until the connection to the secondary system is established

Answer: A

Question 4

Which diagnostic file can you use to monitor the status of database recovery?

Options :

A : backint.log

B : backup.log

C : sapstartsrv.log

D : available.log

Answer: B

Question 5

Which SAP HANA database system usage types are automatically assigned to tiles in the SAP HANA cockpit? There are 3 correct answers to this question.

Options :

A : Production

B : Custom

C : Test

D : Sandbox

E : Development

Answer: A,C

Higher Test Marks with Free Online C_HANATEC_19 Exam Practice

Buying Options: