Azure SQL Managed Instance: Lift-and-Shift to PaaS with Full SQL Server Compatibility
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?
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.
⚠ Common exam trap
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.
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.
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 incorrect because it lacks native support for SQL Server Agent jobs, cross-database queries, and CLR integration, which are critical features for the company's existing database. Migrating these would necessitate significant application code changes, failing a key requirement. Furthermore, it does not offer native VNet integration without requiring a private endpoint, typically relying on private endpoints. This service is a fully managed PaaS solution, ideal for new cloud-native applications or modernised migrations that do not rely on these specific legacy SQL Server functionalities.
When this WOULD be correct
A company wants a fully managed PaaS database service for a new application with minimal legacy dependencies, does not need SQL Server Agent or cross-database queries, and is willing to use a private endpoint for secure VNet access.
- ✓
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.
- ✗
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.
When this WOULD be correct
A company needs full control over the SQL Server environment, including custom configurations, specific SQL Server versions, or third-party software, and is willing to manage the underlying OS and database patches. The question would specify that the company requires IaaS for maximum flexibility and control.
- ✗
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.
When this WOULD be correct
A company needs a globally distributed, multi-model database service with low latency and automatic scaling for a new application that uses NoSQL data models (e.g., document, key-value, graph) and requires SLA-backed throughput and availability. The application does not rely on SQL Server-specific features.
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 AZ-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 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.
✗Azure SQL DatabaseWrong answer — click to see why▾
Why this is wrong here
Azure SQL Database does not support SQL Server Agent jobs, cross-database queries, or CLR integration natively, and it requires a private endpoint for VNet integration rather than native VNet injection.
★ When this WOULD be the correct answer
A company wants a fully managed PaaS database service for a new application with minimal legacy dependencies, does not need SQL Server Agent or cross-database queries, and is willing to use a private endpoint for secure VNet access.
Why candidates choose this
Candidates may confuse Azure SQL Database with SQL Managed Instance because both are PaaS, but they overlook the specific feature requirements like SQL Agent and native VNet integration.
✗SQL Server on Azure Virtual MachineWrong answer — click to see why▾
Why this is wrong here
SQL Server on Azure VM is an IaaS solution, not a fully managed PaaS service, and requires manual management of SQL Server Agent jobs, cross-database queries, and CLR integration. It also does not provide native VNet integration without a private endpoint; you must configure the VM's virtual network settings separately.
★ When this WOULD be the correct answer
A company needs full control over the SQL Server environment, including custom configurations, specific SQL Server versions, or third-party software, and is willing to manage the underlying OS and database patches. The question would specify that the company requires IaaS for maximum flexibility and control.
Why candidates choose this
Candidates may think that running SQL Server on a VM offers the same features as on-premises with minimal changes, but they overlook the PaaS requirement and the fact that it is not fully managed, leading to higher administrative overhead.
✗Azure Cosmos DBWrong answer — click to see why▾
Why this is wrong here
Azure Cosmos DB is a NoSQL database service, not a relational SQL Server database. It does not support SQL Server Agent jobs, cross-database queries, or CLR integration, and migrating a SQL Server database to Cosmos DB would require significant application code changes.
★ When this WOULD be the correct answer
A company needs a globally distributed, multi-model database service with low latency and automatic scaling for a new application that uses NoSQL data models (e.g., document, key-value, graph) and requires SLA-backed throughput and availability. The application does not rely on SQL Server-specific features.
Why candidates choose this
Candidates may confuse 'fully managed PaaS' with any Azure database service, and the name 'Cosmos DB' might sound like a modern, scalable option. They may overlook the specific SQL Server features required in the question.
Analysis generated from the official AZ-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 Regions and Geographies
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
VNet
A virtual private network inside a cloud provider that lets you securely connect and isolate your cloud resources.
About these practice questions
One of 981 original AZ-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 →
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.
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
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.