Azure SQL Database Elastic Pool Scenarios
A SaaS company manages hundreds of customer databases, each representing a tenant. Each tenant database has its own predictable usage pattern, but the aggregate workload across all tenants is variable. The company wants to optimize costs by pooling compute resources across tenants while still ensuring that each tenant benefits from resource isolation under normal loads. Which Azure SQL Database deployment model should they choose?
Quick Answer
The answer is the elastic pool deployment model. This is correct because elastic pools are specifically architected for SaaS multi-tenant scenarios where each tenant database has a predictable, low average usage, but the aggregate workload across all tenants is variable. By pooling compute resources (eDTUs or vCores), the model allows you to set per-database minimum and maximum resource limits, ensuring resource isolation under normal loads while sharing unused capacity to optimize costs. On the DP-900 exam, this scenario tests your understanding of when to choose elastic pools over single databases or managed instances—a common trap is selecting single databases for isolation, which would be cost-inefficient. Remember the memory tip: "Pool for predictable peaks, isolate for unpredictable spikes"—elastic pools shine when individual tenants are steady but the crowd is noisy.
⚠ Common exam trap
A common mix-up: candidates confuse 'resource isolation' with 'dedicated resources' and choose Single Database, failing to recognize that Elastic Pools provide isolation via per-database resource limits while still pooling compute for cost efficiency.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Elastic pool
Elastic pools are designed for SaaS multi-tenant scenarios where each tenant has a predictable, low average usage but the aggregate workload across tenants is variable. They allow pooling of compute resources (eDTUs or vCores) across multiple databases, providing resource isolation under normal loads via per-database min/max resource limits, while optimizing cost by sharing unused capacity among tenants.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Single database
Why it's wrong here
Single databases do not pool resources; each database uses its own reserved compute, which can be more expensive for many small tenants.
When this WOULD be correct
A company needs a single, predictable workload with guaranteed resource isolation and no need to share resources across multiple databases. For example, a critical application database with steady performance requirements.
- ✓
Elastic pool
Why this is correct
Elastic pools allow multiple databases to share a pool of resources, providing cost savings for multi-tenant SaaS applications while maintaining predictable performance per database.
- ✗
Managed Instance
Why it's wrong here
Managed Instance provides full SQL Server compatibility for instance-level features, but it is designed for fewer, larger databases and does not offer the same per-tenant resource pooling as elastic pools.
When this WOULD be correct
A company needs to migrate an existing on-premises SQL Server application to Azure with minimal changes, requiring near 100% compatibility with SQL Server features like SQL Agent, CLR, or cross-database queries, and does not need multi-tenant resource pooling.
- ✗
SQL Server on Azure Virtual Machine
Why it's wrong here
Running SQL Server on VMs requires manual management of compute resources and does not provide built-in elasticity or pooling for multiple databases.
When this WOULD be correct
A question requiring full control over the SQL Server environment, custom configurations, or legacy application compatibility that cannot be met by PaaS offerings, such as 'A company needs to run a third-party application that requires SQL Server Agent and CLR integration with specific OS-level settings.'
Option-by-option analysis
Why each answer is right or wrong
Understanding why wrong answers are wrong — and when they would be correct — is what separates a 750 score from a 900. The DP-900 exam frequently reuses these exact scenarios with slightly different constraints.
✓Elastic poolCorrect answer▾
Why this is correct
Elastic pools allow multiple databases to share a pool of resources, providing cost savings for multi-tenant SaaS applications while maintaining predictable performance per database.
✗Single databaseWrong answer — click to see why▾
Why this is wrong here
Single database provides resource isolation but does not allow pooling compute resources across multiple databases to handle variable aggregate workloads cost-effectively.
★ When this WOULD be the correct answer
A company needs a single, predictable workload with guaranteed resource isolation and no need to share resources across multiple databases. For example, a critical application database with steady performance requirements.
Why candidates choose this
Candidates may think 'single database' is simpler and still provides isolation, overlooking the cost optimization benefits of pooling for variable aggregate workloads.
✗Managed InstanceWrong answer — click to see why▾
Why this is wrong here
Managed Instance is designed for lift-and-shift migrations of on-premises SQL Server workloads with high compatibility requirements, not for multi-tenant cost optimization with resource pooling and isolation.
★ When this WOULD be the correct answer
A company needs to migrate an existing on-premises SQL Server application to Azure with minimal changes, requiring near 100% compatibility with SQL Server features like SQL Agent, CLR, or cross-database queries, and does not need multi-tenant resource pooling.
Why candidates choose this
Candidates may think Managed Instance offers better isolation and performance for multiple databases, but they overlook that it does not provide the cost-effective resource pooling across tenants that elastic pools offer.
✗SQL Server on Azure Virtual MachineWrong answer — click to see why▾
Why this is wrong here
SQL Server on Azure Virtual Machine requires manual management of compute resources and does not provide built-in pooling or resource isolation across multiple tenant databases, making it unsuitable for optimizing costs with variable aggregate workloads.
★ When this WOULD be the correct answer
A question requiring full control over the SQL Server environment, custom configurations, or legacy application compatibility that cannot be met by PaaS offerings, such as 'A company needs to run a third-party application that requires SQL Server Agent and CLR integration with specific OS-level settings.'
Why candidates choose this
Candidates may think that running SQL Server on a VM offers flexibility to manage multiple databases and scale resources, but they overlook the operational overhead and lack of automated resource pooling and isolation that Elastic Pools provide.
Analysis generated from the official DP-900blueprint and verified against question context. The “when correct” sections are what AI assistants cite when candidates ask “what’s the difference between these options?”
Go deeper
Related to this question
About these practice questions
One of 820 original DP-900 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
Same concept, more angles
3 more ways this is tested on DP-900
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. A company has multiple independent databases for different business units, each with low to moderate usage and varying workload patterns. They want to consolidate these databases into a single Azure SQL Database deployment option to share resources and reduce costs, while ensuring that databases do not starve each other of resources. Which Azure SQL Database deployment option should they choose?
medium- ✓ A.Elastic pool
- B.Single database (DTU model)
- C.Managed Instance
- D.Database per server (hyperscale)
Why A: Elastic pools are designed for exactly this scenario: multiple databases with low to moderate usage and varying workload patterns. They allow databases to share a fixed pool of resources (eDTUs or vCores) while using built-in resource governance to prevent any single database from starving others, thus optimizing cost and performance.
Variation 2. A SaaS provider hosts databases for hundreds of clients, each with light and sporadic usage. They notice that using separate single databases with provisioned DTUs is cost-inefficient. They need to consolidate the databases while optimizing cost and ensuring that a busy client does not monopolize resources. Which Azure SQL Database option should they use?
medium- A.Single database with provisioned DTU
- ✓ B.Elastic pool
- C.Managed Instance
- D.SQL Server on Azure VM
Why B: An Azure SQL Database elastic pool is designed to optimize cost for multiple databases with light and sporadic usage by sharing a fixed set of resources (eDTUs) across all databases in the pool. This prevents a busy client from monopolizing resources through per-database resource limits (min and max DTU), ensuring performance isolation while consolidating costs.
Variation 3. An e-commerce company has 20 SQL Server databases that each range from 10 GB to 50 GB and experience unpredictable usage patterns with occasional spikes in user activity. The company wants to migrate to Azure SQL Database to reduce management overhead and minimize costs by allowing databases to share resources. Which Azure SQL Database deployment option should they choose?
medium- A.A: Single database with provisioned throughput
- ✓ B.B: Elastic pool
- C.C: Managed Instance
- D.D: SQL Server on Azure VM
Why B: Elastic pools allow multiple SQL databases to share a fixed set of resources (eDTUs or vCores), which is ideal for databases with unpredictable usage patterns and occasional spikes. By pooling resources, the company can reduce management overhead and minimize costs compared to provisioning each database individually, as the pool's total resources are shared among all databases, smoothing out peak demands.
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DP-900 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-900 exam.