A company experiences an unexpected critical data center outage. A team has been assembled to perform data restoration. The data center utilizes both local and off-site backups. Which method should be used to ensure the most effective restoration of a critical database that keeps historical customer transactions?
Restore from the last full backup made at the beginning of the financial quarter for minimum data loss.
Use the most recent off-site backup and apply transaction logs to restore to the most recent point before the outage.
Implement a new database system and manually input data based on the past month's financial records.
Restore from the most recent local backup, disregarding transaction logs to expedite the restoration process.
The best method to restore the critical database is to use the off-site backups, specifically the most recent snapshot that includes the transaction logs. The off-site backups ensure that the data is not affected by the same incident that caused the data center outage. Transaction logs are important as they contain all recent transactions that have occurred since the last full backup, providing a means to restore the database up to the point of failure. Restoring from the local backup might not be possible if it was affected by the same data center outage, and implementing a new database system would be a lengthy process and would not recover the historical transaction data.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What are transaction logs and why are they important for data restoration?
Open an interactive chat with Bash
What are the differences between local and off-site backups?
Open an interactive chat with Bash
What steps should be taken when restoring a database after a significant outage?