Administering Microsoft SQL Server 2012/2014 Databases — Question 52

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: D

Explanation

The maximum CPU and memory values for the third resource pool can be set to 100% because the total resource allocation can reach up to 100%. Since the first and second pools are assigned 20% and 30% respectively, this leaves 50% available for the third pool, but it can still utilize the full 100% if needed.