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 256 discussion

Exam question from Amazon's AWS Certified Database - Specialty
Question #: 256
Topic #: 1
[All AWS Certified Database - Specialty Questions]

A company recently migrated its line-of-business (LOB) application to AWS. The application uses an Amazon RDS for SQL Server DB instance as its database engine.
The company must set up cross-Region disaster recovery for the application. The company needs a solution with the lowest possible RPO and RTO.
Which solution will meet these requirements?

  • A. Create a cross-Region read replica of the DB instance. Promote the read replica at the time of failover.
  • B. Set up SQL replication from the DB instance to an Amazon EC2 instance in the disaster recovery Region. Promote the EC2 instance as the primary server.
  • C. Use AWS Database Migration Service (AWS KMS) for ongoing replication of the DB instance in the disaster recovery Region.
  • D. Take manual snapshots of the DB instance in the primary Region. Copy the snapshots to the disaster recovery Region.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by mbar94 at Sept. 8, 2022, 10:11 a.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
gairaj
Highly Voted 2 years, 7 months ago
Selected Answer: C
Only two options in sql server cross region replication. copy snapshots and DMS https://aws.amazon.com/blogs/database/cross-region-disaster-recovery-of-amazon-rds-for-sql-server/
upvoted 7 times
...
RBSK
Highly Voted 2 years, 4 months ago
Selected Answer: A
https://aws.amazon.com/blogs/database/use-cross-region-read-replicas-with-amazon-relational-database-service-for-sql-server/ Nov 2022 - Release date hence "A" is a right choice as of now
upvoted 6 times
...
FarhatRV
Most Recent 1 year, 10 months ago
Selected Answer: A
As of November 2022, Amazon RDS for SQL Server supports cross-Region read replicas, refer to Use cross-Region read replicas with Amazon Relational Database Service for SQL Server to learn more.
upvoted 3 times
...
aviathor
1 year, 11 months ago
Selected Answer: A
AWS does not seem overly keen on using DMS for heterogeneous replications, and seems to prefer native tools or replication.
upvoted 5 times
...
dougporto1988
2 years, 1 month ago
Selected Answer: A
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.ReadReplicas.html#SQLServer.ReadReplicas.limitations.options:~:text=When%20you%20promote%20a%20SQL%20Server%20cross%2DRegion%20read%20replica%2C
upvoted 4 times
...
khun
2 years, 4 months ago
Selected Answer: A
I'll go with A. Amazon Relational Database Service (Amazon RDS) for SQL Server now supports Cross Region Read Replica. Cross Region Read Replica enables managed disaster recovery capability for mission critical databases by allowing a read replica in another region be "promoted" as a new standalone production database.
upvoted 4 times
...
examineme
2 years, 4 months ago
Selected Answer: A
I will go with (A). https://aws.amazon.com/about-aws/whats-new/2022/11/amazon-rds-sql-server-cross-region-read-replica/
upvoted 3 times
...
Sab
2 years, 4 months ago
Selected Answer: A
RDS for SQL Server now supports cross Region Replica. (released Nov 2022) https://aws.amazon.com/about-aws/whats-new/2022/11/amazon-rds-sql-server-cross-region-read-replica/
upvoted 3 times
...
VK1709PNP
2 years, 6 months ago
C, as cross-region read replica is not supported for RDS SQL Server
upvoted 1 times
...
JeanGat
2 years, 7 months ago
Selected Answer: C
C, as per link
upvoted 1 times
...
supratip
2 years, 7 months ago
Selected Answer: C
Definitely C is correct - https://aws.amazon.com/blogs/database/cross-region-disaster-recovery-of-amazon-rds-for-sql-server/
upvoted 2 times
mawsman
2 years ago
Agree - Continuous replication To meet very aggressive RPO and RTO requirements, your DR strategy needs to consider continuous replication capability from your source RDS SQL Server to the target RDS SQL Server in your DR Region.
upvoted 1 times
...
...
mbar94
2 years, 7 months ago
Selected Answer: A
It's A.
upvoted 2 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