Exam4Training

What should you do?

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

Latest 70-764 Dumps Valid Version with 451 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Exit mobile version