70-432 · Question #104
You are the administrator of a SQL Server 2008 instance. The instance has databases for a finance application and a manufacturing application. You want to put some limitation on the maximum CPU…
The correct answer is D. The workload group which is used by the manufacturing application. See the full explanation below for the reasoning.
Question
You are the administrator of a SQL Server 2008 instance. The instance has databases for a finance application and a manufacturing application. You want to put some limitation on the maximum CPU query time allowed by the applications, so you configure the Resource Governor to achieve this. But you notice that certain reports do not execute successfully any longer on the manufacturing application. You have to allow the manufacturing application to consume more CPU time, so you have to change the Resource Governor configuration. Which Resource Governor component should you configure?
Options
- AThe workload group which is used by default
- BThe workload group which is used by the finance application
- CThe classifier function which identifies the finance application
- DThe workload group which is used by the manufacturing application
How the community answered
(57 responses)- A7% (4)
- B14% (8)
- C4% (2)
- D75% (43)
Community Discussion
No community discussion yet for this question.