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?

The correct answer is C. sys.pdw_nodes_column_store_row_groups. Use sys.pdw_nodes_column_store_row_groups to determine which row groups have a high percentage of deleted rows and should be rebuilt. Note: sys.pdw_nodes_column_store_row_groups provides clustered columnstore index information on a per-segment basis to help the administrator…

Submitted by fatima_kr· Mar 30, 2026Secure, monitor, and optimize data storage and data processing

Question

Options

Asys.pdw_nodes_column_store_segments
Bsys.dm_db_column_store_row_group_operational_stats
Csys.pdw_nodes_column_store_row_groups
Dsys.dm_db_column_store_row_group_physical_stats

How the community answered

(21 responses)

A
5% (1)
B
14% (3)
C
76% (16)
D
5% (1)

Explanation

Use sys.pdw_nodes_column_store_row_groups to determine which row groups have a high percentage of deleted rows and should be rebuilt. Note: sys.pdw_nodes_column_store_row_groups provides clustered columnstore index information on a per-segment basis to help the administrator make system management decisions in Azure Synapse Analytics. sys.pdw_nodes_column_store_row_groups has a column for the total number of rows physically stored (including those marked as deleted) and a column for the number of rows marked as deleted.

Topics

#columnstore index#deleted rows#pdw_nodes_column_store_row_groups#dedicated SQL pool DMV

Community Discussion

No community discussion yet for this question.

Full DP-203 Practice