Microsoft Azure Data Fundamentals DP-900 Practice Question
A company is moving several on-premises SQL Server databases to Azure. The databases rely on SQL Server Agent jobs, linked servers, and cross-database queries. The IT team wants a platform-as-a-service offering that keeps these features while reducing day-to-day management tasks. Which Azure relational data service best meets these requirements?
Azure SQL Database (single database or elastic pool)
Azure SQL Managed Instance is a fully managed PaaS service that provides nearly 100 percent compatibility with the SQL Server engine, including support for SQL Server Agent, linked servers, and cross-database queries. Azure SQL Database (single database or elastic pool) is also a PaaS option but lacks several instance-level features such as SQL Server Agent and native cross-database querying. SQL Server on Azure Virtual Machines delivers full SQL Server functionality but requires customers to manage the operating system and database engine, so it is not a true PaaS solution. Azure Database for MySQL is designed for the MySQL engine, not for SQL Server workloads, and therefore does not meet the feature 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 Agent, and why is it important for database management?
Open an interactive chat with Bash
Why is Azure SQL Managed Instance a better option than Azure SQL Database for complex database needs?
Open an interactive chat with Bash
What is the difference between PaaS and IaaS in the context of Azure SQL services?
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 .