DP-300 Certification Practice Question #151

Question

You have an Azure SQL database named DB1.

You need to query the fragmentation information of data and indexes for the tables in DB1.

Which command should you run?

Accepted Answer

To check index fragmentation in Azure SQL Database, `sys.dm_db_index_physical_stats` is the recommended and supported Dynamic Management Function (DMF). Although the option is misspelled as `sts.dm_db_index_physical_stats` in Option D, it remains the correct choice because `DBCC SHOWCONTIG` (Option C) is deprecated and unsupported in Azure SQL Database, `sys.dm_db_index_usage_stats` (Option A) tracks usage (seeks, scans, updates) rather than fragmentation, and `DBCC CHECKALLOC` (Option B) checks disk space allocation structures but not index fragmentation.

More DP-300 practice questions