YOU’RE WORKING WITH AN EXTERNAL VENDOR ON A PATCH TO THEIR APPLICA...

12. You’re working with an external vendor on a patch to their application.

They’ve applied the patch to the test environment and would like to simulate

some production-like workload to assess the success of the patch. You’ve

decided to capture a SQL trace. Which trace template will you use?

A. TSQL_Replay

B. Tuning

C. Standard (default)

D. Capture_test_server

The correct answer is A. The replay trace template was designed for capturing

enough information to replay a trace on another server.