Q15 — AWS SAA-C03 Ch.11

Question 15 of 100 | ← Chapter 11

Q715. 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. ✓

Correct Answer: D. Copy automatic snapshots to another Region every 24 hours.

Explanation

The correct answer is:D. Copy automatic snapshots to another Region every 24 hours.Option D provides a cost-effective solution to meet the given requirements:- Copy automatic snapshots to another Region every 24 hours: Amazon RDS allows you to automate the creation of snapshots for your DB instances. By configuring a process to copy the automatic snapshots to another Region every 24 hours, you can achieve the desired RPO and RTO of 24 hours.This solution leverages the built-in snapshot functionality of Amazon RDS, which is a cost-effective way to create backups of your DB instances. By copying the automatic snapshots to another Region, you ensure that the backups are stored in a separate geographic location for disaster recovery purposes.Option A, creating a cross-Region read replica and promoting it to the primary instance, provides a level of redundancy but may not align with the desired RPO and RTO of 24 hours.Option B, using AWS Database Migration Service (AWS DMS) to create RDS cross-Region replication, introduces additional complexity and cost, which may not be the most cost-effective solution for meeting the given requirements.Option C, using cross-Region replication every 24 hours to copy native backups to an Amazon S3 bucket, is not a native feature of Amazon RDS. While it is possible to implement such a solution using custom scripts or third-party tools, it may introduce additional complexity and cost compared to using the built-in snapshot functionality.Therefore, the best solution to meet the requirements in a cost-effective manner is D: Copy automatic snapshots to another Region every 24 hours. This solution leverages the automated snapshot feature of Amazon RDS and ensures that backups are regularly replicated to another Region for disaster recovery purposes.