Microsoft Exam Questions

Which dynamic management view should you use?

You need to build CREATE INDEX statements for all the missing indexes that SQL Server has
identified.
Which dynamic management view should you use?

A.
sys.dm_db_index_usage_stats

B.
sys.dm_db_missing_index_details

C.
sys.dm_db_missing_index_columns

D.
sys.dm_db_missing_index_group_stats