Which Azure service should you use?

Your 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 . SQL Server Infrastructure-as-a-Service (laaS) virtual machine (VM)
B . Azure SQL Database with elastic pools
C . SQL Server in a Docker container running on Azure Container Instances (ACI)
D . Azure SQL Database Managed Instance
E . SQL Server in Docker containers running on Azure Kubermetes Service (AKS)

View Answer

Answer: D

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