New Year Sale 2026! 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 AZ-305 Exam - Topic 3 Question 28 Discussion

Actual exam question for Microsoft's AZ-305 exam
Question #: 28
Topic #: 3
[All AZ-305 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: D

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

https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/managed-instance/sql-server-to-managed-instance-overview?view=azuresql#compare-migration-options


by Felicidad at Oct 14, 2022, 07:33 PM

Limited Time Offer

25%

Off

Get Premium AZ-305 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Chaya
4 months ago
Azure Migrate? Really? I thought that was for assessments, not migrations.
upvoted 0 times
...
Jani
4 months ago
SSMA is good, but I feel like it might not minimize effort as much.
upvoted 0 times
...
Elke
4 months ago
Wait, isn't Data Migration Assistant better for offline migrations?
upvoted 0 times
...
Katina
4 months ago
Definitely agree, it simplifies the process a lot!
upvoted 0 times
...
Dortha
5 months ago
I think Azure Database Migration Service is the best choice here.
upvoted 0 times
...
Simona
5 months ago
Azure Migrate seems more focused on assessments rather than the actual migration process, right? I’m a bit confused about that.
upvoted 0 times
...
Dominque
5 months ago
I feel like SSMA could be useful, but I can't recall if it specifically handles the offline aspect we're looking for.
upvoted 0 times
...
Troy
5 months ago
I remember practicing with the Data Migration Assistant, but I don't think it supports offline migrations.
upvoted 0 times
...
Freeman
5 months 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.
upvoted 0 times
...
Octavio
5 months 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.
upvoted 0 times
...
Lajuana
5 months 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.
upvoted 0 times
...
Omega
5 months ago
I think the Cisco FMC is the right choice since it provides centralized management for FTDs, but I'm not totally sure.
upvoted 0 times
...
Gerald
5 months 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.
upvoted 0 times
...

Save Cancel