ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-465 All Questions

View all questions & answers for the 70-465 exam
Go to Exam

Exam 70-465 topic 1 question 26 discussion

Actual exam question from Microsoft's 70-465
Question #: 26
Topic #: 1
[All 70-465 Questions]

You have a server named Server1 that has 16 processors.
You plan to deploy multiple instances of SQL Server 2014 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.

  • A. Processor affinity
  • B. Windows System Resource Manager (WSRM)
  • C. Max Degree of Parallelism
  • D. Resource Governor
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
CPU affinity management through Windows System Resource Manager is not recommended for SQL Server multi-instance management. Instead, use the processor affinity settings in SQL Server.
Reference:
Server Properties (Processors Page)
by KiranAChaugule at July 15, 2020, 11:25 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
KiranAChaugule
4 years, 10 months ago
Answer is B.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel