Question 1mediummultiple choice
Full question →mediummultiple choiceObjective-mapped
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
Good practice is not just finding the correct option. The wrong answers often show the exact trap the exam wants you to fall into.
A
Distractor review
Azure SQL Database
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
Best answer
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
Distractor review
SQL Server on Azure Virtual Machine
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
Distractor review
Azure Cosmos DB
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 trap
Common exam trap: NAT rules depend on direction and matching traffic
NAT is not only about the public address. The inside/outside interface roles and the ACL or rule that matches traffic are just as important.
Technical deep dive
How to think about this question
NAT questions usually test address translation, overload/PAT behaviour, static mappings and whether the right traffic is being translated. Read the interface direction and address terms carefully.
KKey Concepts to Remember
- Static NAT maps one inside address to one outside address.
- PAT allows many inside hosts to share one public address using ports.
- Inside local and inside global describe the private and translated addresses.
- NAT ACLs identify traffic for translation, not always security filtering.
TExam Day Tips
- Identify inside and outside interfaces first.
- Check whether the scenario needs static NAT, dynamic NAT or PAT.
- Do not confuse NAT matching ACLs with normal packet-filtering intent.
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.
AZ-900 cloud concepts practice questions
Practise AZ-900 questions linked to AZ-900 cloud concepts.
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.
More questions from this exam
Keep practising from the same exam bank, or move into a focused topic page if this question exposed a weak area.
Question 1
A developer is building a serverless application that requires integration with an on-premises SQL Server database for real-time data processing. The on-premises network is connected to Azure via a site-to-site VPN. Which Azure service would allow the function to securely access the on-premises database without exposing it to the public internet?
Question 2
A solutions architect is designing a storage solution for a large media company. The company needs to store video files that are accessed infrequently but must be retained for several years for compliance. Which two Azure storage options meet these requirements? (Select two.)
Question 3
A company deploys a multi-tier application using Azure virtual machines. The web tier VMs must be evenly distributed across two distinct data centers within an Azure region to avoid a single point of failure from an infrastructure outage. Which Azure construct should they use to meet this requirement?
Question 4
A company wants to enforce a set of security policies across all their Azure subscriptions. They have created several individual policy definitions. Which Azure construct should they use to group these policies together and assign them as a single package?
Question 5
A company deploys a line-of-business application on an Azure virtual machine. The IT team wants to ensure the application remains secure. According to the shared responsibility model, which of the following security tasks is the sole responsibility of the customer (the company)?
Question 6
A company develops a web API that runs on Azure App Service. The development team wants to deploy a new version of the API to a staging environment, run integration tests against it, and then gradually shift production traffic to the new version. If any issues are detected, they want to immediately roll back to the previous version without redeploying. Which Azure App Service feature should the team use to meet these requirements?
FAQ
Questions learners often ask
What does this AZ-900 question test?
Static NAT maps one inside address to one outside address.
What is the correct answer to this question?
The correct answer is: Azure SQL Managed Instance — Azure SQL Managed Instance is a fully managed PaaS service that provides near 100% compatibility with on-premises SQL Server, including support for SQL Server Agent, cross-database queries, and CLR integration. It also offers native VNet integration, allowing the instance to be placed directly into a VNet without needing a separate private endpoint. Azure SQL Database (option A) is also PaaS but lacks support for these advanced features and does not offer native VNet placement. SQL Server on Azure VM (option C) provides full compatibility but is an IaaS solution that requires the customer to manage the VM and SQL Server, not fully managed. Azure Cosmos DB (option D) is a NoSQL database and does not support SQL Server features or compatibility. Therefore, the correct choice is Azure SQL Managed Instance.
What should I do if I get this AZ-900 question wrong?
Then try more questions from the same exam bank and focus on understanding why the wrong options are tempting.
Discussion
Loading comments…
Sign in to join the discussion.