MENU
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?
Suggested Answer: A
Get Premium DP-300 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
11 comments · newest first
WI
William
11 months ago
Wait, can we really trust Always On for this? Seems a bit risky.
JE
Jeannetta
11 months ago
Database Migration Assistant sounds like the safest bet!
AR
Aracelis
12 months ago
Backup and Restore is too risky for data loss, right?
HU
Huey
12 months ago
I think log shipping could work too, but it might not be the best choice here.
AI
Ailene
1 year ago
Always On availability groups are great for minimizing downtime!
LE
Lemuel
1 year ago
Backup and Restore is a common method, but I feel like it might lead to more downtime than the other options.
DE
Denae
1 year ago
The Database Migration Assistant sounds familiar, but I'm not confident it can handle minimizing downtime effectively.
CH
Chanel
1 year ago
I remember practicing with Always On availability groups, and they seem like a solid option for high availability during migrations.
CH
Chantell
1 year ago
I think log shipping might be too slow for minimizing downtime, but I'm not entirely sure.
OR
Orville
1 year 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.
FE
Felix
1 year 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.