Free Microsoft Azure DP-300 Actual Exam Questions - Question 4 Discussion
You have an Azure SQL database named DBI 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? 
Maybe D, since it might give stats on how queries are interacting with the index during execution. C seems focused on locks, but D could show actual operations causing delays.
Good point on C showing detailed operational data. I’d add B isn’t enough since it just tracks how often indexes are used, not what’s happening during queries. C is the only one with in-depth lock and latch info, so C.
Makes sense, C gives deeper operational details beyond just usage stats. C
I think it’s B because sys.dm_db_index_usage_stats mainly shows usage counts, not detailed operations. To see actual index operations like locks, C fits better. So, C makes more sense here.
C imo, because sys.dm_db_index_operational_stats gives detailed info on how indexes are being used, like locks and latches, which fits the need to identify operations on index1. The others focus more on usage stats or missing indexes, not the actual index operations.
B