05 Chapter 05 DP-300T00A-Trainer-Files-Administering-Relational

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

What type of database design should you use for a data warehouse when you want to reduce the data volume of your dimensions?

• Snowflake schema
• 3rd normal form
• Star Schema

What is the minimum number rows do you need to bulk insert into a columnstore index?

• 102400
• 1000000
• 1000

Which compression type offers the highest level of compression?

• Columnstore Archival
• Row Compression
• Page Compression

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_os_wait_stats
• Sys.dm_exec_session_wait_stats
• Sys.dm_db_index_physical_stats

Which DMV can you use to capture the actual execution plan for a given query?

• sys.dm_exec_query_plan_stats
• sys.dm_exec_cached_plans
• sys.dm_exec_query_plan