nerdexam
Microsoft

70-465 · Question #76

You need to enable the Developers to assign SQL Server instances on MainDB3 and MainDB4 to specific processors on the servers. What should you configure?

The correct answer is D. Processor Affinity. To assign SQL Server instances to specific processors on the servers, you should configure Processor Affinity.

Submitted by akirajp· Mar 5, 2026Design and implement database solutions for SQL Server

Question

You need to enable the Developers to assign SQL Server instances on MainDB3 and MainDB4 to specific processors on the servers. What should you configure?

Options

  • AWindows System Resource Manager (WSRM)
  • BResource Governor
  • CA Maintenance Plan
  • DProcessor Affinity

How the community answered

(48 responses)
  • A
    4% (2)
  • B
    2% (1)
  • C
    10% (5)
  • D
    83% (40)

Why each option

To assign SQL Server instances to specific processors on the servers, you should configure Processor Affinity.

AWindows System Resource Manager (WSRM)

Windows System Resource Manager (WSRM) is used to manage and allocate server resources among users and applications at a higher level, rather than directly binding a specific process to particular CPU cores.

BResource Governor

Resource Governor is a SQL Server feature used to manage resource consumption (CPU, I/O, memory) *within* a SQL Server instance for different workloads, not to assign the SQL Server instance itself to specific processors on the host.

CA Maintenance Plan

A Maintenance Plan in SQL Server is used for automating administrative tasks like backups, index rebuilding, and integrity checks, and has no functionality related to processor assignment.

DProcessor AffinityCorrect

Processor affinity is an operating system feature that allows you to bind a specific process, such as a SQL Server instance, to run on a designated set of CPUs or CPU cores. This directly fulfills the requirement of assigning SQL Server instances to specific processors on the server.

Concept tested: SQL Server Processor Affinity Configuration

Source: https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/affinity-mask-server-configuration-option

Topics

#SQL Server performance#Processor affinity#Resource management

Community Discussion

No community discussion yet for this question.

Full 70-465 Practice