ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 166 - AZ-305 discussion

Report
Export

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?

A.
SQL Server Migration Assistant (SSMA)
Answers
A.
SQL Server Migration Assistant (SSMA)
B.
Azure Migrate
Answers
B.
Azure Migrate
C.
Data Migration Assistant (DMA)
Answers
C.
Data Migration Assistant (DMA)
D.
Azure Database Migration Service
Answers
D.
Azure Database Migration Service
Suggested answer: D

Explanation:

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-serverto-managed-instance-overview?view=azuresql#compare-migration-options

asked 02/10/2024
Naeem Navaid Shaikh
38 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first