SOA-C02 Question 107
Single answerAn organization is running a MySQL database on Amazon RDS. A critical table was accidentally deleted from the primary database instance at 12:30 PM. The database is configured with automated backups and a read replica. The organization needs to recover the data to a point just before the deletion occurred. Which of the following steps should be taken to achieve this?
- A
Use the read replica to promote it to a standalone database and continue operations.
- B
Perform a point-in-time restore to a new database instance using the automated backups and set the restore time to just before 12:30 PM.
- C
Take a manual snapshot of the primary database and restore it to a new database instance.
- D
Enable Multi-AZ on the primary database and failover to the secondary instance to recover the data.
Show answer and explanation
Correct answer: B
Explanation
To recover from the accidental deletion of a table, a point-in-time restore is the appropriate solution. This feature leverages automated backups to restore the database to a specific time before the deletion occurred. Other options, such as promoting a read replica or enabling Multi-AZ failover, do not address the need to recover data from before the accidental deletion.
- A. Incorrect.
Promoting the read replica to a standalone database will not recover the deleted table, as the read replica reflects the current state of the primary database, which already has the deletion applied.
- B. Correct.
Performing a point-in-time restore allows you to recover the database to its state at a specific time, such as just before 12:30 PM, effectively restoring the deleted table. This is the correct approach for this scenario.
- C. Incorrect.
Taking a manual snapshot of the primary database would not help in this case, as the snapshot would reflect the current state of the database, which already includes the deletion.
- D. Incorrect.
Enabling Multi-AZ and failing over to the secondary instance would not recover the deleted table, as the secondary instance is an exact replica of the primary database and also reflects the deletion.