70-447 practice - PrepKeys

Q3 Multiple choice

You are a database administrator for your company. The company has a SQL Server 2005 computer named SQL1. A database on SQL1 stores sales history data for the company's Web-based order system.
Twenty of the business analysts in the company create ad hoc queries against the database. The performance of SQL1 is routinely slow. You need to find out which business analyst is causing the problem.

What are two possible ways to achieve this goal? (Each correct answer presents a complete solution.
Choose two.)

Select all that apply.

A
Run the sp_who system stored procedure.
B
Run SQL Trace system stored procedures to gather database activity.
C
Use the Activity Monitor to view the activity of specific business analysts.
D
Create a trace that uses a predefined template by using SQL Server Profiler.