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 57 discussion

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

You have a server named Server1 that has 2 processors.
You plan to deploy multiple instances of SQL Server 2014 to Server1. Each instance will have multiple databases.
You need to recommend a method to set limits on processor time for each database.
What should you include in the recommendation?
More than one answer choice may achieve the goal. Select the BEST answer.

  • A. processor affinity
  • B. Max Degree of Parallelism
  • C. Windows System Resource Manager (WSRM)
  • D. Resource Governor
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
SQL Server Resource Governor is a feature than you can use to manage SQL Server workload and system resource consumption. Resource Governor enables you to specify limits on the amount of CPU, physical IO, and memory that incoming application requests can use.
Incorrect answers:
Not A: Processor affinity cannot be used to assign databases to processors.
Not B: The Microsoft SQL Server max degree of parallelism (MAXDOP) configuration option controls the number of processors that are used for the execution of a query in a parallel plan. It is not used limit the processor time for a database.
Not C: You can use Windows System Resource Manager to allocate processor and memory resources to applications, users, Remote Desktop Services sessions, and Internet Information Services (IIS) application pools. You cannot use Windows System Resource Manager to allocate resources for a database.

Reference: Resource Governor -
https://msdn.microsoft.com/en-us/library/bb933866(v=sql.120).aspx
by KiranAChaugule at July 1, 2020, 4:43 p.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
prprgndr
4 years, 4 months ago
Processor Affinity will divide cores to instances / databases. Resource governor will divide CPU time to instances / databases.
upvoted 1 times
...
KiranAChaugule
4 years, 10 months ago
Answer should be A: Processor affinity
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago