Microsoft
DP-203 · Question #216
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?
Sign in or unlock DP-203 to reveal the answer and full explanation for question #216. The question stem and answer options stay visible for context.
Submitted by fatima_kr· Mar 30, 2026Secure, monitor, and optimize data storage and data processing
Question
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?
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
Unlock DP-203 to see the answer
You've previewed enough free DP-203 questions. Unlock DP-203 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#columnstore index#deleted rows#pdw_nodes_column_store_row_groups#dedicated SQL pool DMV