Administering a SQL Database Infrastructure — Question 128

Which feature should you enable and configure so session requests addressed to a specific instance can be allocated different processor resources based on session request properties?

Answer options

• A. Resource Governor
• B. Windows System Resource Manager
• C. Processor affinity
• D. I/O affinity

Correct answer: A

Explanation

The Resource Governor is designed to manage SQL Server workload and system resource consumption, allowing for different processing resources to be allocated based on session characteristics. The other options, while related to resource management, do not provide the same level of granularity for session-specific resource allocation as the Resource Governor does.