Exam AWS Certified Database - Specialty topic 1 question 168 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 168
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A company is running its production databases in a 3 TB Amazon Aurora MySQL DB cluster. The DB cluster is deployed to the us-east-1 Region. For disaster recovery (DR) purposes, the company's database specialist needs to make the DB cluster rapidly available in another AWS Region to cover the production load with an RTO of less than 2 hours.
What is the MOST operationally efficient solution to meet these requirements?

A. Implement an AWS Lambda function to take a snapshot of the production DB cluster every 2 hours, and copy that snapshot to an Amazon S3 bucket in the DR Region. Restore the snapshot to an appropriately sized DB cluster in the DR Region.
B. Add a cross-Region read replica in the DR Region with the same instance type as the current primary instance. If the read replica in the DR Region needs to be used for production, promote the read replica to become a standalone DB cluster.
C. Create a smaller DB cluster in the DR Region. Configure an AWS Database Migration Service (AWS DMS) task with change data capture (CDC) enabled to replicate data from the current production DB cluster to the DB cluster in the DR Region.
D. Create an Aurora global database that spans two Regions. Use AWS Database Migration Service (AWS DMS) to migrate the existing database to the new global database.

Show Suggested Answer

Suggested Answer: B 🗳️

by jove at Dec. 24, 2021, 8:47 p.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

Pranava_GCP

1 year, 8 months ago

Selected Answer: B

B. Add a cross-Region read replica in the DR Region this is MOST operationally efficient solution

upvoted 2 times

...

tsk9921

2 years ago

B is right

upvoted 1 times

...

Sathish_dbs

2 years, 5 months ago

why not the option A ? replica consumes instance and data cost while snapshots costs less and restore of 3 TB can happen in less than 2 hours to achieve an RTO of 2 hours

upvoted 2 times

Bota5ky

1 year, 10 months ago

Because copy a 3TB snapshot to another region using lamdba, it will cost far beyond 15 mins.

upvoted 1 times

...

Pranava_GCP

1 year, 8 months ago

cost-saving is not a requirement here, but operationally efficient is required in this case.

upvoted 1 times

...

novice_expert

3 years, 1 month ago

Selected Answer: B

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Replication.CrossRegion.html RTO is 2 hours. With 3 TB database, cross-region replica Global Database was good but DMS ?

upvoted 2 times

...