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 9 Question 58 Discussion

You have a on-premises Microsoft SQL Server named SQL1 that hosts five databases.You need to migrate the databases to an Azure SQL managed instance. The solution must minimize downtime and prevent data loss.What should you use?
A) log shipping
B) Always On availability groups
C) Database Migration Assistant
D) Backup and Restore

Microsoft DP-300 Exam - Topic 9 Question 58 Discussion

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

You have a on-premises Microsoft SQL Server named SQL1 that hosts five databases.

You need to migrate the databases to an Azure SQL managed instance. The solution must minimize downtime and prevent data loss.

What should you use?

Show Suggested Answer Hide Answer
Suggested Answer: A

by Leatha at Aug 01, 2022, 02:59 AM

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
William
7 months ago
Wait, can we really trust Always On for this? Seems a bit risky.
upvoted 0 times
...
Jeannetta
7 months ago
Database Migration Assistant sounds like the safest bet!
upvoted 0 times
...
Aracelis
7 months ago
Backup and Restore is too risky for data loss, right?
upvoted 0 times
...
Huey
8 months ago
I think log shipping could work too, but it might not be the best choice here.
upvoted 0 times
...
Ailene
8 months ago
Always On availability groups are great for minimizing downtime!
upvoted 0 times
...
Lemuel
8 months ago
Backup and Restore is a common method, but I feel like it might lead to more downtime than the other options.
upvoted 0 times
...
Denae
8 months ago
The Database Migration Assistant sounds familiar, but I'm not confident it can handle minimizing downtime effectively.
upvoted 0 times
...
Chanel
8 months ago
I remember practicing with Always On availability groups, and they seem like a solid option for high availability during migrations.
upvoted 0 times
...
Chantell
8 months ago
I think log shipping might be too slow for minimizing downtime, but I'm not entirely sure.
upvoted 0 times
...
Orville
8 months ago
Okay, I think I've got this. The APEC framework is more of a voluntary, non-binding set of guidelines, while the EU Directive mandates specific legal requirements for member countries. That's likely the key distinction.
upvoted 0 times
...
Felix
8 months ago
Okay, I think I've got this. The key is to join the two DataFrames on the 'transactionId' column, and since itemsDf is much smaller, I should broadcast it to optimize the query. I'm pretty confident option C is the correct answer.
upvoted 0 times
...

Save Cancel