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 Pool1 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 klara.se· 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 run DBCC PDW_SHOWSPACEUSED.
BConnect to the built-in pool and run DBCC CHECKALLOC.
CConnect to Pool1 and query sys.dm_pdw_node_status.
DConnect to Pool1 and query sys.dm_pdw_nodes_db_partition_stats.

How the community answered

(24 responses)

A
4% (1)
B
4% (1)
C
8% (2)
D
83% (20)

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#sys.dm_pdw_nodes_db_partition_stats#Synapse dedicated SQL pool#partition distribution

Community Discussion

No community discussion yet for this question.

Full DP-203 Practice