Exam AZ-305 topic 4 question 117 discussion

Its SQL on Azure VM and Azure Migrate. Since the existing server has a custom app that must be installed on the local DB server and SQL is already SQL 2022 there is no need to do anything other than lift and shift. With that Azure Migrate to simply move the VM to Azure. Minimal Admin effort. https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/virtual-machines/sql-server-to-sql-on-azure-vm-migration-overview?view=azuresql

According to this: https://learn.microsoft.com/en-us/sql/sql-server/migrate/dma-azure-migrate-compare-migration-tools?view=sql-server-ver16#quick-comparison only Azure Migrate & DMA can handle a SQL Server migration to Azure VM. Since DMA option is not available, only Azure Migrate remains.

I think I will choose Azure migrate for the extra support in sizing and so on. Although, to be clear, Azure migrate uses DMS to do the actual migration and so does the the Azure data studio plugin.

Migrate to: SQL Server on Azure Virtual Machines By using: Azure Migrate Explanation: SQL Server on Azure Virtual Machines: App1 Requirement: This option allows you to migrate Server1 (with App1 and DB1) as a virtual machine to Azure. This ensures that App1 and DB1 remain on the same server, fulfilling the requirement. Flexibility: You have full control over the VM configuration and can customize it to meet your specific needs. Azure Migrate: Simplified Migration: Azure Migrate simplifies the migration process by assessing the on-premises server, creating a migration plan, and executing the migration. Minimal Downtime: The migration can be performed with minimal downtime, allowing for a seamless transition to Azure.

SQL Server on Azure Virtual Machines Azure Migrate

Seems like box 2 all answers are correct: - Azure migrate contains DMS - DMS offers two versions, "DMS classic" and "DMS via Azure SQL migration extension for Azure Data Studio" https://learn.microsoft.com/en-us/azure/dms/dms-overview

This question appeared in the exam, August 2024. I gave this same answer for Box 1 as listed here (SQL on Azure VM) and for Box 2 I answered Azure Migrate (because there's an App to migrate which must exist on the same VM). I scored 870

For box 2: Azure Migrate. According to the doc https://learn.microsoft.com/en-us/azure/dms/dms-overview which says: With Azure Database Migration Service currently we offer two versions: 1. Database Migration Service - via Azure SQL migration extension for Azure Data Studio, Azure portal, PowerShell and Azure CLI. It seems Azure SQL migration extension for Azure Data Studio is exactly the Database Migration Service. So both are eliminated.

Agree with first box answer correct because of the App tied to the DB and hence SQL VM but Second box i would chose AZ SQL Migration Extension for AZ Data Studio as per below snippet from MS Doco The Azure SQL migration extension for Azure Data Studio provides a seamless wizard based experience to assess, get Azure recommendations and migrate your SQL Server databases on-premises to SQL Server on Azure Virtual Machines. Besides, highlighting any migration blockers or warnings, the extension also includes an option for Azure recommendations to collect your databases' performance data to recommend a right-sized Azure SQL Managed Instance to meet the performance needs of your workload (with the least price). Follow below

SQL Server on Azure Virtual Machines and Azure Database Migration Service. Given the requirement that the custom application App1 must run on the same server as DB1, the best option is SQL Server on Azure Virtual Machines. For the migration process, you should use Azure Database Migration Service because the Azure SQL Migration extension for Azure Data Studio is more suited for migrating to Azure SQL Database or Azure SQL Managed Instance and not to SQL server on Azure virtual machine.

Sql database tier and DMS, 30Tb is only supported by databsetier

for the second question it sound for me Azure Migrate because there also app to migrate.

I would say also it should be Azure SQL migration extension for Azure Data Studio, according to Microsoft recommendations https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/virtual-machines/sql-server-to-sql-on-azure-vm-migration-overview?view=azuresql

The first choice is easy, obviously we need VM to install additional app. Regarding the second, I'd go for SQL Migration extension for Azure Data Studio. It seems to be all-in-one easy to use tool. https://learn.microsoft.com/en-us/azure-data-studio/extensions/azure-sql-migration-extension?tabs=connected

The second box is slightly ambiguous. Bot Azure Migrate and Azure Database Migration Service are correct. This is because the service sits inside the context of Azure Migrate.

given answer is correct.