Microsoft
70-432 · Question #206
You administer a Microsoft SQL Server database that hosts an order-processing application. Employees in the order entry group perform real-time data entry for customers. Employees in the reporting…
The correct answer is C. Create a set of views in a new schema, and then alter the queries of the reporting group. See the full explanation below for the reasoning.
Question
You administer a Microsoft SQL Server database that hosts an order-processing application. Employees in the order entry group perform real-time data entry for customers. Employees in the reporting group run historical reports. Employees in the order entry group report of poor performance when the reporting group runs reports. You need to limit the amount of CPU and RAM used by the reporting group. What should you do?
Options
- AImplement Resource Governor by using a Resource Pool assigned to the users of the
- BUse sp_dbmmonitoraddmonitoring to set up a monitoring process to kill the reporting
- CCreate a set of views in a new schema, and then alter the queries of the reporting group
- DImplement Policy Based Management by using the Server Performance facet.
How the community answered
(25 responses)- A12% (3)
- B4% (1)
- C80% (20)
- D4% (1)
Community Discussion
No community discussion yet for this question.