Knowledge check

Choose the best response for each of the questions below.

Check your knowledge

What type of index is best used on a data warehouse fact table?

Clustered Columnstore

Nonclustered Columnstore

Clustered b-tree

Which DMV provides information about server level wait statistics?

sys.dm_db_index_physical_stats

sys.dm_os_wait_stats

sys.dm_exec_session_wait_stats

Which DMV can you use to capture the last Actual Execution Plan for a given query?

sys.dm_exec_cached_plans

sys.dm_exec_query_plan

sys.dm_exec_query_plan_stats

You must answer all questions before checking your work.