BlackFriday 2024! 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 Exam DP-300 Topic 11 Question 102 Discussion

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

You have an on-premises datacenter that contains a 2-TB Microsoft SQL Server 2019 database named DB1.

You need to recommend a solution to migrate DB1 to an Azure SQL managed instance. The solution must minimize downtime and administrative effort.

What should you include in the recommendation?

Show Suggested Answer Hide Answer
Suggested Answer: B

by Ammie at Sep 17, 2024, 04:44 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel
Myrtie
11 days ago
I'm voting for C - transactional replication. It's the most reliable way to ensure data integrity during the migration. Plus, it sounds like something a real SQL expert would recommend.
upvoted 0 times
...
Cristy
12 days ago
Ha! I bet the answer is A - Log Replay Service. That's the kind of obscure option they love to throw in these exams just to trip you up.
upvoted 0 times
...
Louvenia
13 days ago
Hmm, I'm not sure. This is a tough one. Maybe D - SQL Data Sync would be a good choice? It seems like it would be more automated and less manual effort.
upvoted 0 times
Kirk
5 days ago
I think log shipping might be a better option. It can help minimize downtime.
upvoted 0 times
...
...
Brande
28 days ago
I don't know, I think B - log shipping might be a better option. It's more straightforward and you can monitor the process more closely.
upvoted 0 times
Levi
13 days ago
I agree, log shipping seems like the best option for minimizing downtime and effort.
upvoted 0 times
...
...
France
30 days ago
Transactional replication could also be a good option to consider for the migration.
upvoted 0 times
...
Rebecka
1 months ago
I agree, log shipping can help minimize downtime and administrative effort.
upvoted 0 times
...
Madonna
1 months ago
Definitely go with C - transactional replication. That's the best way to minimize downtime and keep the data in sync during the migration.
upvoted 0 times
Merilyn
15 days ago
I've used it before and it worked like a charm.
upvoted 0 times
...
Gregoria
26 days ago
I agree, transactional replication is the way to go.
upvoted 0 times
...
Glendora
26 days ago
It's definitely the best option for minimizing downtime.
upvoted 0 times
...
...
Fletcher
1 months ago
I think we should go with log shipping for the migration.
upvoted 0 times
...

Save Cancel