Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam

Exam AWS Certified Database - Specialty topic 1 question 183 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 183
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A company is migrating a database in an Amazon RDS for SQL Server DB instance from one AWS Region to another. The company wants to minimize database downtime during the migration.
Which strategy should the company choose for this cross-Region migration?

A. Back up the source database using native backup to an Amazon S3 bucket in the same Region. Then restore the backup in the target Region.
B. Back up the source database using native backup to an Amazon S3 bucket in the same Region. Use Amazon S3 Cross-Region Replication to copy the backup to an S3 bucket in the target Region. Then restore the backup in the target Region.
C. Configure AWS Database Migration Service (AWS DMS) to replicate data between the source and the target databases. Once the replication is in sync, terminate the DMS task.
D. Add an RDS for SQL Server cross-Region read replica in the target Region. Once the replication is in sync, promote the read replica to master.

Show Suggested Answer

Suggested Answer: D 🗳️

by [deleted] at Nov. 11, 2021, 2:42 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

jove

Highly Voted 3 years, 7 months ago

Minimum downtime > AWS DMS : Option C

upvoted 13 times

...

Sab

Highly Voted 2 years, 7 months ago

Selected Answer: D

Amazon RDS for SQL Server now support Cross Region Read Replica that can be promoted to standalone instance. So Answer D is the best fit .

upvoted 10 times

...

chen0305_099

Most Recent 1 year, 10 months ago

Selected Answer: C

CCCCCCC

upvoted 1 times

...

navkumin

2 years ago

Selected Answer: C

C is supported now

upvoted 1 times

...

tucobbad

2 years, 6 months ago

Now Read Replica for RDS SQL Server is supported. Now what? Go with C or D? BTW, does AWS update their exams with new features?

upvoted 2 times

...

Sab

2 years, 7 months ago

Amazon RDS for SQL Server now support Cross Region Read Replica that can be promoted to standalone instance. So Answer D is the best fit .

upvoted 1 times

...

Adi_M

2 years, 10 months ago

Cross-Region disaster recovery of Amazon RDS for SQL Server - is possible https://aws.amazon.com/blogs/database/cross-region-disaster-recovery-of-amazon-rds-for-sql-server/. Why not D?

upvoted 1 times

JeanGat

2 years, 9 months ago

From link, "SQL Server MS Replication is one such feature that, as of this writing, isn’t yet available in Amazon RDS for SQL Server. However, you can to use AWS Database Migration Service (AWS DMS) to do continuous replication"

upvoted 3 times

Mintwater

2 years, 3 months ago

Agree with you - C After reviewing the link.

upvoted 1 times

...

sachin

3 years ago

C will provide minimum down time

upvoted 1 times

...

novice_expert

3 years, 2 months ago

Selected Answer: C

A. slow B. slow C. source-> AWS DMS -> target region database -> sync -> terminate DMS D. cross-Region read replica not supported

upvoted 2 times

aviathor

2 years, 1 month ago

As of Nov 16, 2022 cross-Region read replica IS supported :) Hopefully the exams have been updated to reflect this.

upvoted 2 times

...

Dantas

3 years, 3 months ago

Selected Answer: C

Option C. The following aren't supported on Amazon RDS for SQL Server: - Creating a read replica in a different AWS Region (a cross-Region read replica) - Backup retention of read replicas - Point-in-time recovery from read replicas - Manual snapshots of read replicas - Multi-AZ read replicas - Creating read replicas of read replicas - Synchronization of user logins to read replicas https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.ReadReplicas.html

upvoted 3 times

Sathish_dbs

2 years, 6 months ago

- Creating a read replica in a different AWS Region (a cross-Region read replica) is supported. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.ReadReplicas.html

upvoted 1 times

...

tugboat

3 years, 4 months ago

Selected Answer: C

A and B will be slow D is not possible yet

upvoted 1 times

...

yahooos

3 years, 4 months ago

C Minimum downtime > AWS DMS

upvoted 1 times

...

mnzsql365

3 years, 6 months ago

A - for me, the question is about transferring database from one region to another. Native backup restore is supported for RDS SQL Server using S3.

upvoted 1 times

RotterDam

3 years, 4 months ago

you missed the "minimum downtime"

upvoted 2 times

...

nood

3 years, 7 months ago

C for me https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.XRgn.html With Amazon RDS, you can create a MariaDB, MySQL, Oracle, or PostgreSQL read replica in a different AWS Region from the source DB instance. Creating a cross-Region read replica isn't supported for SQL Server on Amazon RDS.

upvoted 4 times

...

scottkerker

3 years, 7 months ago

Option B seems correct from https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.html, yet there is a requirement that throughout the transfer that the downtime needs to be minimal, therefore, AWS DMS would be the choice to fulfill the requirement. For detail, one can refer to this blog post, https://aws.amazon.com/blogs/database/replicate-and-transform-data-in-amazon-aurora-postgresql-across-multiple-regions-using-aws-dms/, and notice that AWS DMS supports abundant sources and targets.

upvoted 2 times

eji

2 years, 11 months ago

maybe you mean C

upvoted 1 times

...

Tonytt

3 years, 7 months ago

should be C

upvoted 4 times

...

[Removed]

3 years, 7 months ago

A,B - No minimal downtime D- Cross Region replica not supported for RDS SQL Server Ans : C

upvoted 6 times

...