Administering a SQL Database Infrastructure — Question 86

You are the administrator of a Microsoft SQL Server 2016 server. Some applications consume significant resources.
You need to manage the server workload by restricting resource-intensive applications.
You need to dynamically limit resource consumption.
What should you do?

Answer options

• A. Set up Service Broker to ensure that applications are not allowed to consume more than the specified amount of resources.
• B. Configure Resource Pools, Workload Groups, and Classifier Function, and then enable the Resource Governor.
• C. Configure Extended Events to monitor and restrict resource limits allowed by each application type.
• D. Create a new Plan Guide with a Scope Type of sql and define the resource limits for each application.

Correct answer: B

Explanation

The correct answer is B because configuring Resource Pools, Workload Groups, and a Classifier Function allows for dynamic management of resource allocation through the Resource Governor. Options A, C, and D do not provide the same level of dynamic resource management capabilities as the Resource Governor, making them less effective for this specific requirement.