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?
As i understand english this sentence: ..based on session request properties, means that resource is based or session not on instance, so the answer is Resouce Governor.
A. Correct: Resource Governor enables you to allocate session requests to different
resources based on the characteristics of the session request properties.
Resource governor !!!!
The SQL Server resource governor classification process assigns incoming sessions to a workload group based on the characteristics of the session.
https://docs.microsoft.com/en-us/sql/relational-databases/resource-governor/resource-governor-classifier-function?view=sql-server-ver15
Assign processor resources on per instance basis means processor affinity.
upvoted 1 times
...
This section is not available anymore. Please use the main Exam Page.70-764 Exam Questions
Log in to ExamTopics
Sign in:
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.
Iva10
Highly Voted 4 years, 11 months agojolsca
Most Recent 4 years, 9 months agoV_karag
4 years, 11 months agoTheSwedishGuy
5 years, 4 months ago