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

- Free Preparation Discussions

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?

ALog Replay Service (LRS)

Blog shipping

Ctransactional replication

DSQL Data Sync

Show Suggested 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

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

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

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

Delpha

3 months ago

Log Replay Service (LRS) might be the best choice. It can help with minimal downtime and administrative effort.

upvoted 0 times

...

Justine

3 months ago

I agree, SQL Data Sync could be a good option. It automates the synchronization process.

upvoted 0 times

...

Lachelle

4 months ago

Transactional replication could also be a good choice. It allows for continuous data synchronization.

upvoted 0 times

...

Kirk

4 months ago

I think log shipping might be a better option. It can help minimize downtime.

upvoted 0 times

...

...

Brande

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

Joaquin

4 months ago

Log shipping does sound like a good choice. It's a proven method for database migration.

upvoted 0 times

...

Veronica

4 months ago

I think log shipping is the way to go as well. It's a reliable method for migrating databases.

upvoted 0 times

...

Levi

4 months ago

I agree, log shipping seems like the best option for minimizing downtime and effort.

upvoted 0 times

...

...

France

5 months ago

Transactional replication could also be a good option to consider for the migration.

upvoted 0 times

...

Rebecka

5 months ago

I agree, log shipping can help minimize downtime and administrative effort.

upvoted 0 times

...

Madonna

5 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

Talia

4 months ago

Great, let's go with transactional replication for the migration.

upvoted 0 times

...

Merilyn

4 months ago

I've used it before and it worked like a charm.

upvoted 0 times

...

Gregoria

5 months ago

I agree, transactional replication is the way to go.

upvoted 0 times

...

Glendora

5 months ago

It's definitely the best option for minimizing downtime.

upvoted 0 times

...

...

Fletcher

5 months ago

I think we should go with log shipping for the migration.

upvoted 0 times

...