SOA-C02 Question 120
Select 2Your company runs a critical workload on Amazon RDS using a MySQL database. To ensure minimal downtime in the event of a regional disaster, you need to implement a disaster recovery strategy that allows for database failover to a different AWS Region. Which combination of actions should you take to achieve this goal?
- A
Enable Amazon RDS Multi-AZ for your database instance.
- B
Configure Amazon RDS cross-Region read replicas.
- C
Set up an AWS Lambda function to automatically promote the read replica in the event of a failure.
- D
Use Amazon RDS snapshots to manually restore the database in another Region.
- E
Implement Amazon RDS Global Database for your MySQL instance.
Show answer and explanation
Correct answers: B, E
Explanation
To achieve cross-Region disaster recovery for Amazon RDS, you can use either RDS cross-Region read replicas or RDS Global Database, as both provide mechanisms for replicating data to another Region. Cross-Region read replicas allow asynchronous replication of your database to a different Region, while RDS Global Database provides a more robust and low-latency solution for disaster recovery. Multi-AZ setups, on the other hand, are limited to a single Region, and snapshots involve manual effort and higher downtime.
- A. Incorrect.
Enabling Amazon RDS Multi-AZ provides high availability and automatic failover within a single AWS Region, but it does not provide cross-Region disaster recovery capabilities.
- B. Correct.
Configuring Amazon RDS cross-Region read replicas allows you to asynchronously replicate your database to a different AWS Region, providing a disaster recovery solution.
- C. Incorrect.
While AWS Lambda can automate certain tasks, it is not required or recommended to use Lambda to promote a read replica in this scenario. Promotion can be done manually or automatically during failover.
- D. Incorrect.
Using Amazon RDS snapshots for disaster recovery involves a manual process that can increase downtime and is not ideal for minimizing recovery time.
- E. Correct.
Amazon RDS Global Database is specifically designed for low-latency global reads and cross-Region disaster recovery. It allows for fast recovery in the event of a regional outage.