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…

Question

Options

• ACreate a cross-Region read replica and promote the read replica to the primary instance
• BUse AWS Database Migration Service (AWS DMS) to create RDS cross-Region replication.
• CUse cross-Region replication every 24 hours to copy native backups to an Amazon S3 bucket
• DCopy automatic snapshots to another Region every 24 hours.

• A
  4% (1)
• B
  7% (2)
• C
  4% (1)
• D
  86% (24)

Explanation

This solution is the most cost-effective and meets the RPO and RTO requirements of 24 hours. Automatic Snapshots: Amazon RDS automatically creates snapshots of your DB instance at regular intervals. By copying these snapshots to another AWS Region every 24 hours, you ensure that you have a backup available in a different geographic location, providing disaster recovery capability. RPO and RTO: Since the company's RPO and RTO are both 24 hours, copying snapshots daily to another Region is sufficient. In the event of a disaster, you can restore the DB instance from the most recent snapshot in the target Region. Why Not Other Options?: Option A (Cross-Region Read Replica): This could provide a faster recovery time but is more costly due to the ongoing replication and resource usage in another Region. Option B (DMS Cross-Region Replication): While effective for continuous replication, it introduces complexity and cost that isn't necessary given the 24-hour RPO/RTO. Option C (Cross-Region Native Backup Copy): This involves more manual steps and doesn't offer as straightforward a solution as automated snapshot copying.

No community discussion yet for this question.