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.
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.
Was this page helpful?