SOA-C02 Reliability and Business Continuity Practice Question
A SysOps administrator needs to implement a backup strategy for an Amazon RDS for PostgreSQL database. The database is 500 GB and experiences heavy write traffic. Which solution provides the most cost-effective backup with the least impact on database performance?
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 automated backups with a retention period of 7 days.
Automated backups are enabled by default with minimal performance impact and include transaction logs for point-in-time recovery. Option B is wrong; while using a standby for backups in Multi-AZ can reduce impact, automated backups already have minimal impact and are more cost-effective. Option C is wrong because AWS DMS replication to S3 is not a backup solution and adds complexity and cost. Option D is wrong because manual snapshots cause a brief I/O suspension and are less automated than automated backups.
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 automated backups with a retention period of 7 days.
Why this is correct
Automated backups are the native RDS backup mechanism: daily snapshots of the database volume are captured, and transaction logs are continuously uploaded to S3 so you can restore to any point within the 7-day retention window. These backup operations are low overhead because they leverage the EBS snapshot facility, so the performance impact is minimal and no long-duration downtime is required. With a 7-day retention, you automatically meet a standard RPO (point-in-time) without manual effort or risk of expiring snapshots.
- ✗
Create a Multi-AZ deployment and use the standby for backups.
Why it's wrong here
A Multi-AZ deployment provides synchronous replication of your database to an instance in a different Availability Zone, which delivers automatic failover for high availability. It is not a backup mechanism — the standby replica is a live copy that is only used for failover, and RDS takes automated backups and manual snapshots from the primary instance only. You cannot initiate a snapshot from the standby, and creating a Multi-AZ deployment alone does not give you point-in-time recovery or a backup retention policy.
- ✗
Use AWS Database Migration Service to continuously replicate data to an S3 bucket.
Why it's wrong here
AWS Database Migration Service (DMS) is designed to migrate databases between source and target engines, and while it can perform continuous replication to Amazon S3, that feature is meant for data lake ingestion or migration staging, not for database backups. DMS replication does not capture the complete database state, including system catalogs and transaction-specific metadata, so restoring a full database from the S3 target requires additional tools and is not equivalent to a native restore. Operating DMS also requires a dedicated replication instance, network configuration, and task monitoring, making it a costly and complex alternative to RDS automated backups.
- ✗
Take manual DB snapshots daily during off-peak hours.
Why it's wrong here
Manual DB snapshots are user-initiated and require you to schedule, monitor, and clean them up yourself; RDS performs no expiration on manual snapshots, so an automated daily script is needed to delete old ones to avoid storage cost creep. Additionally, starting a manual snapshot is initiated from the primary instance and can cause a brief I/O suspension of a few seconds, which is fine during off-peak times but still requires administrative oversight. Because you must remember to run them every day, this approach is not truly automated and can be error-prone, whereas automated backups handle the schedule, retention, and point-in-time log backup automatically.
Quick reference
AWS S3 Storage Class Comparison
| Storage Class | Min Duration | Retrieval | Use Case |
|---|---|---|---|
| S3 Standard | None | Immediate | Frequently accessed data |
| S3 Standard-IA | 30 days | Immediate | Infrequent access, rapid retrieval |
| S3 One Zone-IA | 30 days | Immediate | Non-critical infrequent data |
| S3 Intelligent-Tiering | None | Immediate–hours | Unknown or changing access patterns |
| S3 Glacier Instant | 90 days | Milliseconds | Archive with instant retrieval |
| S3 Glacier Flexible | 90 days | Minutes–hours | Archive, flexible retrieval |
| S3 Glacier Deep Archive | 180 days | Hours | Long-term compliance archive |
Go deeper
Related to this question
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 →
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.