Migrate SQL Server Instances to Azure
Question
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?
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B. C. D. E.D
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.
https://docs.microsoft.com/en-us/azure/dms/resource-network-topologiesBased on the requirements listed in the question, the most suitable option for migrating the SQL Server instances to Azure is Azure SQL Database Managed Instance. Here is the detailed explanation:
A. SQL Server in a Docker container running on Azure Container Instances (ACI): This option does not provide native VNET integration with private IP addressing, and it does not support automatic patching and version updates to SQL Server.
B. SQL Server in Docker containers running on Azure Kubernetes Service (AKS): This option also does not provide native VNET integration with private IP addressing, and it does not support automatic patching and version updates to SQL Server. While AKS can provide high-availability, it requires additional setup and configuration.
C. SQL Server Infrastructure-as-a-Service (IaaS) virtual machine (VM): This option can provide all the required features, including native VNET integration with private IP addressing, automatic patching and version updates to SQL Server, automatic backup services, high-availability, and data encryption in transit. However, it requires more maintenance and management compared to a managed service.
D. Azure SQL Database Managed Instance: This option is a fully managed database service that provides all the required features, including automatic patching and version updates to SQL Server, automatic backup services, high-availability, native VNET integration with private IP addressing, and data encryption in transit. It also provides the benefit of scalability and reduced management overhead compared to an IaaS virtual machine.
E. Azure SQL Database with elastic pools: This option provides a fully managed database service with automatic patching and version updates to SQL Server, automatic backup services, native VNET integration with private IP addressing, and data encryption in transit. However, it does not provide high-availability or the ability to host multiple databases in a single instance, which is a requirement in the question.
In summary, based on the requirements listed in the question, Azure SQL Database Managed Instance is the most suitable option for migrating the SQL Server instances to Azure.
