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?

Apeer-to-pec

Bmerge

Ctransactional

Dsnapshot

Show Suggested Answer

Suggested Answer: C

by Meaghan at Jan 22, 2024, 11:32 PM

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Carmen

2 days 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

...

Kara

3 days 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

4 days 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

5 days 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

...