SOA-C02 Reliability and Business Continuity Practice Question
A company runs a web application on EC2 instances in an Auto Scaling group behind an ALB. The application uses an RDS MySQL database. The SysOps administrator needs to improve the reliability of the database layer. Which TWO actions should the administrator take? (Choose two.)
⚠ Common exam trap
Watch out — candidates often confuse backup strategies (automated backups, manual snapshots) or read replicas with high-availability features like Multi-AZ, leading candidates to select options that improve data durability or read performance instead of database layer reliability.
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
✓
Enable Multi-AZ on the RDS instance.
Enabling Multi-AZ on an RDS MySQL instance 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, providing high availability and improving database reliability without manual intervention. This directly addresses the need for a resilient database layer.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Enable Multi-AZ on the RDS instance.
Why this is correct
Enable Multi-AZ on the RDS instance: Multi-AZ creates a synchronous standby replica in a different Availability Zone. When the primary DB instance fails or its Availability Zone becomes unavailable, Amazon RDS automatically flips the DNS record to the standby, providing rapid, automated failover. This directly addresses the high availability requirement for the web application's database layer by eliminating a single point of failure.
- ✗
Take a manual snapshot every hour.
Why it's wrong here
Take a manual snapshot every hour: While manual snapshots provide a backup up to the previous hour, they are not an automated high availability solution. Restoring from a snapshot requires a manual process to create a new DB instance, which can take minutes and results in extended downtime. The hourly RPO is acceptable only for backup/recovery, not for minimizing service interruption during an infrastructure failure.
- ✗
Create a read replica in a different Region.
Why it's wrong here
Create a read replica in a different Region: A cross-Region read replica replicates data asynchronously to a different geographic area, but it is designed for read scaling and disaster recovery. Promoting a read replica to become the primary DB instance is a manual operation, and replication lag can cause data loss. It does not provide automatic, synchronous failover within the same Region, which is what Multi-AZ offers.
- ✓
Configure automated backups with a retention period of 30 days.
Why this is correct
Configure automated backups with a retention period of 30 days: Automated backups enable point-in-time recovery to any second within the retention window, protecting against logical data corruption or accidental deletes. However, restoring from an automated backup is a manual action that creates a brand-new DB instance, so it cannot provide automatic database failover. This is a complement to Multi-AZ, not a replacement for high availability.
- ✗
Increase the DB instance class to the largest available.
Why it's wrong here
Increase the DB instance class to the largest available: Scaling to a larger instance class increases compute and memory capacity, which can improve transaction processing performance under load. It does not, however, add any redundancy; the DB instance remains a single point of failure on one host in one Availability Zone. High availability requires replication and automated failover, not simply more powerful hardware.
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 →
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.