Microsoft Azure Data Fundamentals DP-900 Practice Question
You plan to lift and shift an on-premises SQL Server database that relies on SQL Server Agent jobs, cross-database queries, and Service Broker. You want Microsoft to handle OS and SQL patching but still keep almost full engine compatibility. Which Azure relational data service should you choose?
Azure SQL Managed Instance offers nearly 100 percent compatibility with the SQL Server engine and supports features such as SQL Server Agent, cross-database queries, and Service Broker. Because it is a Platform as a Service (PaaS) offering, Microsoft manages operating-system and SQL Server patching for you, reducing administrative overhead.
Azure SQL Database single database does not support cross-database queries or SQL Server Agent and is intended for modernized, isolated workloads.
SQL Server on Azure Virtual Machines provides full feature compatibility but leaves OS and SQL patching in your control, which the scenario wants to avoid.
Azure Database for PostgreSQL is an open-source relational service that is incompatible with SQL Server workloads.
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 Azure SQL Managed Instance?
Open an interactive chat with Bash
Why doesn't Azure SQL Database single database work for this use case?
Open an interactive chat with Bash
How does SQL Server on Azure Virtual Machines compare to Azure SQL Managed Instance?
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 .