Microsoft Azure Data Fundamentals DP-900 Practice Question
Your company plans to migrate its on-premises SQL Server workload to Microsoft Azure. The solution must continue to support SQL Server Reporting Services (SSRS) and custom CLR assemblies, and administrators must be able to access the Windows operating system to install third-party agents. Which Azure SQL deployment option should you recommend?
SQL Server on Azure Virtual Machines
Azure SQL Database (single database or elastic pool)
SQL Server on Azure Virtual Machines runs the full SQL Server engine on a managed Azure VM, giving administrators operating-system level access. This allows installation of SSRS, deployment of custom CLR assemblies, and use of any SQL Server feature exactly as on-premises. Azure SQL Managed Instance and Azure SQL Database are Platform as a Service offerings: they provide automatic patching and backups but do not grant OS access, nor do they host SSRS or allow installing custom extensions. Azure Database for PostgreSQL is a different database engine entirely, so it cannot meet SQL Server-specific 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 Reporting Services (SSRS)?
Open an interactive chat with Bash
What are custom CLR assemblies in SQL Server?
Open an interactive chat with Bash
Why is Windows OS access required for third-party agents in Azure SQL deployments?
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 .