What should you run?

You have an Azure Synapse Analytics dedicated SQL pool named SA1 that contains a table named Table1. You need to identify tables that have a high percentage of deleted rows.

What should you run?
A . sys.pdw_nodes_column_store_segments
B . sys.dm_db_column_store_row_group_operational_stats
C . sys.pdw_nodes_column_store_row_groups
D . sys.dm_bd_column_store_row_group_physical_stats

View Answer

Answer: B