ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam
Go to 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 Hide 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

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
jove
Highly Voted 3 years, 6 months ago
Minimum downtime > AWS DMS : Option C
upvoted 13 times
...
Sab
Highly Voted 2 years, 5 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, 8 months ago
Selected Answer: C
CCCCCCC
upvoted 1 times
...
navkumin
1 year, 10 months ago
Selected Answer: C
C is supported now
upvoted 1 times
...
tucobbad
2 years, 4 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, 5 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, 8 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, 7 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, 1 month ago
Agree with you - C After reviewing the link.
upvoted 1 times
...
...
...
sachin
2 years, 11 months ago
C will provide minimum down time
upvoted 1 times
...
novice_expert
3 years 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
1 year, 12 months 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, 2 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, 4 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, 2 months ago
Selected Answer: C
A and B will be slow D is not possible yet
upvoted 1 times
...
yahooos
3 years, 3 months ago
C Minimum downtime > AWS DMS
upvoted 1 times
...
mnzsql365
3 years, 5 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, 2 months ago
you missed the "minimum downtime"
upvoted 2 times
...
...
nood
3 years, 5 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, 5 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, 10 months ago
maybe you mean C
upvoted 1 times
...
...
Tonytt
3 years, 6 months ago
should be C
upvoted 4 times
...
[Removed]
3 years, 6 months ago
A,B - No minimal downtime D- Cross Region replica not supported for RDS SQL Server Ans : C
upvoted 6 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago