AWS Certified Solutions Architect Professional SAP-C02 Practice Question
A financial technology company runs a mission-critical MySQL 8.0 database on Amazon RDS in a Multi-AZ deployment with a single standby instance. Weekly maintenance events trigger failovers that interrupt payment processing for 70-90 seconds. New service-level objectives require that any planned or unplanned failover complete in under 35 seconds and that the platform can serve read-only analytics traffic from standby resources during normal operation. The solution must stay in a single AWS Region, minimize code changes, and keep operational overhead low.
Which approach should the solutions architect implement to meet these reliability requirements?
Convert the current database to an Amazon RDS Multi-AZ DB cluster with two readable standby instances and have the application connect through the cluster writer endpoint.
Create two cross-AZ MySQL read replicas, use an AWS Lambda function to promote a replica on failure, and direct traffic with Amazon Route 53 health-check-based DNS failover.
Migrate the database to an Aurora MySQL global database deployed across two AWS Regions and update the application to use the Aurora cluster endpoint.
Place Amazon RDS Proxy in front of the existing Multi-AZ DB instance to shorten failover time and use the proxy reader endpoint for analytics queries.
Amazon RDS Multi-AZ DB cluster creates one writer and two readable standby instances in three Availability Zones. Because each standby is a fully provisioned replica, RDS can promote one automatically and finish the entire failover process in typically less than 35 seconds, meeting the new objective. The cluster exposes a reader endpoint that applications can use to off-load analytics queries without additional infrastructure, and switching requires only updating the connection string to the cluster writer endpoint.
Placing Amazon RDS Proxy in front of the existing one-standby deployment reduces connection-handling time, but the storage-level failover of that topology still takes about 60-120 seconds, so the SLO is not met. Automating promotion of cross-AZ read replicas relies on custom code and DNS propagation, offering no guarantee of sub-35-second recovery. Aurora global database provides fast regional failover, but moving to a different engine and Region adds complexity well beyond the stated requirements. Therefore, upgrading to the RDS Multi-AZ DB cluster option is the most appropriate solution.
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 Amazon RDS Multi-AZ DB Cluster?
Open an interactive chat with Bash
How does Amazon RDS Multi-AZ DB Cluster achieve fast failover times?
Open an interactive chat with Bash
What is the difference between RDS Multi-AZ DB instance and Multi-AZ DB Cluster?
Open an interactive chat with Bash
AWS Certified Solutions Architect Professional SAP-C02
Design for New Solutions
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
IT & Cybersecurity Package Join Premium for Full Access