Microsoft Azure Solutions Architect Expert AZ-305 Practice Question
Your company is building a multi-tenant SaaS solution hosted in Azure. Each tenant receives its own operational database. You expect about 250 small databases that normally consume roughly 1 DTU but can spike to 60 DTUs for a few hours each month. Management wants to minimize overall compute cost without manual intervention while keeping platform maintenance low. Which Azure relational database deployment option should you recommend?
Provision an Azure SQL Managed Instance in the General Purpose tier and host all tenant databases within the instance.
Deploy all tenant data in a single Azure SQL Database at the Business Critical tier and use workload management to enforce per-tenant limits.
Create an Azure SQL Database elastic pool sized for the combined peak demand and place all tenant databases in the pool.
Deploy each tenant database as an individual Azure SQL Database in the serverless compute tier with auto-pause enabled.
An Azure SQL Database elastic pool lets many databases share a pool of compute and storage (measured as eDTUs or vCores). Because tenant workloads peak at different times, the pool can be sized for the combined, rather than individual, demand. When a particular tenant experiences a spike, the service automatically allocates additional compute from the shared pool, while idle databases consume virtually no resources-reducing total cost and operational effort. Running every tenant as an individual serverless database would bill each database separately for its active compute, eliminating the benefit of resource sharing. Hosting all data in a single large database or in a managed instance would reserve dedicated compute continuously, driving costs higher. Therefore, an appropriately sized Azure SQL Database elastic pool best meets the requirements for cost efficiency, automatic bursting, and minimal maintenance.
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 an Azure SQL Database elastic pool?
Open an interactive chat with Bash
How do DTUs work in an Azure SQL Database elastic pool?
Open an interactive chat with Bash
Why is a serverless compute tier not ideal for multi-tenant SaaS solutions?
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 .