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?
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.
Answer: B