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?
Click on the arrows to vote for the correct answer
A. B. C. D. E.E
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 mentioned, the Azure service that best meets the needs of migrating SQL Server instances to Azure is "Azure SQL Database Managed Instance" (Option E).
Azure SQL Database Managed Instance is a fully managed database service provided by Microsoft that is built on top of SQL Server technology. It offers a PaaS (Platform as a Service) solution, which means that the underlying infrastructure (compute, storage, and networking) is managed by Microsoft.
Here's how Azure SQL Database Managed Instance satisfies the given requirements:
Support automatic patching and version updates to SQL Server: Azure SQL Database Managed Instance offers automated patching and version updates to the SQL Server engine, which ensures that the database is always up-to-date with the latest security and feature updates.
Provide automatic backup services: Azure SQL Database Managed Instance provides automatic backups and point-in-time restore capabilities, which can be configured with retention periods of up to 35 days.
Allow for high-availability of the instances: Azure SQL Database Managed Instance offers high-availability options, such as zone redundancy, that ensure the database is always available, even in the event of a hardware or software failure.
Provide a native VNET with private IP addressing: Azure SQL Database Managed Instance supports VNET integration, which allows you to create a private endpoint within your VNET and access the database through a private IP address.
Encrypt all data in transit: Azure SQL Database Managed Instance supports encryption at rest and in transit. It uses Transparent Data Encryption (TDE) to encrypt data at rest and SSL/TLS to encrypt data in transit.
Be in a single-tenant environment with dedicated underlying infrastructure (compute, storage): Azure SQL Database Managed Instance provides a dedicated instance of the SQL Server engine that is isolated from other tenants. The underlying compute and storage resources are also dedicated to the instance.
In conclusion, based on the given requirements, Azure SQL Database Managed Instance is the most suitable option for migrating SQL Server instances to Azure.