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 AZ-305 Exam - Topic 3 Question 28 Discussion

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?
D) Azure Database Migration Service
A) SQL Server Migration Assistant (SSMA)
B) Azure Migrate
C) Data Migration Assistant (DMA)

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
10 months ago
Azure Migrate? Really? I thought that was for assessments, not migrations.
upvoted 0 times
...
Jani
10 months ago
SSMA is good, but I feel like it might not minimize effort as much.
upvoted 0 times
...
Elke
10 months ago
Wait, isn't Data Migration Assistant better for offline migrations?
upvoted 0 times
...
Katina
10 months ago
Definitely agree, it simplifies the process a lot!
upvoted 0 times
...
Dortha
10 months ago
I think Azure Database Migration Service is the best choice here.
upvoted 0 times
...
Simona
11 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
11 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
11 months ago
I remember practicing with the Data Migration Assistant, but I don't think it supports offline migrations.
upvoted 0 times
...
Freeman
11 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
11 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
11 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
11 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
11 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