Test Index

Administering Relational Databases on Microsoft Azure (DP-300) Test 2

© examsnet.com

Question : 40

Total: 40

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?
A. sys.dm_exec_query_plon_stots
B. Sys.dm_db_index_physical_stats
C. Sys.dm_db_index_operational_stats
D. Sys.dm_db_index_useage_stats

Option A
Option B
Option C
Option D

Go to Question:

Prev Question

More Free Exams: