You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and a database named DB1. DB1 contains a fact table named Table1. You need to identify the extent of the data skew in Table1. What…

The correct answer is D. Connect to Pool! and query sys.dm_pdw_nodes_db_partition_stats. Microsoft recommends use of sys.dm_pdw_nodes_db_partition_stats to analyze any skewness in https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/cheat-sheet

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 Pool1 and a database named DB1. DB1 contains a fact table named Table1. You need to identify the extent of the data skew in Table1. What should you do in Synapse Studio?

Options

AConnect to the built-in pool and query sysdm_pdw_sys_info.
BConnect to Pool1 and run DBCC CHECKALLOC.
CConnect to the built-in pool and run DBCC CHECKALLOC.
DConnect to Pool! and query sys.dm_pdw_nodes_db_partition_stats.

How the community answered

(29 responses)

A
7% (2)
B
17% (5)
C
3% (1)
D
72% (21)

Explanation

Microsoft recommends use of sys.dm_pdw_nodes_db_partition_stats to analyze any skewness in https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/cheat-sheet

Topics

#data skew#dedicated SQL pool#dm_pdw_nodes_db_partition_stats#distribution analysis

Community Discussion

No community discussion yet for this question.

Full DP-203 Practice