Microsoft Azure Data Fundamentals DP-900 Practice Question
An application experiences short, unpredictable bursts of traffic and then remains idle for several hours. You need a Microsoft-hosted relational service that can automatically pause compute during idle periods, resume in roughly a minute when new requests arrive, and bill you only for the compute actually used. Which Azure service meets these requirements?
Azure SQL Database with the serverless compute tier
The serverless compute tier of Azure SQL Database automatically scales up and down based on workload demand. After a configurable idle period (minimum 1 hour) the database pauses, and during that time you pay only for storage. When activity resumes, the service automatically restarts within about a minute, so you are charged for compute only while it is in use. Azure SQL Managed Instance and SQL Server on Azure Virtual Machines run continuously and accrue compute charges whether or not they are busy. Azure Database for PostgreSQL Flexible Server lets you stop the server manually or on a schedule to avoid compute charges, but it does not automatically pause in response to inactivity and therefore does not match the requirement for on-demand auto-pause and auto-resume.
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 Azure SQL Database serverless compute tier?
Open an interactive chat with Bash
What is the difference between Azure SQL Database serverless compute tier and Azure SQL Managed Instance?
Open an interactive chat with Bash
How does Azure SQL Database serverless compare to manually stopping servers in Azure Database for PostgreSQL Flexible Server?
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 .