DP-300 · Question #240
DP-300 Question #240: Real Exam Question with Answer & Explanation
The correct answer is D: Sys.dm_db_index_useage_stats. Every individual seek, scan, lookup, or update on the specified index by one query execution is counted as a use of that index and increments the corresponding counter in this view. Information is reported both for operations caused by user-submitted queries, and for operations c
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?
Options
- ASys.dm_exec_query_plan_stats
- BSys.dm_db_index_physical_stats
- CSys.dm_db_index_operational_stats
- DSys.dm_db_index_useage_stats
Explanation
Every individual seek, scan, lookup, or update on the specified index by one query execution is counted as a use of that index and increments the corresponding counter in this view. Information is reported both for operations caused by user-submitted queries, and for operations caused by internally generated queries, such as scans for gathering statistics. https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management- views/sys-dm-db-index-usage-stats-transact-sql?view=sql-server-ver16#remarks
Community Discussion
No community discussion yet for this question.