Microsoft Azure Data Fundamentals DP-900 Practice Question
You must choose an Azure relational service that provides almost complete feature compatibility with the SQL Server engine, allows use of SQL Agent jobs, and handles OS and database patching for you. Which Azure service meets these requirements?
Azure SQL Managed Instance delivers a fully managed platform as a service experience while maintaining nearly 100 percent compatibility with the latest on-premises SQL Server engine. Because it is PaaS, Microsoft performs operating-system and database patching, backups, and routine maintenance. Managed Instance also exposes SQL Server Agent, enabling scheduled jobs in the same way as an on-premises deployment. Azure SQL Database is also managed, but it does not include SQL Agent and lacks certain engine features. SQL Server on Azure Virtual Machines gives full engine compatibility and SQL Agent; however, the customer is responsible for patching and maintenance because the service runs as an IaaS VM. Azure Database for PostgreSQL is a different database engine altogether and therefore 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 main difference between PaaS and IaaS in Azure services?
Open an interactive chat with Bash
What is SQL Server Agent, and why is it useful?
Open an interactive chat with Bash
What makes Azure SQL Managed Instance different from Azure SQL Database?
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 .