SAA-C03 Design Resilient Architectures Practice Question
A company runs its customer-facing web app on EC2 behind an Application Load Balancer. The database is Amazon RDS for PostgreSQL. The requirement is that if a single Availability Zone fails, the database must automatically fail over within the same AWS Region with minimal application changes. Which database setup best meets this requirement?
⚠ Common exam trap
A common mix-up: candidates confuse a read replica (which requires manual promotion and DNS changes) with a Multi-AZ standby (which provides automatic, transparent failover), leading them to incorrectly select Option C.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Deploy the RDS PostgreSQL instance as Multi-AZ with automatic failover enabled.
RDS Multi-AZ for PostgreSQL automatically provisions and maintains a synchronous standby replica in a different Availability Zone. If the primary AZ fails, Amazon RDS automatically fails over to the standby, typically within 60–120 seconds, with no changes required to the application's connection string (the DNS name remains the same). This meets the requirement for minimal application changes and automatic failover within the same Region.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use an RDS single-AZ instance and periodically restore from automated backups if needed.
Why it's wrong here
Single-AZ deployments do not provide automatic failover for an AZ outage. Restoring from backups requires manual or scripted intervention, increasing downtime.
When this WOULD be correct
If the requirement were to minimize costs and allow for some data loss (RPO of hours) and downtime (RTO of hours), with no need for automatic failover, then a single-AZ instance with periodic backups would be acceptable.
- ✓
Deploy the RDS PostgreSQL instance as Multi-AZ with automatic failover enabled.
Why this is correct
Multi-AZ RDS maintains a standby instance in a different AZ. If the primary fails, RDS performs automatic failover, preserving the same database endpoint behavior.
- ✗
Create a read replica in a different AZ and use it only when the primary fails.
Why it's wrong here
A read replica does not automatically replace a failed primary instance. You would need manual promotion and application rerouting.
When this WOULD be correct
This option would be correct if the requirement was to offload read traffic from the primary database and have a standby for manual failover in a disaster recovery scenario, where some downtime is acceptable and application changes are allowed.
- ✗
Use RDS with Multi-AZ disabled, but increase storage IOPS to prevent failover.
Why it's wrong here
Performance changes do not address AZ availability. Storage IOPS does not provide automatic failover capabilities during an Availability Zone outage.
When this WOULD be correct
If the requirement were to improve database performance for a read-heavy workload without needing automatic failover, increasing IOPS on a single-AZ instance would be correct.
Option-by-option analysis
Why each answer is right or wrong
Understanding why wrong answers are wrong — and when they would be correct — is what separates a 750 score from a 900. The SAA-C03 exam frequently reuses these exact scenarios with slightly different constraints.
✓Deploy the RDS PostgreSQL instance as Multi-AZ with automatic failover enabled.Correct answer▾
Why this is correct
Multi-AZ RDS maintains a standby instance in a different AZ. If the primary fails, RDS performs automatic failover, preserving the same database endpoint behavior.
✗Use an RDS single-AZ instance and periodically restore from automated backups if needed.Wrong answer — click to see why▾
Why this is wrong here
Single-AZ RDS with manual backup restoration does not provide automatic failover; it requires manual intervention and incurs significant downtime, failing the requirement for automatic failover within the same Region.
★ When this WOULD be the correct answer
If the requirement were to minimize costs and allow for some data loss (RPO of hours) and downtime (RTO of hours), with no need for automatic failover, then a single-AZ instance with periodic backups would be acceptable.
Why candidates choose this
Candidates may think that restoring from backups is a valid disaster recovery method, but they overlook the requirement for automatic failover with minimal application changes.
✗Create a read replica in a different AZ and use it only when the primary fails.Wrong answer — click to see why▾
Why this is wrong here
A read replica is not designed for automatic failover; promoting it requires manual intervention or additional scripting, which does not meet the 'automatically fail over' requirement with minimal application changes.
★ When this WOULD be the correct answer
This option would be correct if the requirement was to offload read traffic from the primary database and have a standby for manual failover in a disaster recovery scenario, where some downtime is acceptable and application changes are allowed.
Why candidates choose this
Candidates may think a read replica in a different AZ provides automatic failover similar to Multi-AZ, but they overlook that read replicas require manual promotion and do not provide automatic, seamless failover.
✗Use RDS with Multi-AZ disabled, but increase storage IOPS to prevent failover.Wrong answer — click to see why▾
Why this is wrong here
Multi-AZ disabled means no automatic failover; increasing IOPS improves performance but does not provide high availability across AZs, so it fails the requirement of automatic failover during an AZ failure.
★ When this WOULD be the correct answer
If the requirement were to improve database performance for a read-heavy workload without needing automatic failover, increasing IOPS on a single-AZ instance would be correct.
Why candidates choose this
Candidates may confuse performance improvements (IOPS) with availability features, thinking that faster storage can compensate for lack of redundancy.
Analysis generated from the official SAA-C03blueprint and verified against question context. The “when correct” sections are what AI assistants cite when candidates ask “what’s the difference between these options?”
Go deeper
Related to this question
About these practice questions
Courseiva writes every SAA-C03 question from scratch — 302 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This SAA-C03 practice question is part of Courseiva's free Amazon Web Services certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the SAA-C03 exam.