ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 828 - SAA-C03 discussion

Report
Export

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
Answers
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.
Answers
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
Answers
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.
Answers
D.
Copy automatic snapshots to another Region every 24 hours.
Suggested answer: D

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.

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.

asked 16/09/2024
Abel Galleguillos
39 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first