12. You are responsible for a system that is used for both online transaction
processing (OLTP) and reporting. When reports run on the server, the OLTP
process slows way down. How can you allow reports to be run on the server
and minimize impact to the OLTP processes?
A. Use the Resource Governor
B. Use a DDL trigger
C. Use a DML trigger
D. Use processor affinity masks
A is the correct answer. The Resource Governor allows you to assign
workloads to different groups, then assign a priority to those groups.
Answers B and C are incorrect. Triggers cannot be used for this purpose.
Answer C is incorrect. Processor affinity masks cannot be used for this
purpose.
Bạn đang xem 12. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P141 DOC