Administering a SQL Database Infrastructure — Question 184

Which feature should you enable and configure so session requests addressed to a specific instance can be allocated to 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: C

Explanation

The correct answer is C, Processor affinity, as it allows specific processor resources to be allocated based on session request properties. Options A and B, Resource Governor and Windows System Resource Manager, manage resources but do not specifically address session requests in this manner. Option D, I/O affinity, relates to input/output operations rather than processor allocation.