Azure SQL Managed Instance Use Cases: SQL Agent and Linked Servers
A company has an existing on-premises SQL Server database that is 500 GB in size. The database uses SQL Server Agent jobs for scheduled maintenance and linked servers to query data from a remote SQL Server instance. The company wants to migrate to Azure with minimal application changes and needs automated backups and patching. Which Azure SQL service should they choose?
Quick Answer
The answer is Azure SQL Managed Instance. This is the correct choice because it offers near 100% compatibility with on-premises SQL Server, including full support for SQL Server Agent jobs for scheduled maintenance and linked servers to query remote instances, while also providing automated backups and patching—allowing migration with minimal application changes. On the DP-900 exam, this scenario tests your understanding of when to choose Azure SQL Managed Instance for migration, specifically distinguishing it from Azure SQL Database (which lacks Agent and linked server support) and SQL Server on Azure VMs (which requires manual patching). A common trap is assuming SQL Database can handle Agent jobs, but it cannot; Managed Instance is the only PaaS option that preserves these features. Memory tip: think "Managed Instance = Managed Compatibility" for Agent and linked servers.
⚠ Common exam trap
Candidates often choose Azure SQL Database for its simplicity, overlooking its lack of SQL Server Agent and linked server support, which are critical for the described workload.
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 offering automated backups and patching. This minimizes application changes during migration, unlike other Azure SQL options that lack these features.
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 fully managed PaaS offering, but it does not support SQL Agent jobs or linked servers. The company would need to redesign those features, which contradicts the requirement for minimal changes.
When this WOULD be correct
A company has a new application with no dependency on SQL Server Agent jobs or linked servers, and needs a fully managed, scalable, and cost-effective database with built-in high availability and automated backups. Azure SQL Database would be the correct choice.
- ✓
Azure SQL Managed Instance
Why this is correct
Azure SQL Managed Instance provides high compatibility with on-premises SQL Server, including support for SQL Agent jobs and linked servers. It also includes automated backups, patching, and high availability, meeting all requirements.
- ✗
SQL Server on Azure Virtual Machines
Why it's wrong here
SQL Server on Azure VMs gives full control but requires the company to manage backups, patching, and high availability manually. This does not meet the requirement for automated backups and patching.
When this WOULD be correct
If the question required full control over the SQL Server environment, including custom configurations, need for SQL Server Agent with linked servers, or the ability to install third-party software, then SQL Server on Azure VMs would be correct.
- ✗
Azure Database for PostgreSQL
Why it's wrong here
Azure Database for PostgreSQL is a different database engine (PostgreSQL, not SQL Server). The company would need to perform a full migration, including changing application code and database schema, which is not minimal.
When this WOULD be correct
A company has a PostgreSQL database on-premises and wants to migrate to Azure with minimal application changes, needing automated backups and patching. They should choose Azure Database for PostgreSQL.
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 provides high compatibility with on-premises SQL Server, including support for SQL Agent jobs and linked servers. It also includes automated backups, patching, and high availability, meeting all requirements.
✗Azure SQL DatabaseWrong answer — click to see why▾
Why this is wrong here
Azure SQL Database does not support SQL Server Agent jobs or linked servers, which are required by the existing on-premises database. The migration would require significant application changes to remove these dependencies.
★ When this WOULD be the correct answer
A company has a new application with no dependency on SQL Server Agent jobs or linked servers, and needs a fully managed, scalable, and cost-effective database with built-in high availability and automated backups. Azure SQL Database would be the correct choice.
Why candidates choose this
Candidates may assume that 'Azure SQL Database' is the default managed SQL service in Azure and overlook the specific requirements for SQL Server Agent jobs and linked servers, which are not supported in Azure SQL Database.
✗SQL Server on Azure Virtual MachinesWrong answer — click to see why▾
Why this is wrong here
SQL Server on Azure VMs requires manual patching and backup management, and does not provide automated patching and backups as required by the question.
★ When this WOULD be the correct answer
If the question required full control over the SQL Server environment, including custom configurations, need for SQL Server Agent with linked servers, or the ability to install third-party software, then SQL Server on Azure VMs would be correct.
Why candidates choose this
Candidates may think that because the on-premises database uses SQL Server Agent and linked servers, they need full control over the OS, leading them to choose VMs over Managed Instance.
✗Azure Database for PostgreSQLWrong answer — click to see why▾
Why this is wrong here
Azure Database for PostgreSQL is a non-SQL Server database service, so it does not support SQL Server Agent jobs, linked servers, or the T-SQL surface area required for minimal application changes from an existing SQL Server database.
★ When this WOULD be the correct answer
A company has a PostgreSQL database on-premises and wants to migrate to Azure with minimal application changes, needing automated backups and patching. They should choose Azure Database for PostgreSQL.
Why candidates choose this
Candidates may confuse Azure Database for PostgreSQL as a general-purpose Azure SQL service, not realizing it is a different database engine that lacks SQL Server-specific features like Agent jobs 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
Data Roles and Core Concepts
Key term
Data
Data is raw, unprocessed information, like numbers, words, or measurements, that can be stored, processed, and analyzed by computers.
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
This DP-900 question is part of Courseiva's 820-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. 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. A company has 15 on-premises SQL Server databases, each 20–40 GB, running on a single instance. They rely on cross-database queries using three-part names (e.g., DB1.dbo.table) and SQL Server Agent for maintenance. They want to migrate to Azure with minimal application changes and reduce administrative overhead. Which Azure SQL deployment option should they choose?
medium- A.Azure SQL Database elastic pool
- B.Azure SQL Database single database
- ✓ C.Azure SQL Managed Instance
- D.SQL Server on Azure Virtual Machines
Why C: Azure SQL Managed Instance is correct because it provides near-100% compatibility with on-premises SQL Server, including support for cross-database queries using three-part names and SQL Server Agent. This allows the company to migrate with minimal application changes while offloading administrative overhead like patching and backups, which are handled by Azure.
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.