Exam AZ-305 All QuestionsBrowse all questions from this exam
Go to Exam
Question 251

HOTSPOT

-

Your on-premises datacenter contains a server named Server1 that runs Microsoft SQL Server 2022. Server1 contains a 30-TB database named DB1 that stores customer data. Server1 runs a custom application named App1 that verifies the compliance of records in DB1. App1 must run on the same server as DB1.

You have an Azure subscription.

You need to migrate DB1 to Azure. The solution must minimize administrative effort.

To which service should you migrate DB1, and what should you use to perform the migration? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

    Correct Answer:

Discussion
bazylson

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.

bp_a_user

the link you posted says: Migrate (and/or upgrade) SQL Server to SQL Server on Azure VM -> azure migrate: NO

ann1730

Lift and shift SQL Server to SQL Server on Azure VM -> azure migrate : YES Because both application and database are migrating, Lift and shift SQL Server to SQL Server on Azure VM is correct.

arnitjoe

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

LGWJ12

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.

rumino

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

rumino

For migration Azure Database Migration Service https://learn.microsoft.com/en-us/azure/migrate/migrate-services-overview#integrated-tools Data Studio is only for Azure SQL migration not MI or VM SQL. (link from the original comment)

Lazylinux

Not correct read below 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).

xRiot007

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.

xRiot007

Thinking again, using the DMS might be more precise of a response, so that is more correct...

Crossfader2208

given answer is correct.

Superego

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.

ahmedkmj

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

Lazylinux

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

Lazylinux

Azure Migrate When to use - Discovery and assess single databases or at scale from different environments. Azure SQL Migration extension for Azure Data Studio when to use - Migrate single databases or at scale. - Offline mode only. Supported sources: - SQL Server (2008 onwards) on-premises, or on Azure Virtual Machines - SQL Server on Amazon EC2 - Amazon RDS for SQL Server - SQL Server on Google Compute Engine

MohsenSic

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

kodjoa2024

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