Notifications
Clear all
Topic starter
09/06/2022 11:40 am
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
Suggested Answer: B