Microsoft Azure Data Fundamentals DP-900 Practice Question
A company plans to migrate an on-premises SQL Server database to Azure. The database uses Windows-authenticated logins, runs SQL Server Agent jobs, and requires access to the underlying operating system and file system for custom components. The team wants the greatest administrative control over both the database engine and the OS. Which Azure SQL service should they deploy?
SQL Server on Azure Virtual Machines provides Infrastructure-as-a-Service. Administrators manage the full SQL Server installation and the Windows or Linux OS, so they can use Windows authentication, SQL Server Agent, registry edits, file system access, and other custom components. Azure SQL Database (single database or elastic pool) is Platform-as-a-Service and hides the OS layer; these options do not expose SQL Server Agent or allow Windows logins. Azure SQL Managed Instance offers near-full SQL Server compatibility but still runs as PaaS without giving OS-level access, so custom registry or file system changes are not possible. Therefore, SQL Server on Azure Virtual Machines best fits the requirements.
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 SQL Server on Azure Virtual Machines?
Open an interactive chat with Bash
How does SQL Server on Azure Virtual Machines differ from Azure SQL Managed Instance?
Open an interactive chat with Bash
Why can't Azure SQL Database or elastic pools meet the requirements described?
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 .