Microsoft Exam AZ-305 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?

ASQL Server Migration Assistant (SSMA)

BAzure Migrate

CData Migration Assistant (DMA)

DAzure Database Migration Service

Show Suggested 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:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!