AWS Certified Solutions Architect - Associate
Get started today
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
A solutions architect is designing a company's disaster recovery (DR) architecture. The company has a MySQL database that runs on an Amazon EC2 instance in a private subnet with scheduled backup. The DR design needs to include multiple AWS Regions. Which solution will meet these requirements with the LEAST operational overhead?
Other
Community
UAnonymous
A
Migrate the MySQL database to multiple EC2 instances. Configure a standby EC2 instance in the DR Region. Turn on replication.
B
Migrate the MySQL database to Amazon RDS. Use a Multi-AZ deployment. Turn on read replication for the primary DB instance in the different Availability Zones.
C
Migrate the MySQL database to an Amazon Aurora global database. Host the primary DB cluster in the primary Region. Host the secondary DB cluster in the DR Region.
D
Store the scheduled backup of the MySQL database in an Amazon S3 bucket that is configured for S3 Cross-Region Replication (CCR). Use the data backup to restore the database in the DR Region.
Explanation:
Explanation
Correct Answer: C
Amazon Aurora Global Database is specifically designed for multi-region disaster recovery scenarios with minimal operational overhead. Here's why:
Why Option C is Correct:
- Built-in Multi-Region Replication: Aurora Global Database provides automated, low-latency replication across AWS Regions with typical recovery point objectives (RPO) of less than 1 second.
- Minimal Operational Overhead: AWS manages the replication, failover, and recovery processes automatically.
- Fast Failover: In case of a regional outage, you can promote the secondary cluster in the DR Region to primary with minimal downtime (typically less than 1 minute).
- Read Scaling: The secondary cluster can serve read traffic, improving performance.
Why Other Options Are Not Optimal:
Option A:
- Requires manual setup and management of replication between EC2 instances
- Higher operational overhead for monitoring, failover testing, and maintenance
- No automated failover capabilities
Option B:
- Multi-AZ deployment provides high availability within a single region, not across regions
- Read replicas in different Availability Zones are still within the same region
- Doesn't address the multi-region DR requirement
Option D:
- Relies on scheduled backups, which means potential data loss between backup intervals
- Manual restoration process required in DR Region
- Higher RPO (Recovery Point Objective) and RTO (Recovery Time Objective)
- Requires manual intervention for failover
Key Considerations:
- RPO (Recovery Point Objective): Aurora Global Database provides near-zero RPO
- RTO (Recovery Time Objective): Fast promotion of secondary cluster (typically < 1 minute)
- Automation: AWS manages replication, monitoring, and failover processes
- Cost: While Aurora may have higher costs than self-managed solutions, it significantly reduces operational overhead
This solution aligns with AWS best practices for disaster recovery across regions while minimizing operational complexity.
Comments
Loading comments...