Which Azure service should you use?

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

View Answer

Answer: E

Explanation:

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.

Reference:

https://docs.microsoft.com/en-us/azure/dms/resource-network-topologies