SOA-C02 Question 105
Single answerAn organization is running a MySQL database on Amazon RDS with automated backups enabled. A database administrator accidentally deleted some records and needs to restore the database to its state as of two hours ago. Which action should the SysOps Administrator take to achieve this?
- A
Initiate a point-in-time restore to a new database instance using the RDS management console.
- B
Use the AWS CLI to promote a read replica to a standalone database instance.
- C
Restore the database from the most recent snapshot and manually reapply changes from the past two hours.
- D
Enable cross-region replication and replicate the database to another region for recovery.
Show answer and explanation
Correct answer: A
Explanation
Point-in-time restore is a feature of Amazon RDS that enables users to recover their database to a specific time within the retention period of automated backups. By initiating the point-in-time restore, the SysOps Administrator can create a new database instance with the data as it was two hours ago, effectively solving the issue caused by the accidental deletion.
- A. Correct.
This is the correct option. A point-in-time restore allows recovering the database to a specific time within the retention period. A new database instance will be created during this process.
- B. Incorrect.
Promoting a read replica is not relevant to this scenario, as it does not address the need to restore the database to a specific point in time.
- C. Incorrect.
Restoring from the most recent snapshot would not include transactions or data changes that occurred after the snapshot. This would result in data loss for the past two hours.
- D. Incorrect.
Cross-region replication is a disaster recovery strategy, not a solution for restoring data to a specific point in time in the same region.