What is the correct sequence of the following four steps when you restart the SAP HANA database system?
What is the correct sequence of the following four steps when you restart the SAP HANA database system?
When restarting the SAP HANA database system, the initial step is to load the row tables into memory, as these are essential for transactional processes and need to be quickly accessible. Next, open transactions are recovered to ensure that any changes that were in flight during the shutdown are appropriately managed. Following this, aborted transactions are rolled back to maintain data consistency and integrity by discarding any incomplete or erroneous modifications. Finally, the column tables are loaded, a process that can happen asynchronously, as these are often used for read-heavy analytic operations rather than transactional operations.
B is the correct answer
2.0 SPS06 - Installation and Administration When you restart an SAP HANA system, the following activities are executed by the restart agent of the persistence layer: 1.The data volume of each service is accessed in order to read and load the restart record. 2.The list of open transactions is read into memory. 3.The row tables are loaded into memory. 4.Open transactions are processed using the redo log. 5.Aborted transactions are determined and rolled back. 6.A savepoint is performed with the restored consistent state of the database. 7.Column tables, which are marked for preload, and their attributes are asynchronously loaded in the background, if they have not already been loaded as part of log replay. 8.Column tables that were loaded before restart, and their attributes, start reloading asynchronously in the background, if they have not already been loaded as part of log replay or because they are marked for preload.