Microsoft Azure Data Fundamentals DP-900 Practice Question
You are evaluating Azure SQL deployment options for a finance application that relies on SQL Server Agent jobs and cross-database transactions. The operations team wants Microsoft to handle operating-system patching and automatic minor version upgrades, but they also need almost full engine compatibility to avoid code rewrites. Which Azure SQL service should you choose?
Azure SQL Managed Instance is a Platform as a Service (PaaS) offering that provides near-100% compatibility with the SQL Server engine, including support for SQL Server Agent and cross-database queries. Because it is a managed service, Microsoft takes care of operating-system patching and in-place upgrades. Azure SQL Database (single or serverless) lacks some instance-level features such as SQL Server Agent and does not support cross-database transactions in the same way. SQL Server on Azure Virtual Machines offers full feature parity but leaves operating-system maintenance to the customer, which does not meet the stated requirement that Microsoft handle patching.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is the difference between Azure SQL Managed Instance and Azure SQL Database?
Open an interactive chat with Bash
Why is SQL Server on Azure Virtual Machines not recommended for this scenario?
Open an interactive chat with Bash
How does Azure SQL Managed Instance handle cross-database transactions?
Open an interactive chat with Bash
Microsoft Azure Data Fundamentals DP-900
Identify considerations for relational data on Azure
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .