How to Guarantee Minimum Resources for a Critical Database in an Elastic Pool
You have an Azure SQL Database that is part of an elastic pool. You notice that the pool's eDTU consumption is consistently high, and some databases are experiencing resource contention. You need to ensure that a critical database always gets a minimum amount of resources. What should you configure?
Quick Answer
The answer is to configure per-database min eDTU for the critical database. This setting guarantees a baseline level of resources by reserving a specific amount of eDTU for that database, even when the elastic pool is under high contention, ensuring it never starves for compute or IO. In contrast, per-database max eDTU only caps usage, and simply increasing the pool’s total DTU does not guarantee any single database gets those resources. On the DP-300 exam, this scenario tests your understanding of resource governance within elastic pools, where the common trap is confusing min (guarantee) with max (limit). A memory tip: think of “min” as a floor that holds up your critical database, while “max” is a ceiling that holds it back.
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
✓
Configure per-database min eDTU for the critical database
Per-database min eDTU guarantees a minimum level of resources for a specific database within an elastic pool, ensuring that critical databases get the required resources even when the pool is under high utilization. Option A is incorrect because per-database max eDTU only limits the maximum resource usage, not guaranteeing any minimum. Option B is incorrect because increasing the pool's eDTU provides more total resources but does not guarantee that any single database receives a specific amount. Option C is incorrect because while moving to a dedicated service tier would guarantee resources, it is more expensive and unnecessary if the critical database only needs a minimum resource guarantee within the existing pool.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Configure per-database max eDTU for the critical database
Why it's wrong here
Max eDTU limits, does not guarantee resources.
- ✗
Increase the eDTU of the elastic pool
Why it's wrong here
Increases overall resources but does not guarantee for a specific database.
- ✗
Move the critical database to a dedicated service tier
Why it's wrong here
This may solve contention but is more costly than using min eDTU.
- ✓
Configure per-database min eDTU for the critical database
Why this is correct
Min eDTU guarantees a minimum amount of resources.
Go deeper
Related to this question
Learn chapter
Overview of Azure Data Platform Options
Key term
Azure SQL Performance Tuning
Azure SQL Performance Tuning is the process of optimizing the speed and efficiency of queries and database operations in Microsoft Azure SQL Database or SQL Managed Instance to reduce latency and improve throughput.
About these practice questions
One of 906 original DP-300 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
1 more way this is tested on DP-300
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. Your organization uses Azure SQL Database with elastic pools. One of the databases in the pool, 'OrdersDB', consistently uses more eDTUs than other databases, causing performance degradation for other databases. You need to isolate the resource usage of 'OrdersDB' to prevent it from affecting others. The solution should minimize cost and administrative overhead. What should you do?
hard- A.Purchase reserved capacity for the pool to reduce costs.
- B.Use Query Store to identify and kill the high-usage queries.
- ✓ C.Move 'OrdersDB' to a higher service tier, such as a standalone database with a higher DTU limit.
- D.Increase the eDTU limit of the elastic pool to accommodate the high usage.
Why C: Moving 'OrdersDB' to a standalone database with a higher DTU limit isolates its resource usage, preventing it from affecting other databases in the elastic pool. This approach minimizes administrative overhead as it's a straightforward configuration change. Option A is incorrect because purchasing reserved capacity is a billing benefit, not a resource isolation mechanism. Option B is incorrect because Query Store can identify high-usage queries but cannot limit resource consumption. Option D is incorrect because increasing the pool's eDTU limit would increase costs, and the high-usage database could still consume resources and affect others within the pool.
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DP-300 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-300 exam.