Microsoft Azure Solutions Architect Expert AZ-305 Practice Question
You are designing a relational data store for a new Azure-hosted web application that experiences highly unpredictable traffic, with brief spikes in demand and long periods of minimal activity. The solution must be a fully managed PaaS offering that can automatically scale compute up or down in response to workload, pause when idle to reduce cost, and support point-in-time restore for at least seven days. Which Azure database service and compute tier should you recommend?
Azure SQL Managed Instance in the Business Critical service tier
Azure SQL Database with the serverless compute tier in the General Purpose service tier
Azure Database for MariaDB in the Basic pricing tier
Azure SQL Database in the Hyperscale service tier with provisioned compute
Azure SQL Database in the serverless compute tier (within the General Purpose service tier) is specifically designed for variable or intermittent workloads. It automatically scales compute based on actual usage, charges per second for the compute consumed, and can be configured to auto-pause after a defined period of inactivity, resuming transparently when activity returns. The service includes automated backups with a default seven-day point-in-time restore window, satisfying the data protection requirement. The Hyperscale tier and Managed Instance Business Critical use provisioned compute that runs-and incurs cost-continuously, and they do not support auto-pause. Azure Database for MariaDB Basic is a separate engine that also lacks auto-scaling and auto-pause capabilities required in this scenario.
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 Azure SQL Database with the serverless compute tier?
Open an interactive chat with Bash
What is point-in-time restore, and how does it work in Azure SQL Database?
Open an interactive chat with Bash
How does the serverless compute tier compare to the provisioned compute model?
Open an interactive chat with Bash
Microsoft Azure Solutions Architect Expert AZ-305
Design data storage solutions
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 .