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

Microsoft Exam DP-300 Topic 12 Question 81 Discussion

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

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?

Show Suggested Answer Hide Answer
Suggested Answer: C

Contribute your Thoughts:

Evangelina
1 months ago
If I choose the wrong answer, I hope they at least give me partial credit for knowing what database mirroring is. *chuckles*
upvoted 0 times
...
Tarra
1 months ago
Distributed availability groups? That's a bit overkill for a single database migration, don't you think? I'm going with the Azure Database Migration Service.
upvoted 0 times
Aleta
30 days ago
Yeah, Azure Database Migration Service is the most efficient option for this scenario.
upvoted 0 times
...
Emile
1 months ago
I think Azure Database Migration Service is the way to go to minimize downtime and data loss.
upvoted 0 times
...
Elin
1 months ago
I agree, using distributed availability groups for a single database migration seems excessive.
upvoted 0 times
...
...
Regenia
2 months ago
Database mirroring? Really? That's an on-premises solution, not suitable for a cloud migration. *rolls eyes*
upvoted 0 times
Bette
17 days ago
D) Azure Database Migration Service
upvoted 0 times
...
Pearlie
18 days ago
C) Always On Availability Group
upvoted 0 times
...
Sophia
1 months ago
A) database mirroring
upvoted 0 times
...
...
Trevor
2 months 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
Jolene
1 months ago
D) Azure Database Migration Service
upvoted 0 times
...
Arlean
1 months ago
A) database mirroring
upvoted 0 times
...
Cecily
1 months ago
D) Azure Database Migration Service
upvoted 0 times
...
Harris
2 months ago
A) database mirroring
upvoted 0 times
...
...
Shalon
2 months 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
2 months 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
2 months ago
I agree with Zena. Azure Database Migration Service is the best option to minimize downtime and data loss.
upvoted 0 times
...
Zena
3 months ago
I think we should use Azure Database Migration Service for the migration.
upvoted 0 times
...

Save Cancel