Courseiva
← SAA-C03
Full test
Design Resilient Architectures →easyMultiple Choice

SAA-C03 Design Resilient Architectures Practice Question

A company needs an Amazon RDS database that automatically fails over to a standby when the primary DB instance becomes unavailable. Which approach best meets the requirement with minimal operational effort?

⚠ Common exam trap

A common mix-up: candidates confuse Multi-AZ (synchronous replication, automatic failover) with Multi-Region (asynchronous replication, manual or automated cross-region failover) or assume that backups alone can provide high availability, but backups do not offer automatic failover or minimal downtime.

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 DB as a Multi-AZ DB instance so AWS maintains a synchronous standby in another Availability Zone and performs automated failover.

Amazon RDS Multi-AZ automatically provisions and maintains a synchronous standby replica in a different Availability Zone. When the primary DB instance fails, AWS handles the automatic failover to the standby with zero manual intervention, meeting the requirement with minimal operational effort.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • ✗

    Keep the DB as a single-AZ instance and implement a manual process to promote a standby when needed.

    Why it's wrong here

    A Single-AZ RDS instance does not provision any in-Region standby replica, so there is no secondary copy to automatically promote when the primary fails. Implementing a manual promotion process would require human intervention or custom orchestration scripts, which is exactly what the requirement says must be avoided. This approach also leaves the database exposed to AZ-level failures, and downtime is governed by how quickly an operator notices the outage and acts.

  • ✓

    Deploy the DB as a Multi-AZ DB instance so AWS maintains a synchronous standby in another Availability Zone and performs automated failover.

    Why this is correct

    RDS Multi-AZ provisions a synchronous standby in a different Availability Zone within the same AWS Region. When the primary DB instance is unavailable, AWS performs automated failover to the standby, reducing downtime without custom scripts.

  • ✗

    Enable versioned backups only, and restore the database each time the primary instance becomes unavailable.

    Why it's wrong here

    Backups support recovery from data issues, but they are not an availability mechanism. Restoring is a restore operation that typically takes longer than an AZ-level failover and still does not provide automatic promotion of a standby.

  • ✗

    Replicate the database to another region and switch clients to the secondary region using manual DNS changes.

    Why it's wrong here

    RDS cross-Region replication (using a cross-Region read replica) can support disaster recovery, but it does not provide automatic failover to the primary instance. The replica remains read-only until you manually promote it, and switching client traffic to the secondary Region requires manual DNS or connection-string changes. Because the replication is asynchronous, you may also lose transactions on failover, and the operation is not fully automated as the company specifically requires.

About these practice questions

This SAA-C03 question is part of Courseiva's 935-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

Same concept, more angles

1 more way this is tested on SAA-C03

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 team runs an Amazon RDS for MySQL database in a single Availability Zone. They want automatic failover with minimal downtime if the primary database instance becomes unavailable. Automated backups are already enabled. Which configuration change best meets the requirement?

easy
  • A.Keep the deployment as single-AZ, but increase automated backup retention to 35 days.
  • B.Create a read replica in another Availability Zone, but keep Multi-AZ disabled.
  • ✓ C.Enable RDS Multi-AZ so AWS maintains a standby in another Availability Zone for automatic failover.
  • D.Rely on restoring from the most recent manual snapshot after an outage.

Why C: Enabling Multi-AZ on Amazon RDS for MySQL automatically provisions and maintains a synchronous standby replica in a different Availability Zone. If the primary instance fails, Amazon RDS automatically fails over to the standby, typically within 60–120 seconds, minimizing downtime without manual intervention. This meets the requirement for automatic failover with minimal downtime.

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.