DP-900 Practice Question: Identify considerations for relational data on Azure
This DP-900 practice question tests your understanding of identify considerations for relational data on azure. Match the stated requirement to the specific cloud service, access model, or configuration option — many options are valid in isolation but not for this scenario. A key principle to apply: azure SQL Managed Instance offers near 100% compatibility with on-premises SQL Server.. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.
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?
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.
Key principle: Azure SQL Managed Instance offers near 100% compatibility with on-premises SQL Server.
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
Incorrect because elastic pool is for single databases, does not support SQL Agent or linked servers at the instance level.
✗
Azure SQL Database single database
Why it's wrong here
Incorrect because single database does not support SQL Agent or linked servers.
✓
Azure SQL Managed Instance
Why this is correct
Correct because it supports SQL Agent, linked servers, and is fully managed with high compatibility.
Related concept
Azure SQL Managed Instance offers near 100% compatibility with on-premises SQL Server.
✗
Azure Synapse Analytics dedicated SQL pool
Why it's wrong here
Incorrect because Synapse Analytics is for data warehousing, not for general OLTP workloads with SQL Agent and linked servers.
Common exam traps
Common exam trap: answer the scenario, not the keyword
The trap here is that 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.
Detailed technical explanation
How to think about this question
Azure SQL Managed Instance runs in a dedicated virtual network (VNet) and uses a native virtual network interface (vNIC) to enable secure connectivity to on-premises networks via ExpressRoute or site-to-site VPN, which is essential for linked server communication. Under the hood, it leverages the same SQL Server engine as on-premises, including the SQL Server Agent service and distributed query capabilities via OLE DB or .NET SqlClient, ensuring that existing T-SQL scripts for jobs and linked server queries work without modification. A real-world scenario where this matters is a financial application that relies on cross-instance stored procedure calls and nightly batch jobs; migrating to Managed Instance avoids rewriting hundreds of lines of code.
KKey Concepts to Remember
Azure SQL Managed Instance offers near 100% compatibility with on-premises SQL Server.
It supports SQL Server Agent for scheduling jobs and tasks.
It allows the creation and use of linked servers to other SQL instances.
It provides a fully managed PaaS experience with instance-scoped features.
TExam Day Tips
→Watch for words such as best, first, most likely and least administrative effort.
→Review why wrong options are wrong, not only why the correct option is correct.
Key takeaway
Azure SQL Managed Instance offers near 100% compatibility with on-premises SQL Server.
Real-world example
How this comes up in practice
A cloud solutions architect for a retail company is evaluating services for a new workload. The correct answer here reflects best practice for the specific scenario described — not a general cloud recommendation. Azure SQL Managed Instance offers near 100% compatibility with on-premises SQL Server. Cloud exam questions reward reading the constraint carefully: the same technology can be right or wrong depending on the use case.
Related glossary terms
Concepts from this question explained
These glossary pages explain the core terms tested in this DP-900 question in full detail.
Review azure SQL Managed Instance offers near 100% compatibility with on-premises SQL Server., then practise related DP-900 questions on the same topic to reinforce the concept.
Identify considerations for relational data on Azure — This question tests Identify considerations for relational data on Azure — Azure SQL Managed Instance offers near 100% compatibility with on-premises SQL Server..
What is the correct answer to this question?
The correct answer is: 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.
What should I do if I get this DP-900 question wrong?
Review azure SQL Managed Instance offers near 100% compatibility with on-premises SQL Server., then practise related DP-900 questions on the same topic to reinforce the concept.
What is the key concept behind this question?
Azure SQL Managed Instance offers near 100% compatibility with on-premises SQL Server.
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
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.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.