SOA-C02 Question 108
Single answerYour company uses an Amazon RDS MySQL database for its production environment. A developer accidentally deleted some critical data at 2:30 PM today. You have automated backups enabled with a backup retention period of 7 days. What is the best method to recover the database to the state it was in at 2:25 PM today?
- A
Perform a point-in-time restore to a new database instance using the automated backups.
- B
Restore the database using the latest snapshot and manually reapply the changes made before 2:30 PM.
- C
Promote an existing read replica to replace the primary database.
- D
Restore the database using AWS Elastic Disaster Recovery.
Show answer and explanation
Correct answer: A
Explanation
The point-in-time restore feature in Amazon RDS allows you to recover your database to any specific point within your backup retention period, minimizing data loss. This is the most effective solution for recovering from accidental deletions or updates.
- A. Correct.
This is the correct approach. A point-in-time restore allows you to restore the database to a specific time (e.g., 2:25 PM), using the automated backups and transaction logs.
- B. Incorrect.
This is incorrect because the latest snapshot would not include the data changes made just before 2:30 PM. Snapshots are not sufficient for precise point-in-time recovery.
- C. Incorrect.
Promoting a read replica would not help in this scenario since the replica would likely include the same accidental deletion unless it was lagging significantly.
- D. Incorrect.
AWS Elastic Disaster Recovery is not a service designed for restoring RDS databases. It is used for disaster recovery of servers and applications.