- A
Azure SQL Database
Why wrong: Azure SQL Database is a fully managed PaaS service, but it does not support features like SQL Server Agent jobs, cross-database queries, or CLR integration. Additionally, it does not provide native VNet integration; you would typically use a private endpoint for network isolation. This service is better suited for modern applications that do not require these legacy features.
- B
Azure SQL Managed Instance
Azure SQL Managed Instance is a fully managed PaaS service that offers near 100% compatibility with on-premises SQL Server, including support for SQL Server Agent, cross-database queries, and CLR integration. It also natively integrates with a VNet, allowing the instance to be placed directly into a subnet without additional configuration. This makes it ideal for migrations requiring minimal application changes.
- C
SQL Server on Azure Virtual Machine
Why wrong: SQL Server on Azure Virtual Machine is an IaaS offering where you manage the VM and SQL Server installation. While it provides full compatibility, it is not fully managed; you are responsible for patching, backups, and high availability. The company wants a fully managed PaaS service, so this option is incorrect.
- D
Azure Cosmos DB
Why wrong: Azure Cosmos DB is a globally distributed NoSQL database service designed for modern applications. It does not support SQL Server features such as T-SQL, stored procedures, or SQL Server Agent. It is not suitable for migrating an existing SQL Server database with these requirements.
Quick Answer
Azure SQL Managed Instance is the correct choice because it delivers near 100% SQL Server compatibility while operating as a fully managed PaaS service, making it the ideal solution for migrating SQL Server to Azure PaaS with agent jobs and cross-database queries intact. Unlike Azure SQL Database, which lacks support for SQL Server Agent and cross-database references, Managed Instance preserves these features along with CLR integration, allowing a true lift-and-shift migration with minimal application code changes. It also supports native VNet integration without requiring a private endpoint, placing the database directly into your virtual network for secure, isolated connectivity. On the AZ-900 exam, this question tests your ability to distinguish between Azure SQL Database and Azure SQL Managed Instance—a common trap is choosing SQL Database because it is also PaaS, but it lacks Agent jobs and cross-database query support. Remember the memory tip: “Managed Instance means managed compatibility,” so if the scenario mentions Agent jobs, cross-database queries, or CLR, think Managed Instance.
AZ-900 Describe Azure architecture and services Practice Question
This AZ-900 practice question tests your understanding of describe azure architecture and services. 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. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. 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 plans to migrate its on-premises SQL Server database to Azure. The database uses many features including SQL Server Agent jobs, cross-database queries, and CLR integration. The company wants a fully managed PaaS service that minimizes application code changes and supports native virtual network (VNet) integration without requiring a private endpoint. Which Azure service should the company use?
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 the correct choice because it provides near 100% compatibility with on-premises SQL Server, including SQL Server Agent jobs, cross-database queries, and CLR integration, while being a fully managed PaaS service. It supports native VNet integration without requiring a private endpoint, allowing the database to be placed directly into a customer's virtual network for secure, isolated connectivity.
Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
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 service, but it does not support features like SQL Server Agent jobs, cross-database queries, or CLR integration. Additionally, it does not provide native VNet integration; you would typically use a private endpoint for network isolation. This service is better suited for modern applications that do not require these legacy features.
- ✓
Azure SQL Managed Instance
Why this is correct
Azure SQL Managed Instance is a fully managed PaaS service that offers near 100% compatibility with on-premises SQL Server, including support for SQL Server Agent, cross-database queries, and CLR integration. It also natively integrates with a VNet, allowing the instance to be placed directly into a subnet without additional configuration. This makes it ideal for migrations requiring minimal application changes.
Related concept
Read the scenario before looking for a memorised answer.
- ✗
SQL Server on Azure Virtual Machine
Why it's wrong here
SQL Server on Azure Virtual Machine is an IaaS offering where you manage the VM and SQL Server installation. While it provides full compatibility, it is not fully managed; you are responsible for patching, backups, and high availability. The company wants a fully managed PaaS service, so this option is incorrect.
- ✗
Azure Cosmos DB
Why it's wrong here
Azure Cosmos DB is a globally distributed NoSQL database service designed for modern applications. It does not support SQL Server features such as T-SQL, stored procedures, or SQL Server Agent. It is not suitable for migrating an existing SQL Server database with these requirements.
Common exam traps
Common exam trap: answer the scenario, not the keyword
The trap here is that candidates often confuse Azure SQL Database with Azure SQL Managed Instance, not realizing that Azure SQL Database lacks key SQL Server features like SQL Server Agent and native VNet integration, which are critical for the scenario described.
Detailed technical explanation
How to think about this question
Azure SQL Managed Instance uses a native VNet injection model where the instance is deployed into a dedicated subnet within the customer's VNet, providing direct connectivity and security without the overhead of a private endpoint. It supports the full SQL Server surface area, including SQL Server Agent, Service Broker, and cross-database queries, making it ideal for lift-and-shift migrations with minimal application changes. Under the hood, it runs on the same SQL Server engine as on-premises but with automated patching, backups, and high availability managed by Azure.
KKey Concepts to Remember
- Read the scenario before looking for a memorised answer.
- Find the constraint that changes the correct option.
- Eliminate answers that are true in general but not in this case.
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
Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Real-world example
How this comes up in practice
An e-commerce site experiences heavy traffic on Black Friday and near-zero traffic during off-peak weeks. Rather than provisioning permanent large VMs, the team uses auto-scaling groups that add capacity automatically under load and reduce it overnight. Questions like this test whether you understand elasticity, availability zones, and cloud compute scaling patterns.
What to study next
Got this wrong? Here's your next step.
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
- →
Describe Azure architecture and services — study guide chapter
Learn the concepts, then practise the questions
- →
Describe Azure architecture and services practice questions
Targeted practice on this topic area only
- →
All AZ-900 questions
1,031 questions across all exam domains
- →
Microsoft Azure Fundamentals AZ-900 study guide
Full concept coverage aligned to exam objectives
- →
AZ-900 practice test guide
How to use practice tests most effectively before exam day
Related practice questions
Related AZ-900 practice-question pages
Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.
Describe cloud concepts practice questions
Practise AZ-900 questions linked to Describe cloud concepts.
Describe Azure architecture and services practice questions
Practise AZ-900 questions linked to Describe Azure architecture and services.
Describe Azure management and governance practice questions
Practise AZ-900 questions linked to Describe Azure management and governance.
AZ-900 Azure services practice questions
Practise AZ-900 questions linked to AZ-900 Azure services.
AZ-900 pricing and support practice questions
Practise AZ-900 questions linked to AZ-900 pricing and support.
AZ-900 security and compliance practice questions
Practise AZ-900 questions linked to AZ-900 security and compliance.
AZ-900 governance practice questions
Practise AZ-900 questions linked to AZ-900 governance.
Practice this exam
Start a free AZ-900 practice session
Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.
FAQ
Questions learners often ask
What does this AZ-900 question test?
Describe Azure architecture and services — This question tests Describe Azure architecture and services — Read the scenario before looking for a memorised answer..
What is the correct answer to this question?
The correct answer is: Azure SQL Managed Instance — Azure SQL Managed Instance is the correct choice because it provides near 100% compatibility with on-premises SQL Server, including SQL Server Agent jobs, cross-database queries, and CLR integration, while being a fully managed PaaS service. It supports native VNet integration without requiring a private endpoint, allowing the database to be placed directly into a customer's virtual network for secure, isolated connectivity.
What should I do if I get this AZ-900 question wrong?
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
What is the key concept behind this question?
Read the scenario before looking for a memorised answer.
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 →
Same concept, more angles
3 more ways this is tested on AZ-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 wants to migrate their on-premises SQL Server database to Azure with minimal changes to their existing application code. Which service offers the highest compatibility?
medium- A.Azure SQL Database
- ✓ B.Azure SQL Managed Instance
- C.Azure Database for PostgreSQL
- D.Azure Cosmos DB
Why B: Azure SQL Managed Instance is correct because it provides near 100% compatibility with on-premises SQL Server, including support for SQL Server Agent, cross-database queries, and CLR integration, enabling a lift-and-shift migration with minimal application code changes. In contrast, Azure SQL Database is a Platform-as-a-Service offering that lacks many SQL Server features like instance-scoped objects, making it less compatible for existing applications.
Variation 2. A company wants to migrate an on-premises SQL Server database to Azure. They require full administrative control over the database engine, including the ability to configure SQL Server Agent jobs and use cross-database queries. They also want to avoid patching the operating system. Which Azure service should they choose?
medium- A.Azure SQL Database
- ✓ B.Azure SQL Managed Instance
- C.SQL Server on Azure Virtual Machines
- D.Azure Database for SQL
Why B: Azure SQL Managed Instance is the correct choice because it provides near 100% compatibility with on-premises SQL Server, including full administrative control over the database engine, support for SQL Server Agent jobs, and cross-database queries. It also offloads OS patching to Microsoft, meeting the requirement to avoid OS maintenance.
Variation 3. A company wants to migrate a set of on-premises databases to Azure. They require high compatibility with SQL Server features, including cross-database queries and SQL Agent jobs. They want a PaaS solution. Which Azure service is most appropriate?
medium- A.Azure SQL Database
- ✓ B.Azure SQL Managed Instance
- C.SQL Server on Azure Virtual Machines
- D.Azure Database for PostgreSQL
Why B: Azure SQL Managed Instance is the correct choice because it provides near 100% compatibility with SQL Server on-premises, including support for cross-database queries and SQL Agent jobs, while being a fully managed Platform-as-a-Service (PaaS) offering. This allows the company to lift-and-shift their databases without redesigning applications, meeting both the feature and PaaS requirements.
Last reviewed: Jun 11, 2026
This AZ-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 AZ-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.