YOU ARE RESPONSIBLE FOR A SYSTEM THAT IS USED FOR BOTH ONLINE TRAN...

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.