9. You’re the Administrator for a SQL Server used by a number of departments
within your organization. At the end of each month the Accounts department
runs a number of reports that calculate complex ratios and analytics. During
this time other users frequently receive timeouts and poor performance.
What’s the best solution to limit the impact of these CPU-intensive reports
run by Accounts?
A. Implement table partitioning.
B. Separate data and log files.
C. Use Resource Governor.
D. Request Accounting users run reports only at night.
The correct answer is C. Use Resource Governor to configure a maximum
CPU threshold for Accounting users. Answers A and B are good practice,
but won’t necessary limit the impact of accounts’ reports. Answer D is a nice
idea, but couldn’t guarantee this would actually happen.
Bạn đang xem 9. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P163 DOC