nerdexam
Microsoft

70-459 · Question #18

You have a server named Server1 that has 16 processors. You plan to deploy multiple instances of SQL Server 2012 to Server1. You need to recommend a method to allocate processors to each instance…

The correct answer is B. Processor affinity. See the full explanation below for the reasoning.

Question

You have a server named Server1 that has 16 processors. You plan to deploy multiple instances of SQL Server 2012 to Server1. You need to recommend a method to allocate processors to each instance. What should you include in the recommendation? More than one answer choice may achieve the goal. Select the BEST answer.

Options

  • AMax Degree of Parallelism
  • BProcessor affinity
  • CWindows System Resource Manager (WSRM)
  • DResource Governor

How the community answered

(36 responses)
  • A
    8% (3)
  • B
    72% (26)
  • C
    17% (6)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 70-459 Practice