Microsoft Azure Data Fundamentals DP-900 Practice Question
An organization plans to migrate an on-premises SQL Server workload to Azure. They need a fully managed PaaS solution that provides automatic patching and backups, built-in high availability, and almost complete compatibility with SQL Server features such as SQL Agent and cross-database transactions. Which Azure relational data service should they choose?
Azure SQL Managed Instance is a platform as a service (PaaS) offering that Microsoft manages for backups, patching, and automatic updates. It delivers built-in high availability and offers nearly 100 percent compatibility with the SQL Server engine, including support for SQL Agent jobs and cross-database queries. Azure SQL Database single databases lack several instance-level features such as SQL Agent and cross-database transactions. SQL Server on Azure Virtual Machines provides full SQL Server compatibility but is an infrastructure-as-a-service (IaaS) option, so customers must handle patching, backups, and high-availability configuration themselves. Azure Database for MySQL is a managed service for the MySQL engine and does not meet the SQL Server compatibility requirement.
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
How does high availability work in Azure SQL Managed Instance?
Open an interactive chat with Bash
What makes Azure SQL Managed Instance different from SQL Server on Azure Virtual Machines?
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 .