DS0-001 · Question #104
A database administrator has configured a Resource Governor with three resource pools. The first resource pool is assigned a minimum CPU and memory value of 25%. The second resource pool is assigned a
The correct answer is B. 40%. Option B (40%) is correct because SQL Server Resource Governor requires that the sum of all minimum CPU and memory allocations across resource pools cannot exceed 100%. With Pool 1 at 25% and Pool 2 at 35%, those two pools consume 60% of the available minimum, leaving exactly 40%
Question
A database administrator has configured a Resource Governor with three resource pools. The first resource pool is assigned a minimum CPU and memory value of 25%. The second resource pool is assigned a minimum CPU and memory value of 35%. The database administrator wants to assign the maximum CPU and the maximum resource pool to the third resource. Which of the following is the maximum memory the database administrator should assign to the third resource?
Options
- A20%
- B40%
- C60%
- D100%
How the community answered
(39 responses)- A5% (2)
- B74% (29)
- C8% (3)
- D13% (5)
Explanation
Option B (40%) is correct because SQL Server Resource Governor requires that the sum of all minimum CPU and memory allocations across resource pools cannot exceed 100%. With Pool 1 at 25% and Pool 2 at 35%, those two pools consume 60% of the available minimum, leaving exactly 40% for Pool 3 - making 40% the maximum minimum allocation possible for the third pool (100% − 60% = 40%).
Why the distractors are wrong:
- A (20%) is a valid allocation but not the maximum - the administrator could assign up to 40%, so 20% wastes available capacity.
- C (60%) would cause the total minimum allocations to reach 120% (25 + 35 + 60), which violates the 100% ceiling.
- D (100%) similarly overshoots, bringing the total to 160% - Resource Governor would reject this configuration.
Memory tip: Think of it as splitting 100 budget points. Once Pools 1 and 2 "claim" their minimums (25 + 35 = 60), only the remainder is available. Whatever's left after subtracting the other pools' minimums from 100 is the max you can give the last pool.
Topics
Community Discussion
No community discussion yet for this question.