DP-300 Certification Practice Question #148

Question

You have an Azure SQL database named DB1 that contains a nonclustered index named index1.

End users report slow queries when they use index1.

You need to identify the operations that are being performed on the index.

Which dynamic management view should you use?

Accepted Answer

The question asks to "identify the operations being performed on the index." `sys.dm_db_index_operational_stats` returns granular operational counters: insert counts, delete counts, update counts, range scan counts, singleton lookups, and I/O waits at the B-tree leaf and non-leaf level. This is more appropriate for diagnosing *what operations* are occurring on an index. `sys.dm_db_index_usage_stats` returns high-level seek/scan/lookup/update counts since last SQL restart — less useful for diagnosing slow queries on a specific index. The Suggested Answer C and most community votes confirm C.

More DP-300 practice questions