Microsoft Exam DP-300 Topic 12 Question 81 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 81
Topic #: 12

You have a Microsoft SQL Server 2019 instance in an on-premises datacenter. The instance contains a 4-TB database named DB1.

You plan to migrate DB1 to an Azure SQL Database managed instance.

What should you use to minimize downtime and data loss during the migration?

Adistributed availability groups

Bdatabase mirroring

Clog shipping

DDatabase Migration Assistant

Show Suggested Answer

Suggested Answer: C

by Pete at Dec 13, 2023, 10:25 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Regenia

3 days ago

Database mirroring? Really? That's an on-premises solution, not suitable for a cloud migration. *rolls eyes*

upvoted 0 times

...

Trevor

16 days ago

I was leaning towards the Always On Availability Group, but the question mentions migrating to an Azure SQL Database managed instance, so that wouldn't be the right choice.

upvoted 0 times

Harris

4 days ago

A) database mirroring

upvoted 0 times

...

Shalon

19 days ago

I'm not sure about that. I think we should consider using Always On Availability Group for better data protection.

upvoted 0 times

...

Dorcas

20 days ago

Hmm, I think Azure Database Migration Service is the way to go. It's specifically designed for migrations like this and should minimize downtime and data loss.

upvoted 0 times

...

Sueann

23 days ago

I agree with Zena. Azure Database Migration Service is the best option to minimize downtime and data loss.

upvoted 0 times

...

Zena

1 months ago

I think we should use Azure Database Migration Service for the migration.

upvoted 0 times

...