Answer E is correct. sys.dm_db_index_usage_stats returns counts of different types of index operations and the time each type of operation was last performed. sys.dm_fts_index_population returns information about the full-text index populations currently in progress. sys.dm_exec_query_stats returns aggregate performance statistics for cached query plans. sys.dm_db_index_physical_stats returns size and fragmentation information. sys.dm_db_physical_stats returns page and row-count information. For more information, see the following sources:
|