DP-300 Question #441: Real Exam Question with Answer & Explanation

Question

You have eight on-premises servers that have Microsoft SQL Server 2022 installed. Each server contains multiple databases. You plan to migrate the on-premises databases to Azure. You need to analyze the servers to identify which Azure SQL services can be used to host the databases. Which two tools can you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Options

• AData Migration Assistant (DMA)
• BSQL Server Migration Assistant (SSMA)
• CAzure Database Migration Service
• DAzure Migrate
• EDatabase Experimentation Assistant (DEA)

Explanation

[A] The Data Migration Assistant (DMA) can be used to identify which Azure SQL services are suitable for hosting your databases when migrating from SQL Server 2022 to Azure. DMA assesses your on-premises SQL Server databases and provides recommendations on whether they are compatible with Azure SQL Database or Azure SQL Managed Instance. It identifies potential migration blockers and compatibility issues, helping you choose the appropriate Azure [D] Azure Migrate can be used to identify which Azure SQL services are suitable for hosting your migrated databases. It assesses on-premises SQL Server databases for migration readiness, providing recommendations on target Azure SQL service options like Azure SQL Database (single database or elastic pool), Azure SQL Managed Instance, and SQL Server on Azure VMs. Azure Migrate also helps with performance-based sizing and cost estimations for running the databases in Azure. https://learn.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver17 https://learn.microsoft.com/en-us/data-migration/sql-server/database/guide

No community discussion yet for this question.