AWS Certified CloudOps Engineer Associate SOA-C03 Practice Question
A company runs a production MySQL database on a single-AZ Amazon RDS instance in us-east-1a. Compliance now requires that the database experience no more than 2 minutes of unavailability if the Availability Zone hosting the primary instance fails. Operations staff must not perform any manual actions during a failover, and the solution should follow AWS best practices while minimizing operational overhead. Which change will meet these requirements?
Schedule frequent automated snapshots and restore the latest snapshot into another Availability Zone when a failure is detected.
Migrate the database to two self-managed MySQL EC2 instances in separate Availability Zones behind Amazon RDS Proxy to handle automatic failover.
Create an in-region MySQL read replica in another Availability Zone and configure Amazon RDS to promote it if the primary instance fails.
Modify the DB instance to enable Multi-AZ deployment so Amazon RDS creates a synchronous standby in a different Availability Zone that can automatically assume the primary role on failure.
Modifying the existing RDS instance to a Multi-AZ deployment provisions a synchronous standby in another Availability Zone. Amazon RDS continuously monitors both nodes and, when the primary becomes unavailable, automatically updates the instance's DNS to point to the standby. Typical failover completes in about 60-120 seconds, meeting the 2-minute RTO, and requires no administrator intervention. Read replicas use asynchronous replication and require manual promotion, while snapshots and EC2-hosted databases behind RDS Proxy demand manual steps or are unsupported for automatic AZ-level failover, so they do not satisfy the stated RTO or operational constraints.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is Multi-AZ deployment in Amazon RDS?
Open an interactive chat with Bash
Why are read replicas not suitable for automatic failover in Amazon RDS?
Open an interactive chat with Bash
What is the difference between Multi-AZ RDS instances and automated snapshots for disaster recovery?
Open an interactive chat with Bash
AWS Certified CloudOps Engineer Associate SOA-C03
Reliability and Business Continuity
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .