This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Choose the best response for each of the questions below.
Which type of execution plan is stored in the plan cache?
Estimated execution plan
Actual execution plan
Live Query Stats
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
Which of the following wait types would indicate excessive CPU consumption?
SOS_SCHEDULER_YIELD
RESOURCE_SEMAPHORE
PAGEIOLATCH_SH
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
You must answer all questions before checking your work.
Was this page helpful?