AWS Certified Solutions Architect – Associate (SAA-C03)Design Resilient ArchitecturesEasy
A company operates a critical application that processes real-time financial transactions. The application uses a relational database. To ensure high availability and automatic failover in case of a database instance failure, the company needs to deploy the database across multiple Availability Zones within the same AWS Region. Which AWS database deployment option should be chosen?
- AAmazon EC2 with a self-managed database
- BAmazon RDS Multi-AZ
- CAmazon RDS Single-AZ
- DAmazon Aurora Global Database
Show answer & explanationAnswer & explanation
Correct answer: B. Amazon RDS Multi-AZ
Amazon RDS Multi-AZ deployment automatically provisions and maintains a synchronous standby replica of the database in a different Availability Zone. In case of an outage of the primary instance or its AZ, RDS automatically fails over to the standby, ensuring high availability with minimal downtime and data loss.
Why the other options are wrong
- A. Self-managed databases on EC2 require manual configuration and management for high availability, which is complex and error-prone, contrary to a managed solution.
- C. Single-AZ deployment does not provide high availability or automatic failover.
- D. Aurora Global Database is for cross-region disaster recovery, not within-region high availability.
Amazon RDS Multi-AZ
An Amazon RDS deployment option that automatically provisions and maintains a synchronous standby replica of your database in a different Availability Zone within the same AWS Region, providing high availability and automatic failover.
- Provides high availability and durability within a single AWS Region.
- Automatic failover in case of primary instance or AZ failure.
- Synchronous replication ensures zero data loss during failover.
- Increases fault tolerance and reduces administrative burden.
Memory trick: Multi-AZ: More Zones, More Zest for Your DB.