DOP-C02 Question 202
Single answerYour organization runs a critical application on an Amazon RDS MySQL database instance. A recent test of the disaster recovery plan revealed that restoring from a snapshot takes a significant amount of time, leading to unacceptable downtime. To improve recovery time in case of a failure, what is the most appropriate approach?
- A
Enable Amazon RDS Multi-AZ deployments for automatic failover.
- B
Increase the instance size of the Amazon RDS instance to reduce snapshot restoration time.
- C
Use Amazon RDS Read Replicas and promote one to the primary instance during a failure.
- D
Schedule frequent manual snapshots and keep them in a different AWS Region.
Show answer and explanation
Correct answer: A
Explanation
The best approach to reduce downtime in case of an RDS instance failure is to enable Multi-AZ deployments. This ensures that a standby instance is always available in a different Availability Zone, allowing for automatic failover with minimal disruption. Other options either do not address the downtime issue or require manual intervention, which increases recovery time.
- A. Correct.
Enabling Amazon RDS Multi-AZ deployments ensures high availability by automatically failing over to a standby instance in case of failure, significantly reducing downtime.
- B. Incorrect.
Increasing the instance size does not address the issue of downtime during snapshot restoration. It only improves performance during normal operations.
- C. Incorrect.
Amazon RDS Read Replicas are designed for read scalability and do not provide automatic failover capabilities. Promoting a read replica to primary is a manual process that can still result in significant downtime.
- D. Incorrect.
Frequent manual snapshots stored in a different AWS Region help with disaster recovery but do not address recovery time in the same Region. Restoring from a snapshot still involves significant downtime.