MENU
You have an on-premises datacenter that contains a 2-TB Microsoft SQL Server 2019 database named DB1.
You need to recommend a solution to migrate DB1 to an Azure SQL managed instance. The solution must minimize downtime and administrative effort.
What should you include in the recommendation?
Suggested Answer: B
Get Premium DP-300 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
12 comments · newest first
GR
Gregoria
11 months ago
Surprised LRS isn't the go-to for this scenario!
LO
Loise
11 months ago
Wait, isn't SQL Data Sync more for syncing than migrating?
DE
Delila
11 months ago
I agree, transactional replication minimizes downtime!
JO
Josefa
11 months ago
Log shipping seems too manual for this.
EV
Eva
12 months ago
I think transactional replication is the best option here.
TH
Thora
12 months ago
SQL Data Sync seems more suited for syncing data between databases rather than a full migration, right? I'm a bit confused about its use case here.
AL
Alpha
1 year ago
I feel like transactional replication is a good choice since it allows for near real-time data transfer, but I need to double-check the specifics.
MA
Maybelle
1 year ago
I think log shipping could work, but it seems like it might require more administrative effort than we want.
IS
Isabelle
1 year ago
I remember we discussed Log Replay Service in class, but I'm not entirely sure if it's the best option for minimizing downtime.
PA
Paulina
1 year ago
Okay, let me break this down. The Scrum Master is focused on the process and helping the team, while the Product Owner is responsible for the product vision and maximizing value. I'm going to go with A - Product Owner.
LO
Loren
1 year ago
I'm a little confused about the Standby License Manager. I'll have to review that part of the material again before answering.
EA
Earleen
1 year ago
Okay, let me break this down. If we're not selecting any group, that means we're not configuring any active configurations, right? So the equivalent would be selecting none of the groups. I'm going with B.