MENU
You have an on-premises Microsoft SQL server named SQLI that hosts 50 databases.
You plan to migrate SQL 1 to Azure SQL Managed Instance.
You need to perform an offline migration of SQL 1. The solution must minimize administrative effort.
What should you include in the solution?
Suggested Answer: D
Get Premium AZ-305 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
This Azure service supports migration in the offline mode for applications that can afford downtime during the migration process. Unlike the continuous migration in online mode, offline mode migration runs a one-time restore of a full database backup from the source to the target
13 comments · newest first
CH
Chaya
11 months ago
Azure Migrate? Really? I thought that was for assessments, not migrations.
JA
Jani
11 months ago
SSMA is good, but I feel like it might not minimize effort as much.
EL
Elke
12 months ago
Wait, isn't Data Migration Assistant better for offline migrations?
KA
Katina
12 months ago
Definitely agree, it simplifies the process a lot!
DO
Dortha
1 year ago
I think Azure Database Migration Service is the best choice here.
SI
Simona
1 year ago
Azure Migrate seems more focused on assessments rather than the actual migration process, right? I’m a bit confused about that.
DO
Dominque
1 year ago
I feel like SSMA could be useful, but I can't recall if it specifically handles the offline aspect we're looking for.
TR
Troy
1 year ago
I remember practicing with the Data Migration Assistant, but I don't think it supports offline migrations.
FR
Freeman
1 year ago
I think we might need to use the Azure Database Migration Service for this, but I'm not entirely sure if it's the best option for offline migrations.
OC
Octavio
1 year ago
Hmm, I'm a bit unsure about this one. I think B and C might be the ones with errors, but I'll need to double-check the syntax rules for float and double declarations.
LA
Lajuana
1 year ago
Okay, the question is asking about limiting MFA factor type enrollment, so I'm guessing the answer has to do with that. Let me re-read the options carefully.
OM
Omega
1 year ago
I think the Cisco FMC is the right choice since it provides centralized management for FTDs, but I'm not totally sure.
GE
Gerald
1 year ago
Okay, I think I've got it. The weight of ecs_inst1 is set to 100, so it should receive the majority of the traffic, but I'm not sure of the exact percentage.