Courseiva

SOA-C02 Reliability and Business Continuity Practice Question

A SysOps administrator is setting up a backup plan for an RDS MySQL database. The database is 500 GB in size and is used for a critical application. The company requires a Recovery Point Objective (RPO) of 5 minutes and a Recovery Time Objective (RTO) of 1 hour. Which solution meets these requirements?

⚠ Common exam trap

Many candidates confuse Multi-AZ (synchronous, zero data loss, automatic failover) with read replicas (asynchronous, potential data loss, manual promotion), and assume cross-region replicas can meet tight RPO/RTO when they cannot due to replication lag and promotion time.

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 instance in a Multi-AZ configuration with automatic failover.

Multi-AZ RDS with automatic failover meets the RPO of 5 minutes and RTO of 1 hour because it synchronously replicates data to a standby instance in a different Availability Zone. In the event of a failure, Amazon RDS automatically fails over to the standby, typically completing within 60–120 seconds, which satisfies the RTO. The synchronous replication ensures zero data loss (RPO of effectively 0), well within the 5-minute requirement.

Answer analysis

Option-by-option breakdown

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

  • ✓

    Deploy the RDS instance in a Multi-AZ configuration with automatic failover.

    Why this is correct

    Multi-AZ RDS uses synchronous replication to a standby instance in a different Availability Zone; every transaction is committed on both the primary and standby before being acknowledged, giving an RPO of zero. Should the primary fail, AWS automatically flips the DNS endpoint to the standby, typically completing failover in 60–120 seconds, comfortably meeting a 1-hour RTO. This makes it the only option that satisfies both the 5-minute RPO and the 1-hour RTO without manual intervention.

  • ✗

    Use AWS Backup to copy snapshots to a different AWS Region.

    Why it's wrong here

    AWS Backup can copy RDS snapshots to another Region for disaster recovery, but snapshots are point-in-time captures taken on a scheduled interval (commonly daily or at most every few hours). That means you could lose up to the interval's worth of transactions, easily exceeding the 5-minute RPO requirement, and restoring a snapshot to a new instance typically takes well over an hour, missing the 1-hour RTO. Cross-Region snapshot copy is a batch displacement mechanism, not a live replication or automatic failover solution.

  • ✗

    Take manual snapshots every 5 minutes and store them in Amazon S3.

    Why it's wrong here

    Taking a manual RDS snapshot every 5 minutes is operationally untenable because RDS limits the total number of snapshots per instance and snapshot creation itself is an asynchronous operation that can take longer than the interval, causing overlapping snapshot requests and potential throttling. Moreover, even though snapshots are stored in S3 under the hood, restoring from any snapshot requires creating a whole new RDS instance, with time-to-restore often exceeding the 1-hour RTO. Thus, frequent snapshots cannot provide the low RTO needed for automatic failover.

  • ✗

    Configure a cross-region read replica and promote it during failover.

    Why it's wrong here

    A cross-Region read replica replicates asynchronously from the primary, so replication lag can vary from seconds to minutes depending on network conditions and workload, making it impossible to guarantee an RPO of 5 minutes. Promotion of a replica to a standalone primary is a manual or scripted operation that requires updating application connection strings, and the promotion itself can take several minutes, so it does not meet the 1-hour RTO as a robust automatic solution. While replicas are excellent for read scaling and disaster recovery with relaxed tolerance, they are not synchronous and do not offer the same zero-data-loss automatic failover as Multi-AZ.

About these practice questions

This SOA-C02 question is part of Courseiva's 1,169-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

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.