You work as a database administrator at ABC.com.ABC.com makes use of a SQL Server 2008 R2
instance.
ABC.com contains quite a few databases that are utilized by applications. You are planning to
make use of the Resource Governor to cut the result of searches. These searches are run via
SQL Server Management Studio.
You have been instructed to make sure that the CPU utilization for searches done by the SQL
Server Management Studio should not be more than 40 %. You also have to make sure that in the
event of the applications requiring all of the CPU resources, they are permitted to do so when
necessary.
Which of the following actions should you take FIRST?
A.
You should consider developing a new resource pool.
B.
You should consider setting up the MAX_CPU_PERCENT selection to 40.
C.
You should consider assigning the resource pool to the workload group.
D.
You should consider setting up the MAX_CPU_PERCENT selection to 100.
E.
You should consider assigning the resource pool to the administrators group.
Explanation: