Administering Relational Databases on Microsoft Azure — Question 34

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?

Answer options

• A. Sys.dm_exec_query_plan_stats
• B. Sys.dm_db_index_physical_stats
• C. Sys.dm_db_index_operational_stats
• D. Sys.dm_db_index_useage_stats

Correct answer: C

Explanation

The correct answer is C, Sys.dm_db_index_operational_stats, as it provides detailed information about the operations performed on the index, including access statistics. Option A focuses on query plans, option B provides physical statistics of indexes, and option D gives usage statistics, which do not directly address the operational aspects needed to analyze performance issues.