Microsoft Azure Data FundamentalsDescribe how to work with relational data on AzureMedium
A company is migrating an on-premises SQL Server database to Azure. The database contains sensitive customer information and requires high availability with automated failover capabilities. The company needs to minimize management overhead for patching and backups while retaining full SQL Server engine compatibility. Which Azure relational data service should they choose?
- AAzure SQL Database single database
- BAzure SQL Database Hyperscale
- CAzure SQL Managed Instance
- DSQL Server on Azure Virtual Machines
Show answer & explanationAnswer & explanation
Correct answer: C. Azure SQL Managed Instance
Azure SQL Managed Instance offers near 100% compatibility with the latest SQL Server (Enterprise Edition) database engine, combined with high availability and automated management, making it ideal for lift-and-shift migrations with minimal application changes.
Why the other options are wrong
- A. Azure SQL Database single database offers PaaS benefits but might not have the full SQL Server engine compatibility for all on-premises features.
- B. Azure SQL Database Hyperscale is for very large databases with high throughput, but the primary requirement is full SQL Server compatibility and managed instance features.
- D. SQL Server on Azure Virtual Machines requires significant management overhead for patching, backups, and high availability configuration, which the company wants to minimize.
Azure SQL Managed Instance
A fully managed, highly compatible SQL Server database engine service in Azure, designed for lift-and-shift migrations of on-premises SQL Server workloads to the cloud.
- Near 100% SQL Server compatibility.
- Automated backups, patching, and high availability.
- Offers a private network environment for enhanced security.
Memory trick: Managed Instance: On-prem's twin, managed in the cloud.