Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam DP-300 Topic 5 Question 83 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 83
Topic #: 5
[All DP-300 Questions]

You have an on-premises Microsoft SQL Server 2019 instance that hosts a database named DB1.

You have an Azure subscription that contains an Azure SQL database named SQLDB1.

You need to replicate DB1 to SQlDC1.

Which type of replication should you use?

Show Suggested Answer Hide Answer
Suggested Answer: C

Contribute your Thoughts:

Carmen
11 months ago
Exactly, can't risk it on the exam. Transactional replication is the way to go here. Let's lock that in as our final answer.
upvoted 0 times
Lyndia
11 months ago
Exactly, can't risk it on the exam. Transactional replication is the way to go here. Let's lock that in as our final answer.
upvoted 0 times
...
Josefa
11 months ago
D) Snapshot replication is not suitable in this case.
upvoted 0 times
...
Rodolfo
11 months ago
C) Transactional replication is the correct option for replicating DB1 to SQLDB1.
upvoted 0 times
...
Trinidad
11 months ago
B) Merge replication is not the best choice here.
upvoted 0 times
...
Rikki
11 months ago
A) peer-to-peer replication won't work for this scenario.
upvoted 0 times
...
...
Kara
11 months ago
Haha, yeah, I can just picture the exam proctors being like, 'No, no, you were supposed to choose transactional replication! No partial credit for you!' *laughs*
upvoted 0 times
...
Dorathy
11 months ago
True, but in this case, I think the question is asking for the best solution, and transactional replication seems to be the more robust and feature-rich approach. Can't go wrong with that.
upvoted 0 times
...
Carmela
11 months ago
Hmm, I don't know. Snapshot replication might be worth considering too. It's simpler to set up and could be a good option if we don't need the data to be synced in real-time.
upvoted 0 times
...

Save Cancel