Administering a SQL Database Infrastructure — Question 69

You have configured Resource Governor with three resource pools.
You have assigned the first resource pool a minimum CPU and memory value of 20%.
You have assigned the second resource pool a minimum CPU and memory value of 30%.
You want to assign maximum CPU and memory values to the third resource pool.
What is the maximum CPU and memory value you can assign to this resource pool?

Answer options

• A. 30%
• B. 50%
• C. 70%
• D. 100%

Correct answer: B

Explanation

The maximum CPU and memory that can be assigned to the third resource pool must account for the minimum allocations of the first two pools, which total 50%. Therefore, the highest allocation possible for the third pool is 50%. Options A, C, and D exceed this limit, making B the only correct choice.