DP-900 Practice Question: Identify considerations for relational data on Azure
Which THREE are valid reasons to choose Azure SQL Managed Instance over Azure SQL Database?
⚠ Common exam trap
Candidates often assume Azure SQL Database supports all instance-level features because it is a 'SQL Server in the cloud,' but Microsoft deliberately removed instance-scoped components like SQL Server Agent and Service Broker to enforce a multi-tenant architecture.
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 and CLR integration
Azure SQL Managed Instance provides near 100% compatibility with on-premises SQL Server, including instance-level features like SQL Server Agent and CLR integration. These features are not available in Azure SQL Database, which is a Platform-as-a-Service offering that abstracts away the instance scope. Therefore, if your application requires SQL Server Agent for job scheduling or CLR for custom .NET code execution, Managed Instance is the correct choice.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Simpler high-availability configuration
Why it's wrong here
Both Azure SQL Database and Azure SQL Managed Instance are fully managed PaaS services, so the platform automatically handles high availability for you; you never configure Always On Availability Groups or failover clusters in either. Managed Instance actually mirrors the SQL Server engine's own HA model and provides comparable health and availability options, which means choosing it for a simpler HA configuration is not a valid differentiator.
- ✓
Need for SQL Server Agent and CLR integration
Why this is correct
SQL Server Agent job scheduling and CLR (common language runtime) stored procedures are part of the broader SQL Server engine surface area that is supported in Azure SQL Managed Instance but unavailable in Azure SQL Database single databases. If your workloads rely on T-SQL agent jobs that run nightly maintenance or managed code that executes inside the database, those features simply cannot be used with a single database. That compatibility gap is a concrete, technical reason to pick Managed Instance.
- ✗
Desire for automated backups
Why it's wrong here
Automated backup management is a built-in capability of both Azure SQL Database and Azure SQL Managed Instance, with point-in-time restore and configurable retention periods available on either platform. Because this functionality is not exclusive to Managed Instance, a desire for automated backups does not justify the choice and should not be used as a differentiator between these two services.
- ✓
Need for instance-level features like Service Broker or Database Mail
Why this is correct
Service Broker's asynchronous messaging and Database Mail's email notifications are scoped at the SQL Server instance level and require a real instance boundary rather than just an isolated database. Azure SQL Managed Instance provides that boundary, so these features work as they do on-premises, while Azure SQL Database isolates each database and does not expose those instance-level services. Any workload that depends on these components clearly needs the Managed Instance deployment option.
- ✓
Requirement for cross-database queries within the same instance
Why this is correct
Three-part-name queries that reference tables in another database on the same SQL Server instance require all participating databases to reside within the same instance boundary. Azure SQL Managed Instance supports this naturally, but a standalone Azure SQL Database cannot directly reference another database's tables and would need elastic query with separate configuration and certain limitations. That makes cross-database query capability a legitimate reason to choose Managed Instance over a single SQL database.
Go deeper
Related to this question
Learn chapter
Azure SQL Services
Key term
Service
A service is a software component or system that performs a specific function and is available to be used by other programs or users over a network.
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.
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 →
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.