AWS Certified Solutions Architect – Associate (SAA-C02) — Question 147
A company has migrated an on-premises Oracle database to an Amazon RDS for Oracle Multi-AZ DB instance in the us-east-l Region. A solutions architect is designing a disaster recovery strategy to have the database provisioned in the us-west-2 Region in case the database becomes unavailable in the us-east-1
Region. The design must ensure the database is provisioned in the us-west-2 Region in a maximum of 2 hours, with a data loss window of no more than 3 hours.
How can these requirements be met?
Answer options
- A. Edit the DB instance and create a read replica in us-west-2. Promote the read replica to master in us-west-2 in case the disaster recovery environment needs to be activated.
- B. Select the multi-Region option to provision a standby instance in us-west-2. The standby instance will be automatically promoted to master in us-west-2 in case the disaster recovery environment needs to be created.
- C. Take automated snapshots of the database instance and copy them to us-west-2 every 3 hours. Restore the latest snapshot to provision another database instance in us-west-2 in case the disaster recovery environment needs to be activated.
- D. Create a multimaster read/write instances across multiple AWS Regions. Select VPCs in us-east-1 and us-west-2 to make that deployment. Keep the master read/write instance in us-west-2 available to avoid having to activate a disaster recovery environment.
Correct answer: A
Explanation
Option A is correct because creating a read replica in us-west-2 allows for quick promotion to master, ensuring the database can be provisioned within 2 hours and meets the data loss window requirement. Option B, while involving a standby instance, does not guarantee the same level of control and speed as promoting a read replica. Option C involves a longer restoration process, which may exceed the 2-hour requirement, and option D complicates the architecture unnecessarily without addressing the specific disaster recovery needs.