Explanation:The Resource Governor is turned off by default. 7. Which of the following query disables the resource governor ?
A. ALTER RESOURCE GOVERNOR ENABLE CONFIGURE;
B. ALTER GOVERNOR DISABLE;
C. ALTER RESOURCE GOVERNOR DISABLE;
D. None of the mentioned
Answer:A
Explanation:The Resource Governor is turned off by default. 7. Which of the following query disables the resource governor ?
A. ALTER RESOURCE GOVERNOR ENABLE CONFIGURE; B. ALTER GOVERNOR DISABLE; C. ALTER RESOURCE GOVERNOR DISABLE; D. None of the mentioned
Explanation:You can disable the Resource Governor by using either SQL Server Management Studio or Transact-SQL. 8. ____________ is a hard cap limit on the CPU bandwidth for all requests in the resource pool.