Administering Relational Databases on Microsoft Azure (DP-300) Test 2
© examsiri.com
Question : 40 of 40
Marks:
+1,
-0
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
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
Go to Question: