Amazon SAA-C03 Exam - Topic 4 Question 45 Discussion

Actual exam question for Amazon's SAA-C03 exam

Question #: 45
Topic #: 4

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?

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.

Show Suggested 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.

by Dannie at Sep 17, 2024, 03:25 PM

Limited Time Offer

25%

Off

Get Premium SAA-C03 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Florinda

3 months ago

Surprised that people aren't considering B, it could be more flexible!

upvoted 0 times

...

Jolanda

3 months ago

D is a solid choice too, but it might cost more in the long run.

upvoted 0 times

...

Sherron

3 months ago

Not sure about C, what if there's a failure right before the backup?

upvoted 0 times

...

Isaiah

4 months ago

I agree, C is straightforward and uses S3.

upvoted 0 times

...

Evangelina

4 months ago

Option C seems the most cost-effective for a 24-hour RPO/RTO.

upvoted 0 times

...

Sharika

4 months ago

I’m leaning towards option D since it mentions automatic snapshots, which we discussed in class. But I’m a bit uncertain about the cost implications compared to the others.

upvoted 0 times

...

Denny

4 months ago

I practiced a similar question, and I feel like copying automatic snapshots could be a solid option. But I’m not entirely sure if it covers everything we need.

upvoted 0 times

...

Cornell

4 months ago

I think option C sounds familiar. Using S3 for backups every 24 hours seems like it could meet the RPO and RTO, but is it the most cost-effective?

upvoted 0 times

...

Valentin

5 months ago

I remember that cross-Region read replicas can be expensive, but they might provide better RTO. Not sure if that's the best choice here though.

upvoted 0 times

...

Loreta

5 months ago

I'm a bit confused by the different options. I'll need to review the details of each one to understand the differences and determine the most cost-effective solution.

upvoted 0 times

...

Kirk

5 months ago

I've seen questions like this before. I think the best approach is to focus on the cost-effectiveness requirement and eliminate the options that are likely to be more expensive.

upvoted 0 times

...

Ernest

5 months ago

Okay, let's see. The key here is to find the most cost-effective solution that meets the 24-hour RPO and RTO requirements. I'll need to weigh the pros and cons of each option.

upvoted 0 times

...

Shanice

5 months ago

This looks like a straightforward disaster recovery question. I think I can handle this one.

upvoted 0 times

...

Dona

5 months ago

Hmm, I'm not sure about this. The question mentions RPO and RTO, which I'm a bit fuzzy on. I'll need to think this through carefully.

upvoted 0 times

...

Jacquline

5 months ago

I remember that ECI is supposed to be easier to manage than ECS, but I'm not totally sure why. Maybe it has to do with costs?

upvoted 0 times

...

Mirta

1 year 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

Merilyn

1 year ago

D) Copy automatic snapshots to another Region every 24 hours.

upvoted 0 times

...

Eleonore

1 year ago

C) Use cross-Region replication every 24 hours to copy native backups to an Amazon S3 bucket

upvoted 0 times

...

Justine

1 year ago

A) Create a cross-Region read replica and promote the read replica to the primary instance

upvoted 0 times

...

Thea

1 year 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 year 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 year 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

Talia

1 year ago

C) Use cross-Region replication every 24 hours to copy native backups to an Amazon S3 bucket

upvoted 0 times

...

Gail

1 year ago

B) Use AWS Database Migration Service (AWS DMS) to create RDS cross-Region replication.

upvoted 0 times

...

Dong

1 year ago

A) Create a cross-Region read replica and promote the read replica to the primary instance

upvoted 0 times

...

Rosendo

1 year 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 year 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