Microsoft
70-432 · Question #206
70-432 Question #206: Real Exam Question with Answer & Explanation
Sign in or unlock 70-432 to reveal the answer and full explanation for question #206. The question stem and answer options stay visible for context.
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.
Unlock 70-432 to see the answer
You've previewed enough free 70-432 questions. Unlock 70-432 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.