Azure SQL Database vs Azure SQL Managed Instance
Which THREE factors should you consider when choosing between Azure SQL Database and Azure SQL Managed Instance?
Quick Answer
The three factors to consider when choosing between Azure SQL Database and Azure SQL Managed Instance are automatic scaling of compute resources, support for instance-level features like SQL Agent jobs, and the ability to perform cross-database queries. This distinction matters because SQL Database offers auto-scaling options such as serverless compute, making it ideal for variable workloads, while SQL Managed Instance provides full instance-scope compatibility, including SQL Agent and cross-database querying, which are essential for lift-and-shift migrations of existing SQL Server applications. On the DP-900 exam, this question tests your understanding of the core architectural differences between platform-as-a-service offerings, often appearing as a scenario where you must match workload requirements to the correct service. A common trap is assuming both services support the same features—remember that SQL Managed Instance is the “full SQL Server in the cloud” option, whereas SQL Database is a more streamlined, scalable database service. For a quick memory tip, think: “Managed Instance is for migration, Database is for modernization.”
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Need for SQL Server Agent jobs
SQL Managed Instance supports SQL Server Agent jobs, which SQL Database does not. Option C is correct because SQL Managed Instance supports cross-database queries, while SQL Database does not. Option D is correct because SQL Database offers automatic scaling options like serverless compute, whereas SQL Managed Instance requires manual scaling. Option A is incorrect because both services support Microsoft Entra ID authentication. Option E is incorrect because VNet integration is a feature of SQL Managed Instance, not a primary differentiator, and both can be integrated into a VNet in different ways.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Support for Microsoft Entra ID authentication
Why it's wrong here
Both Azure SQL Database and SQL Managed Instance support Microsoft Entra ID authentication, so this is not a differentiating factor.
- ✓
Need for SQL Server Agent jobs
Why this is correct
SQL Managed Instance supports SQL Server Agent jobs, while Azure SQL Database does not. This is a key factor when choosing between them.
- ✓
Need for cross-database queries
Why this is correct
SQL Managed Instance supports cross-database queries, while Azure SQL Database does not. This is a key differentiator.
- ✓
Automatic scaling of compute resources
Why this is correct
Azure SQL Database offers automatic scaling of compute resources (e.g., serverless compute), whereas SQL Managed Instance requires manual scaling. This is a consideration.
- ✗
Requirement for VNet integration
Why it's wrong here
Both services can be integrated into a VNet, but SQL Managed Instance always runs in a VNet, while SQL Database uses a different approach. However, both support VNet integration, so it is not a differentiating factor.
Quick reference
Cloud Service Model Comparison
| Model | You Manage | Provider Manages | Examples |
|---|---|---|---|
| IaaS | OS, runtime, apps, data | Hardware, hypervisor, networking | EC2, Azure VMs, GCP Compute Engine |
| PaaS | Apps and data | OS, runtime, middleware, hardware | Elastic Beanstalk, Azure App Service |
| SaaS | Data and settings only | Everything else | Microsoft 365, Salesforce, Workday |
| FaaS / Serverless | Function code only | Infra, scaling, runtime | Lambda, Azure Functions, Cloud Run |
| CaaS | Containers and apps | Kubernetes, OS, hardware | EKS, AKS, GKE |
Go deeper
Related to this question
Learn chapter
Azure SQL Services
Key term
SQL Managed Instance
SQL Managed Instance is a cloud database service from Azure that gives you most of the features of a full SQL Server instance without you having to manage the underlying hardware or software patches.
Key term
Azure SQL Database
Azure SQL Database is a fully managed relational database-as-a-service (DBaaS) in Microsoft Azure, based on the SQL Server engine, that handles scaling, backups, patching, and high availability automatically.
About these practice questions
One of 820 original DP-900 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
Same concept, more angles
1 more way this is tested on DP-900
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. Which THREE of the following are valid considerations when choosing between Azure SQL Database and Azure SQL Managed Instance?
hard- ✓ A.Azure SQL Managed Instance supports SQL Server Agent for job scheduling.
- B.Azure SQL Database supports larger database sizes than Azure SQL Managed Instance.
- ✓ C.Azure SQL Managed Instance supports cross-database queries within the same instance.
- D.Azure SQL Managed Instance does not support virtual network integration.
- ✓ E.Azure SQL Database supports elastic pools for cost-effective resource sharing among multiple databases.
Why A: Options A, C, and E are correct. Azure SQL Managed Instance supports SQL Server Agent (A) and cross-database queries (C) because it shares more features with on-premises SQL Server. Azure SQL Database supports elastic pools (E) for sharing resources across databases. Option B is incorrect because Azure SQL Managed Instance supports larger database sizes than Azure SQL Database (up to 16 TB vs. up to 4 TB for single databases in SQL Database). Option D is incorrect because Azure SQL Managed Instance always runs within a virtual network, so it supports VNet integration by default.
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DP-900 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-900 exam.