Microsoft Azure Solutions Architect Expert AZ-305 Practice Question
You are designing the data storage layer for a multi-tenant SaaS application that on-boards and off-boards customer databases frequently. Each tenant requires its own relational database. Workload is unpredictable: databases can be idle for hours and then experience sudden bursts of activity. Management mandates the following:
Minimize cost during idle periods without manual intervention.
Automatically scale compute based on workload demand.
Achieve an SLA of 99.99 percent availability per database. Which Azure SQL offering should you recommend for the tenant databases?
Azure Database for MySQL flexible server in the Burstable tier
Azure SQL Database provisioned vCore in an elastic pool
Azure SQL Database in the serverless compute tier
Azure SQL Managed Instance (General Purpose tier) with autoscale enabled
Azure SQL Database configured in the serverless compute tier is designed for variable or intermittent workloads. Serverless can automatically pause when a database is idle, charging only for storage during the pause, and automatically resume and scale compute in seconds when activity resumes. Compute is billed per second, so costs drop significantly during idle periods. The service maintains the standard 99.99 percent availability SLA that applies to single databases. By contrast, a provisioned vCore single database or an elastic pool continues to incur compute charges even when idle, and Azure SQL Managed Instance does not support automatic pause/resume. Azure Database for MySQL is not appropriate because the requirement is for SQL Server-compatible relational databases.
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 serverless compute tier?
Open an interactive chat with Bash
How does Azure SQL Database achieve its 99.99% SLA?
Open an interactive chat with Bash
Why is Azure SQL Database serverless better than elastic pools for unpredictable workloads?
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 .