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
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-300 Exam - Topic 5 Question 83 Discussion

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?
C) transactional
A) peer-to-pec
B) merge
D) snapshot

Microsoft DP-300 Exam - 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

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:

0/2000 characters
Submit Cancel
Tricia
8 months ago
Agreed, transactional is the best choice for real-time updates!
upvoted 0 times
...
Wilburn
8 months ago
Wait, can you really use merge replication here? Seems off.
upvoted 0 times
...
William
8 months ago
Definitely transactional, it’s more efficient for ongoing changes.
upvoted 0 times
...
Robt
9 months ago
I thought snapshot replication could work too?
upvoted 0 times
...
Angelo
9 months ago
Transactional replication is the way to go for this!
upvoted 0 times
...
Erick
9 months ago
I’m a bit confused about peer-to-peer replication. I don’t recall it being mentioned in our study materials, so I’m leaning towards transactional as well.
upvoted 0 times
...
Maryann
9 months ago
Snapshot replication could be an option, but it’s not ideal for real-time data. I feel like transactional is the way to go for this question.
upvoted 0 times
...
Kristeen
9 months ago
I remember practicing with merge replication, but I don't think that's the right choice here. It seems more suited for scenarios where changes happen at multiple sites.
upvoted 0 times
...
Vivan
10 months ago
I think we might need to use transactional replication since it’s designed for high-volume environments, but I'm not entirely sure.
upvoted 0 times
...
Shonda
10 months ago
I'm a bit confused on the differences between the replication types. I'll need to review the details before answering this one.
upvoted 0 times
...
Buddy
10 months ago
Transactional replication sounds like the most appropriate option here, as we're replicating an on-premises database to a cloud-based one. I'll go with that.
upvoted 0 times
...
Krystina
10 months ago
Hmm, I'm a bit unsure about the different types of replication here. I'll need to think this through carefully.
upvoted 0 times
...
Gregg
10 months ago
This looks like a straightforward question on SQL Server replication. I think I can handle this one.
upvoted 0 times
...
Bobbye
10 months ago
Okay, let's see. We need to replicate an on-premises SQL Server database to an Azure SQL database. I'm guessing transactional replication might be the way to go.
upvoted 0 times
...
Corrina
10 months ago
I'm feeling a bit lost on this one. The options all seem like they could potentially impact the transfer of training. I'll have to review my notes and try to remember the key factors that influence it. Hopefully, I can narrow it down from there.
upvoted 0 times
...
Marcos
10 months ago
Hmm, I'm a bit confused by the "Overheads" expenditure type being excluded from the cost bases. I'll need to make sure I understand how that impacts the burden calculation.
upvoted 0 times
...
Carmen
2 years 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
2 years 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
2 years ago
D) Snapshot replication is not suitable in this case.
upvoted 0 times
...
Rodolfo
2 years ago
C) Transactional replication is the correct option for replicating DB1 to SQLDB1.
upvoted 0 times
...
Trinidad
2 years ago
B) Merge replication is not the best choice here.
upvoted 0 times
...
Rikki
2 years ago
A) peer-to-peer replication won't work for this scenario.
upvoted 0 times
...
...
Kara
2 years 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
2 years 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
2 years 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