Hotspot Question 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…

Question

Exhibit

Answer Area

• Migrate to:
  Azure SQL DatabaseAzure SQL Managed InstanceSQL Server on Azure Virtual Machines
• By using:
  Azure Database Migration ServiceAzure MigrateThe Azure SQL Migration extension for Azure Data Studio

Explanation

This question tests knowledge of migrating a large SQL Server database to Azure while satisfying a constraint that a custom application must run on the same server as the database, with minimal administrative effort.

Approach. Because App1 must run on the same server as DB1, a PaaS service like Azure SQL Database or Azure SQL Managed Instance is not suitable - those services do not allow you to install custom applications on the underlying server. Therefore, DB1 should be migrated to SQL Server on Azure Virtual Machines (SQL Server IaaS), which allows both the database and App1 to reside on the same VM. For the migration itself, Azure Database Migration Service (Azure DMS) is the correct tool, as it supports large-scale, online migrations from on-premises SQL Server to SQL Server on Azure VMs with minimal administrative effort and minimal downtime. DMS handles the heavy lifting of moving a 30-TB database efficiently without requiring manual backup/restore scripting.

Concept tested. Understanding when to use SQL Server on Azure VMs versus PaaS options (Azure SQL DB, SQL Managed Instance), and knowing that Azure Database Migration Service (DMS) is the recommended tool for minimizing administrative effort during large-scale SQL Server migrations to Azure.

Reference. https://learn.microsoft.com/en-us/azure/dms/tutorial-sql-server-to-virtual-machine-online-ads

No community discussion yet for this question.