An organization is planning the migration of an on-premises database to Azure. The database currently supports a critical business application and has the following requirements:
- It must support SQL Server Agent for scheduled T-SQL maintenance jobs.
- It must allow cross-database queries using three-part names across multiple databases.
- The deployment must reside within a delegated subnet of an Azure Virtual Network for secure private connectivity.
- The administrative overhead of managing the host operating system, patching, and backups must be minimized.
- The backup strategy must guarantee that data remains recoverable even in the event of a complete primary Azure datacenter outage.
Which database solution should you recommend?
- AAzure SQL Database single database with geo-redundant backup storage
- BSQL Server on Azure Virtual Machines using Standard HDD storage for database transaction logs
- Azure SQL Managed Instance with geo-redundant backup storageAnswer
- DAzure SQL Managed Instance with locally redundant backup storage
Answer
Azure SQL Managed Instance with geo-redundant backup storage
The correct answer is Azure SQL Managed Instance with geo-redundant backup storage. This solution satisfies all criteria: it is a fully managed database service (PaaS) that minimizes administrative overhead, supports SQL Server Agent and cross-database queries natively, supports virtual network integration via a delegated subnet, and replicates backups to a paired region using geo-redundant storage (GRS) to survive a primary datacenter outage.
Step-by-Step Solution
Key Concept
Selecting Azure SQL relational database tiers and backup options based on feature requirements and operational overhead