SOA-C02 Multi-AZ deployment Practice Question
A company runs a production Amazon RDS for PostgreSQL DB instance. The SysOps administrator needs to ensure that in the event of a database failure, there is automatic failover to a standby instance in another Availability Zone with minimal downtime. Which deployment configuration should the administrator enable?
⚠ Common exam trap
Candidates often confuse Read Replicas with Multi-AZ deployments, mistakenly believing that Read Replicas provide automatic failover, when in fact they only support manual promotion and are intended for read scaling, not high availability.
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
✓
Multi-AZ deployment
A Multi-AZ deployment for Amazon RDS automatically provisions and maintains a synchronous standby replica in a different Availability Zone. In the event of a database failure or an Availability Zone outage, Amazon RDS automatically fails over to the standby, typically within 60-120 seconds, without requiring manual intervention. This ensures high availability and minimal downtime for the production PostgreSQL DB instance.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Multi-AZ deployment
Why this is correct
Multi-AZ maintains a synchronous standby replica in a different Availability Zone and performs automatic failover via DNS endpoint redirection when the primary fails. This satisfies the requirement for automatic cross-AZ failover with minimal downtime, unlike read replicas, which require manual promotion.
- ✗
Read Replicas
Why it's wrong here
Read Replicas serve read-only traffic asynchronously and require manual promotion; they provide no automatic failover to a standby in another Availability Zone. They are tempting because they add cross-AZ resilience and offload reads, and would be correct for scaling read-heavy workloads, not for automatic failover.
- ✗
Automated backups with point-in-time recovery
Why it's wrong here
Automated backups with point-in-time recovery restore data to a new instance after a failure, which takes time and is not automatic failover to a standby. It is tempting because it protects against data loss, and would be correct for recovering from accidental deletion or corruption, not for minimal-downtime failover.
- ✗
Amazon RDS Proxy
Why it's wrong here
RDS Proxy pools and multiplexes database connections; it does not maintain a standby copy or perform failover. It is tempting because it improves availability during failover by holding connections, and would be correct for connection management with Lambda or high connection churn, not for cross-AZ automatic failover.
Go deeper
Related to this question
About these practice questions
One of 1,169 original SOA-C02 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
Same concept, more angles
2 more ways this is tested on SOA-C02
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. A SysOps administrator is configuring an Amazon RDS for MySQL Multi-AZ deployment. What is the primary benefit of using Multi-AZ?
easy- A.Improved read performance by distributing queries across multiple instances.
- ✓ B.Automatic failover to a standby instance in a different Availability Zone.
- C.Synchronous replication across AWS Regions.
- D.Automatic creation of read replicas for disaster recovery.
Why B: In Amazon RDS for MySQL Multi-AZ deployments, the primary benefit is automatic failover to a standby instance in a different Availability Zone. This is achieved through synchronous replication to a standby in a separate AZ, ensuring that if the primary instance fails, RDS automatically promotes the standby to become the new primary, minimizing downtime and maintaining data durability.
Variation 2. A SysOps administrator is testing the failover of an Amazon RDS for PostgreSQL Multi-AZ DB instance. The application currently writes to the primary instance in us-east-1a. Which action will manually trigger a failover to the standby instance in us-east-1b?
medium- ✓ A.Reboot the DB instance and select 'Reboot with failover'.
- B.Modify the DB instance to Single-AZ and then back to Multi-AZ.
- C.Reboot the DB instance without selecting any failover option.
- D.Promote the standby instance using the Amazon RDS console.
Why A: The 'Reboot with failover' option in the Amazon RDS console explicitly triggers a failover by rebooting the primary DB instance and forcing the Multi-AZ configuration to promote the standby instance in us-east-1b to become the new primary. This is the designed method for manually testing or initiating a failover in a Multi-AZ deployment.
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This SOA-C02 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 SOA-C02 exam.