DP-900 Practice Question: Identify considerations for relational data on Azure
A company plans to migrate a 2-TB on-premises SQL Server database to Azure. The database uses SQL Server Agent jobs for scheduled maintenance and requires automatic failover across Azure regions. The company wants a fully managed service with minimal application changes. Which Azure SQL service should they choose?
⚠ Common exam trap
It's easy for candidates to choose Azure SQL Database because it is the most well-known fully managed service, overlooking the specific requirement for SQL Server Agent jobs and automatic cross-region failover, which Managed Instance uniquely supports.
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
✓
Azure SQL Managed Instance
Azure SQL Managed Instance is correct because it provides near 100% compatibility with SQL Server, including support for SQL Server Agent jobs, and offers automatic failover across Azure regions via failover groups. It is a fully managed service that requires minimal application changes, unlike Azure SQL Database which lacks SQL Server Agent and has limited cross-region failover capabilities.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Azure SQL Database
Why it's wrong here
Azure SQL Database is a single-database PaaS offering that does not support SQL Server Agent jobs; its replacement, Elastic Jobs, requires a detached scheduler and is not a drop-in equivalent. Instance-scoped features like cross-database queries, linked servers, and SQL Agent cannot run natively, so migrating a 2 TB SQL Server with scheduled maintenance tasks would require significant reengineering, making it an unsuitable choice.
When this WOULD be correct
For a new application with a single database under 4 TB, no dependency on instance-level features like SQL Agent, and requiring built-in high availability within a single region, Azure SQL Database would be the correct choice.
- ✓
Azure SQL Managed Instance
Why this is correct
Azure SQL Managed Instance is a fully managed PaaS service that delivers near 100% SQL Server compatibility, including native support for SQL Server Agent, which the company needs for scheduled maintenance. It supports storage capacities up to 16 TB for a 2 TB migration, and its auto-failover groups enable cross-region high availability with automatic replication and failover, making it the appropriate target.
- ✗
SQL Server on Azure Virtual Machines
Why it's wrong here
While SQL Server on Azure Virtual Machines does support SQL Server Agent, it is an Infrastructure-as-a-Service option in which you must manually patch the OS and SQL Server, manage backups, and configure high availability. This contradicts the company's implicit requirement for a fully managed service, so the operational overhead is higher than with a PaaS offering like Azure SQL Managed Instance.
When this WOULD be correct
A company needs full control over the SQL Server environment, including custom configurations, third-party tools, or legacy dependencies that are not supported in PaaS offerings, and is willing to manage the underlying VM and high availability manually.
- ✗
Azure Synapse Analytics
Why it's wrong here
Azure Synapse Analytics is an MPP-based cloud data warehouse built for petabyte-scale analytics, not for OLTP workloads that depend on SQL Server Agent. It does not provide SQL Server Agent, and its storage and query architecture are columnar and massively parallel, so a 2 TB transactional database would need a full redesign; it is not a migration target for daily maintenance jobs.
When this WOULD be correct
A company needs to migrate a 10-TB data warehouse from on-premises SQL Server to Azure, requiring massively parallel processing (MPP) for complex analytical queries and integration with big data pipelines, with minimal changes to existing SQL code.
Option-by-option analysis
Why each answer is right or wrong
Understanding why wrong answers are wrong — and when they would be correct — is what separates a 750 score from a 900. The DP-900 exam frequently reuses these exact scenarios with slightly different constraints.
✓Azure SQL Managed InstanceCorrect answer▾
Why this is correct
Azure SQL Managed Instance is a fully managed PaaS service that delivers near 100% SQL Server compatibility, including native support for SQL Server Agent, which the company needs for scheduled maintenance. It supports storage capacities up to 16 TB for a 2 TB migration, and its auto-failover groups enable cross-region high availability with automatic replication and failover, making it the appropriate target.
✗Azure SQL DatabaseWrong answer — click to see why▾
Why this is wrong here
Azure SQL Database does not support SQL Server Agent jobs or cross-region automatic failover with minimal application changes; it requires database-level management and lacks instance-scoped features.
★ When this WOULD be the correct answer
For a new application with a single database under 4 TB, no dependency on instance-level features like SQL Agent, and requiring built-in high availability within a single region, Azure SQL Database would be the correct choice.
Why candidates choose this
Candidates may assume Azure SQL Database is the default fully managed option and overlook the specific requirements for SQL Agent jobs and cross-region failover, which are only available in Azure SQL Managed Instance.
✗SQL Server on Azure Virtual MachinesWrong answer — click to see why▾
Why this is wrong here
SQL Server on Azure VMs requires you to manage the OS and SQL Server, including SQL Server Agent jobs and high availability setup, which contradicts the requirement for a fully managed service with minimal application changes.
★ When this WOULD be the correct answer
A company needs full control over the SQL Server environment, including custom configurations, third-party tools, or legacy dependencies that are not supported in PaaS offerings, and is willing to manage the underlying VM and high availability manually.
Why candidates choose this
Candidates may think that migrating to VMs is the simplest lift-and-shift approach, but they overlook the management overhead and the fact that Azure SQL Managed Instance provides near 100% compatibility with less administrative effort.
✗Azure Synapse AnalyticsWrong answer — click to see why▾
Why this is wrong here
Azure Synapse Analytics is a distributed analytics service for large-scale data warehousing and big data workloads, not designed for transactional SQL Server databases with SQL Server Agent jobs and automatic failover across regions.
★ When this WOULD be the correct answer
A company needs to migrate a 10-TB data warehouse from on-premises SQL Server to Azure, requiring massively parallel processing (MPP) for complex analytical queries and integration with big data pipelines, with minimal changes to existing SQL code.
Why candidates choose this
Candidates may confuse Synapse Analytics as a fully managed SQL service that supports large databases, overlooking its focus on analytics rather than OLTP and its lack of support for SQL Server Agent jobs and auto-failover groups.
Analysis generated from the official DP-900blueprint and verified against question context. The “when correct” sections are what AI assistants cite when candidates ask “what’s the difference between these options?”
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 →
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.