Answer-first summary for fast verification
Answer: Copy automatic snapshots to another Region every 24 hours.
## Explanation The correct answer is **D** because it is the most cost-effective solution that meets the 24-hour RPO/RTO requirements. ### Analysis of Options: **A. Create a cross-Region read replica and promote the read replica to the primary instance.** - This provides near real-time replication but is expensive - Cross-Region read replicas incur additional costs for data transfer and replica instance - Over-engineered for 24-hour RPO/RTO requirements **B. Use AWS Database Migration Service (AWS DMS) to create RDS cross-Region replication.** - AWS DMS provides continuous replication but is more expensive - Requires ongoing DMS replication instance costs - More complex to set up and maintain **C. Use cross-Region replication every 24 hours to copy native backups to an Amazon S3 bucket.** - This could work but involves additional steps - Requires manual or automated backup processes - May not be as straightforward as RDS snapshots **D. Copy automatic snapshots to another Region every 24 hours.** - **Most cost-effective**: RDS automated backups are included in the RDS pricing - **Meets RPO/RTO**: 24-hour snapshot frequency aligns with requirements - **Simple recovery**: Can restore from snapshot in another Region - **Native RDS feature**: No additional services required - **SQL Server compatible**: Works with Microsoft SQL Server Enterprise Edition ### Why Option D is Best: 1. **Cost**: Automated backups are part of RDS service, cross-Region snapshot copy is minimal cost 2. **Simplicity**: Built-in RDS feature, no complex setup 3. **Compliance**: Meets 24-hour RPO (snapshot every 24 hours) and RTO (restore time from snapshot) 4. **Reliability**: RDS snapshots are consistent and reliable 5. **Recovery process**: Simple restore from snapshot in disaster scenario For a 24-hour RPO/RTO, there's no need for real-time or continuous replication solutions that incur higher costs. The snapshot approach provides adequate protection at the lowest cost.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
An ecommerce company wants a disaster recovery solution for its Amazon RDS DB instances that run Microsoft SQL Server Enterprise Edition. The company's current recovery point objective (RPO) and recovery time objective (RTO) are 24 hours.
Which solution will meet these requirements MOST cost-effectively?
A
Create a cross-Region read replica and promote the read replica to the primary instance.
B
Use AWS Database Migration Service (AWS DMS) to create RDS cross-Region replication.
C
Use cross-Region replication every 24 hours to copy native backups to an Amazon S3 bucket.
D
Copy automatic snapshots to another Region every 24 hours.