DP-900 Practice Question: Identify considerations for relational data on Azure
A company is migrating an on-premises SQL Server database to Azure. The database is 800 GB, uses SQL Server Agent jobs for scheduled tasks, and needs to link to another on-premises SQL Server instance via linked servers. The company wants a fully managed service with minimal application changes. Which Azure SQL service should they choose?
⚠ Common exam trap
Watch out — candidates often confuse Azure SQL Database (single or elastic pool) with Azure SQL Managed Instance, assuming all PaaS offerings support SQL Server Agent and linked servers, when in fact only Managed Instance provides these instance-scoped features.
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 on-premises SQL Server, including support for SQL Server Agent jobs and linked servers, while being a fully managed platform-as-a-service (PaaS) offering. This allows the company to migrate the 800 GB database with minimal application changes, as it preserves the existing instance-level features without requiring a rearchitecture.
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 elastic pool
Why it's wrong here
Azure SQL Database elastic pool is incorrect because it is simply a collection of individual single databases that share a common pool of compute and storage resources for cost efficiency. Each database inside an elastic pool remains a single database, meaning it inherits the same limitations: no SQL Server Agent, no linked servers, and no instance-level scope. It solves resource management for multiple databases but does not add the compatibility needed for this migration.
When this WOULD be correct
A company needs to manage multiple databases with varying, unpredictable usage patterns and wants to optimize cost by sharing resources among them, without requiring SQL Server Agent or linked servers.
- ✗
Azure SQL Database single database
Why it's wrong here
Azure SQL Database single database is incorrect because it is a Platform-as-a-Service offering that lacks instance-level features such as SQL Server Agent and linked servers. Migrating to a single database would require rewriting portions of the application to use database-scoped alternatives like elastic jobs or external tables, making it a poor fit for a straightforward migration that depends on the original server-level functionality.
When this WOULD be correct
A company needs a fully managed, single-tenant database with minimal management overhead, does not require SQL Server Agent or linked servers, and has a predictable workload that fits within the resource limits of a single database.
- ✓
Azure SQL Managed Instance
Why this is correct
Azure SQL Managed Instance is the correct choice because it provides near-100% compatibility with on-premises SQL Server, including SQL Server Agent, linked servers, and other instance-scoped features, all in a fully managed platform. It supports lift-and-shift migrations without rearchitecting applications, and its built-in high availability and patching make it ideal for production workloads that rely on these advanced capabilities.
- ✗
Azure Synapse Analytics dedicated SQL pool
Why it's wrong here
Azure Synapse Analytics dedicated SQL pool is incorrect because it is a distributed data warehouse service designed for large-scale analytical workloads, not general OLTP applications. It does not support linked servers or SQL Server Agent jobs, and its T-SQL surface is tailored for batch processing and columnstore-based queries, so migrating a transactional SQL Server database here would be an architectural mismatch and break core operational features.
When this WOULD be correct
A company needs to migrate a 10 TB data warehouse from on-premises SQL Server to Azure for analytics and reporting, with no need for SQL Server Agent jobs or linked servers. The workload is read-intensive and requires high concurrency for large queries. Azure Synapse Analytics dedicated SQL pool would be the correct choice.
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 the correct choice because it provides near-100% compatibility with on-premises SQL Server, including SQL Server Agent, linked servers, and other instance-scoped features, all in a fully managed platform. It supports lift-and-shift migrations without rearchitecting applications, and its built-in high availability and patching make it ideal for production workloads that rely on these advanced capabilities.
✗Azure SQL Database elastic poolWrong answer — click to see why▾
Why this is wrong here
Azure SQL Database (elastic pool or single) does not support SQL Server Agent jobs or linked servers, which are required by the question.
★ When this WOULD be the correct answer
A company needs to manage multiple databases with varying, unpredictable usage patterns and wants to optimize cost by sharing resources among them, without requiring SQL Server Agent or linked servers.
Why candidates choose this
Candidates may think elastic pools are a fully managed option that can handle any workload, overlooking the specific feature requirements of SQL Server Agent and linked servers.
✗Azure SQL Database single databaseWrong answer — click to see why▾
Why this is wrong here
Azure SQL Database single database does not support SQL Server Agent jobs or linked servers, which are required by the question's scenario.
★ When this WOULD be the correct answer
A company needs a fully managed, single-tenant database with minimal management overhead, does not require SQL Server Agent or linked servers, and has a predictable workload that fits within the resource limits of a single database.
Why candidates choose this
Candidates may assume that Azure SQL Database is the default fully managed option and overlook the specific feature requirements (Agent jobs and linked servers) that are only available in Azure SQL Managed Instance.
✗Azure Synapse Analytics dedicated SQL poolWrong answer — click to see why▾
Why this is wrong here
Azure Synapse Analytics dedicated SQL pool is a massively parallel processing (MPP) data warehouse designed for large-scale analytics, not for OLTP workloads. It does not support SQL Server Agent jobs, linked servers, or minimal application changes for migrating an 800 GB SQL Server database.
★ When this WOULD be the correct answer
A company needs to migrate a 10 TB data warehouse from on-premises SQL Server to Azure for analytics and reporting, with no need for SQL Server Agent jobs or linked servers. The workload is read-intensive and requires high concurrency for large queries. Azure Synapse Analytics dedicated SQL pool would be the correct choice.
Why candidates choose this
Candidates may think Synapse Analytics is suitable because it is a fully managed service in Azure that supports SQL Server-like syntax, overlooking its focus on analytics rather than transactional workloads and its lack of features like SQL Server Agent and linked servers.
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
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
Courseiva writes every DP-900 question from scratch — 820 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. 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.