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 12 Question 81 Discussion

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?
C) log shipping
A) distributed availability groups
B) database mirroring
D) Database Migration Assistant

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

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:

0/2000 characters
Submit Cancel
Wava
8 months ago
I agree, minimizing data loss is crucial, so I’d stick with A!
upvoted 0 times
...
Janna
8 months ago
Wait, can you really use distributed availability groups for this? Sounds complicated!
upvoted 0 times
...
Van
9 months ago
Database Migration Assistant is great for assessments, but not for live migrations.
upvoted 0 times
...
Eve
9 months ago
I think log shipping could work too, but not as efficient.
upvoted 0 times
...
Ozell
9 months ago
Distributed availability groups are the way to go for minimizing downtime!
upvoted 0 times
...
Dusti
9 months ago
I have a feeling database mirroring could help, but I’m not confident if it’s the best option for this scenario.
upvoted 0 times
...
Julene
9 months ago
I practiced a similar question where Database Migration Assistant was mentioned, but I think it’s more for assessment than actual migration.
upvoted 0 times
...
Lindsey
9 months ago
I’m not entirely sure, but I feel like log shipping could work too, though it might not be the best for minimizing downtime.
upvoted 0 times
...
Willetta
10 months ago
I remember studying about minimizing downtime, and I think distributed availability groups might be the right choice for that.
upvoted 0 times
...
Gwenn
10 months ago
The Database Migration Assistant sounds like a good tool to use. It's probably the easiest and most straightforward option.
upvoted 0 times
...
Zachary
10 months ago
I'm a bit confused on the differences between these options. I'll need to review the details of each one to decide which is best.
upvoted 0 times
...
Raelene
10 months ago
I'm pretty sure database mirroring is the way to go here. It should help minimize downtime and data loss during the migration.
upvoted 0 times
...
Mariann
10 months ago
Hmm, this looks like a tricky one. I'll need to think carefully about the pros and cons of each option.
upvoted 0 times
...
Candra
10 months ago
I'm a little unsure about this one. I know NIST SP 800-53A is an important security standard, but I can't recall the exact types of assessment tests it addresses. I'll have to think this through carefully.
upvoted 0 times
...
Vinnie
10 months ago
I'm leaning towards option C. The question mentions "testing purposes", so that seems like the key focus of when to use this property.
upvoted 0 times
...
Roosevelt
10 months ago
I think I remember learning about using ASCII for key inputs as a potential fix. But I doubt it relates to policies not applying correctly.
upvoted 0 times
...
Chuck
10 months ago
Hmm, I'm a bit unsure on this one. I know NIPS and HIPS are intrusion prevention systems, but I can't quite remember the difference between NIDS and HIDS. I'll have to think this through carefully.
upvoted 0 times
...
Gianna
10 months ago
This is a tricky one. There are a few different scientific fields that could potentially be involved in studying the connection between a volcanic eruption and a tidal wave. I'll need to weigh the options carefully and try to determine which type of scientist would have the most direct expertise in that specific phenomenon.
upvoted 0 times
...
Olive
10 months ago
The command mentions "process" and "statistics", so I'm guessing the answer is WMIC. That seems like the right tool for this type of task.
upvoted 0 times
...
Evangelina
1 year 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 year 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
1 year ago
Yeah, Azure Database Migration Service is the most efficient option for this scenario.
upvoted 0 times
...
Emile
1 year ago
I think Azure Database Migration Service is the way to go to minimize downtime and data loss.
upvoted 0 times
...
Elin
1 year ago
I agree, using distributed availability groups for a single database migration seems excessive.
upvoted 0 times
...
...
Regenia
1 year ago
Database mirroring? Really? That's an on-premises solution, not suitable for a cloud migration. *rolls eyes*
upvoted 0 times
Bette
1 year ago
D) Azure Database Migration Service
upvoted 0 times
...
Pearlie
1 year ago
C) Always On Availability Group
upvoted 0 times
...
Sophia
1 year ago
A) database mirroring
upvoted 0 times
...
...
Trevor
1 year 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 year ago
D) Azure Database Migration Service
upvoted 0 times
...
Arlean
1 year ago
A) database mirroring
upvoted 0 times
...
Cecily
1 year ago
D) Azure Database Migration Service
upvoted 0 times
...
Harris
1 year ago
A) database mirroring
upvoted 0 times
...
...
Shalon
1 year 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
1 year 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
1 year ago
I agree with Zena. Azure Database Migration Service is the best option to minimize downtime and data loss.
upvoted 0 times
...
Zena
1 year ago
I think we should use Azure Database Migration Service for the migration.
upvoted 0 times
...

Save Cancel