BlackFriday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Amazon Exam SAA-C03 Topic 4 Question 45 Discussion

Actual exam question for Amazon's SAA-C03 exam
Question #: 45
Topic #: 4
[All SAA-C03 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: D

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.

AWS Reference:

Amazon RDS Automated Backups and Snapshots - Details on automated backups and snapshots in RDS.

Copying an Amazon RDS DB Snapshot - How to copy DB snapshots to another Region.


Contribute your Thoughts:

Mirta
26 days ago
A or B would be overkill for a 24-hour RPO. This is like using a bazooka to kill a fly - sure, it gets the job done, but it's a bit much.
upvoted 0 times
Eleonore
4 days ago
C) Use cross-Region replication every 24 hours to copy native backups to an Amazon S3 bucket
upvoted 0 times
...
Justine
6 days ago
A) Create a cross-Region read replica and promote the read replica to the primary instance
upvoted 0 times
...
...
Thea
1 months ago
Option C is the most cost-effective, as it leverages the existing backup infrastructure. Plus, who doesn't love an S3 bucket?
upvoted 0 times
...
Janna
1 months ago
I'd go with D. Copying snapshots to S3 is a simple and reliable disaster recovery solution, and the 24-hour RPO is already met.
upvoted 0 times
...
Gayla
1 months ago
B looks good too, but I'm not sure if the additional cost of DMS is worth it for this use case. The RPO and RTO can probably be met with the other options.
upvoted 0 times
Gail
5 days ago
B) Use AWS Database Migration Service (AWS DMS) to create RDS cross-Region replication.
upvoted 0 times
...
Dong
12 days ago
A) Create a cross-Region read replica and promote the read replica to the primary instance
upvoted 0 times
...
...
Rosendo
1 months ago
But option C also seems like a viable solution, as it copies backups to an S3 bucket for easy access.
upvoted 0 times
...
Myra
1 months ago
Option A seems the most straightforward way to meet the RTO and RPO requirements. Cross-Region read replicas provide near real-time replication and failover.
upvoted 0 times
Jose
11 days ago
Option A seems the most straightforward way to meet the RTO and RPO requirements.
upvoted 0 times
...
...
Marya
1 months ago
I disagree, I believe option B is more cost-effective as it utilizes AWS DMS for replication.
upvoted 0 times
...
Rosendo
2 months ago
I think option A is the best choice because it allows for quick failover in case of a disaster.
upvoted 0 times
...

Save Cancel