Knowledge check

1.

Which type of execution plan is stored in the plan cache?

Estimated execution plan

Actual execution plan

Live Query Stats

2.

Which DMV should you use to find index utilization?

sys.dm_db_index_usage_stats

sys.dm_db_missing_index_details

sys.dm_exec_query_plan_stats

3.

Which of the following wait types would indicate excessive CPU consumption?

SOS_SCHEDULER_YIELD

RESOURCE_SEMAPHORE

PAGEIOLATCH_SH

4.

Which isolation level should you choose if you want to prevent users reading data from blocking users writing data?

Serializable

Read Committed Snapshot Isolation

Repeatable Read

Check your knowledge