Home / Microsoft / AZ-301 / Question 177

You deploy Azure App Service Web Apps that connect to on-premises Microsoft SQL Server instances by using Azure ExpressRoute. You plan to migrate the

SQL Server instances to Azure.

Migration of the SQL Server instances to Azure must:

Support automatic patching and version updates to SQL Server.

Provide automatic backup services.

Allow for high-availability of the instances.

Provide a native VNET with private IP addressing.

Encrypt all data in transit.

Be in a single-tenant environment with dedicated underlying infrastructure (compute, storage)

You need to migrate the SQL Server instances to Azure.

Which Azure service should you use?

• A. Azure SQL Database with elastic pools

• B. SQL Server in Docker containers running on Azure Kubernetes Service (AKS)

• C. SQL Server Infrastructure-as-a-Service (IaaS) virtual machine (VM)

• D. SQL Server in a Docker container running on Azure Container Instances (ACI)

• E. Azure SQL Database Managed Instance

Azure SQL Database Managed Instance configured for Hybrid workloads. Use this topology if your Azure SQL Database Managed Instance is connected to your on-premises network. This approach provides the most simplified network routing and yields maximum data throughput during the migration.

Network topologies for Azure SQL Managed Instance migrations using Azure Database Migration Service