Microsoft Azure Data Fundamentals DP-900 Practice Question
Your organization plans to move an on-premises SQL Server database to Azure without modifying the database schema or existing SQL Server Agent jobs. The operations team wants Microsoft to manage operating-system patching, while administrators still need to restore native SQL Server .bak files. Which Azure relational data service best meets these requirements?
Azure SQL Managed Instance is a platform-as-a-service (PaaS) offering that delivers nearly 100 percent compatibility with the SQL Server engine. It supports SQL Server Agent, cross-database queries, and native restoration of .bak files from on-premises SQL Server. Because it is a managed service, Microsoft handles operating-system patching and most routine maintenance tasks.
Azure SQL Database (single database) lacks SQL Server Agent and native restore capabilities. Running SQL Server on an Azure virtual machine would preserve full compatibility and native restore, but the customer-not Microsoft-remains responsible for OS patching and maintenance. Azure Database for PostgreSQL is a PostgreSQL service and does not support SQL Server workloads. Therefore, Azure SQL Managed Instance is the most appropriate choice.
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
What does OS patching mean in the context of managed services?
Open an interactive chat with Bash
How does native restoration of *.bak files work in 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 .