YOU’RE THE ADMINISTRATOR FOR A SQL SERVER USED BY A NUMBER OF DEPAR...

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.