exam questions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

Exam AZ-305 topic 4 question 104 discussion

Actual exam question from Microsoft's AZ-305
Question #: 104
Topic #: 4
[All AZ-305 Questions]

You have an on-premises Microsoft SQL server named SQL1 that hosts 50 databases.

You plan to migrate SQL1 to Azure SQL Managed Instance.

You need to perform an offline migration of SQL1. The solution must minimize administrative effort.

What should you include in the solution?

  • A. Azure Migrate
  • B. Azure Database Migration Service
  • C. SQL Server Migration Assistant (SSMA)
  • D. Data Migration Assistant (DMA)
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
NotMeAnyWay
Highly Voted 1 year, 4 months ago
Selected Answer: B
The best solution for this scenario is: B. Azure Database Migration Service Azure Database Migration Service is a tool that helps you simplify, guide, and automate your database migration to Azure. Specifically for SQL Server to Azure SQL Managed Instance migrations, it provides an option for offline (one-time) migrations which is suitable for your scenario. The Data Migration Assistant (DMA) tool can be used beforehand to assess your SQL Server databases for any feature parity and compatibility issues that could impact the database functionality in Azure SQL Managed Instance. Azure Migrate is a service that helps you assess and migrate applications, infrastructure, and data, but it doesn't specifically cater to SQL Server migrations. SQL Server Migration Assistant (SSMA) is more suited for migrations to Azure SQL Database and does not support Azure SQL Managed Instance.
upvoted 25 times
acconl100
1 year, 4 months ago
Thanks NotMeAnyWay, can you share me all the question of this dump. I don't know but I cannot see some Questions ...
upvoted 1 times
...
...
husam421
Highly Voted 1 year, 2 months ago
Azure Database Migration Service (classic) - SQL scenarios are on a deprecation path. Since August 1, 2023, you're no longer able to create new Database Migration Service (classic) resources for SQL Server scenarios from Azure portal. The service will be retired on March 15, 2026 for all customers. You can migrate to Azure SQL Database using the latest version of Azure Database Migration Service, which is available as an extension in Azure Data Studio, or by using Azure PowerShell and Azure CLI. For more information, see Retirement notice: Database Migration Service (classic).
upvoted 6 times
...
SeMo0o0o0o
Most Recent 3 weeks ago
Selected Answer: B
B is correct
upvoted 1 times
...
Azure2020
7 months, 2 weeks ago
Selected Answer: B
DMA is needed if you want to assess before migration with DMS. Alternatively, if you use the Azure SQL Migration extension in Azure Data Studio, you can run assessments and migrations in a single place. The Data Migration Assistant provides seamless assessments of SQL Server on-premises and upgrades to later versions of SQL Server or migrations to SQL Server on Azure VMs or Azure SQL Database. It also help you helps you upgrade to a modern data platform by detecting compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL Database.
upvoted 1 times
...
Azure2020
7 months, 2 weeks ago
DMA is needed if you want to assess before migration with DMS. Alternatively, if you use the Azure SQL Migration extension in Azure Data Studio, you can run assessments and migrations in a single place. The Data Migration Assistant provides seamless assessments of SQL Server on-premises and upgrades to later versions of SQL Server or migrations to SQL Server on Azure VMs or Azure SQL Database. It also help you helps you upgrade to a modern data platform by detecting compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL Database.
upvoted 2 times
...
Lazylinux
7 months, 2 weeks ago
Selected Answer: B
Given answer B is correct, Considering MS have so many tools and features it is more confusing than ever, i found great link that compare the 3 answers BCD hope it helps https://techcommunity.microsoft.com/t5/microsoft-data-migration-blog/differentiating-microsoft-s-database-migration-tools-and/ba-p/368529
upvoted 3 times
...
rumino
9 months ago
Selected Answer: B
Use the Database Migration Service in the following scenarios: Migrate both databases to Azure SQL, especially at scale, and for extensive (in terms of number and size of databases) migrations. Migrate databases to Azure Database. https://learn.microsoft.com/en-us/sql/sql-server/migrate/dma-azure-migrate-compare-migration-tools?view=sql-server-ver16#quick-compariso
upvoted 1 times
...
husam421
1 year, 2 months ago
Selected Answer: D
https://learn.microsoft.com/en-us/sql/sql-server/migrate/dma-azure-migrate-compare-migration-tools?view=sql-server-ver16#quick-comparison
upvoted 1 times
seong
1 year ago
DMA does not support database migrations to Azure SQL Managed Instance. Use the Azure SQL migration extension for Azure Data Studio instead, which supports both online and offline database migrations to Azure SQL Managed Instance. https://learn.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver16
upvoted 2 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...