Relational data
CoreAzure SQL Managed Instance
Managed SQL instance with broad SQL Server compatibility.
Key points
- Azure SQL Managed Instance provides managed SQL Server instance capabilities with broad compatibility.
- It removes guest patching while retaining more instance-level behavior than Azure SQL Database.
Best-known use cases
- Move a compatible instance-dependent SQL workload to a managed service without operating the OS.
What candidates often confuse it with
- Managed Instance balances instance compatibility and platform management; SQL Database is more database-scoped and SQL Server on VMs offers full control.
Key takeaway
Choose Managed Instance when broad SQL Server instance compatibility is required but guest ownership is not.
Relevant exam tasks
- D2.1.S1 — Recommend a solution for storing relational data
- D4.3.S4 — Recommend a solution for migrating databases