You have run a server side trace that created 45 trace files. You want to load the trace files on your
workstation in a database table called PerfData for further analysis. You need to load three files
starting at
c:\my_trace_38.trc.
Which TransactSQL
statement should you use?

You are using SQL Server Profiler to gather deadlock information. You need to capture an XML
description of a deadlock. Which event should you use?

You are troubleshooting query performance on SQL Server 2008. You have profiler trace data in
a table named PerfData. You need to determine which events are taking longer than one second of
CPU
time or run for more than two seconds.
Which TransactSQL
statement should you use?

You are using the Database Engine Tuning Advisor (DTA) to analyze a workload. You need to save
the recommendations generated by the DT

You need to capture and record a workload for analysis by the Database Engine Tuning Advisor
(DTA). Which tool should you use?

You have a database that uses stored procedures to perform INSERT, UPDATE, DELETE, and
SELECT statements. You are tasked with providing a recommendation of indexes to be created and
dropped from the database. You need to select the appropriate method to accomplish the task.
Which method should you use?

You are tasked with creating a workload that will be used by the Database Engine Tuning Advisor
(DTA).
You need to create a workload in an appropriate format.
Which format should you choose? (Each correct answer represents a complete solution. Choose
three.)

You need to build CREATE INDEX statements for all the missing indexes that SQL Server has
identified.
Which dynamic management view should you use?

You notice that a database server is responding slowly to queries. You run the following dynamic
management views (DMV) query on the server. SELECT TOP (10)
wait_type,
wait_time_ms
FROM sys.dm_os_wait_stats
ORDER BY wait_time_ms DESC;
The query returns a top wait type of SOS_SCHEDULER_YIELD.
You need to identify what is causing the server response issues. Which resource should you
investigate
first?

You attempt to query sys.dm_db_index_usage_stats to check the status on the indexes in the
Contoso database. The query fails and you receive the following error:
“The user does not have permission to perform this action.”
You need to have the least amount of permissions granted to access the dynamic management
views.
Which permissions should be granted?