SAP Certified Technology Associate – SAP HANA 2.0 (SPS05) — Question 36

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

Answer options

• A. 1. Aborted transactions are rolled back. 2. Open transactions are recovered. 3. Row tables are loaded into memory. 4. Column tables are loaded.
• B. 1. Row tables are loaded into memory. 2. Open transactions are recovered. 3. Aborted transactions are rolled back. 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.

Correct answer: B

Explanation

The correct order begins with loading row tables into memory, followed by recovering open transactions, rolling back any aborted transactions, and finally loading column tables. Options A, C, and D do not follow this sequence, resulting in an incorrect process for restarting the SAP HANA database system.