Microsoft
DP-300 · Question #118
You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and a database named DB1. DB1 contains a fact table named Table. You need to identify the extent of the data skew in Table1. What…
The correct answer is A. Connect to Pool1 and query sys.dm_pdw_nodes_db_partition_stats. First connect to Pool1, not the built-in serverless pool, then use sys.dm_pdw_nodes_db_partition_stats to analyze any skewness in the data. https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/cheat-sheet
Submitted by krish.m· Mar 6, 2026Optimize query performance
Question
You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and a database named DB1. DB1 contains a fact table named Table. You need to identify the extent of the data skew in Table1. What should you do in Synapse Studio?
Options
- AConnect to Pool1 and query sys.dm_pdw_nodes_db_partition_stats.
- BConnect to the built-in pool and run DBCC CHECKALLOC.
- CConnect to Pool1 and run DBCC CHECKALLOC.
- DConnect to the built-in pool and query sys.dm_pdw_nodes_db_partition_stats.
How the community answered
(57 responses)- A93% (53)
- B2% (1)
- C5% (3)
Explanation
First connect to Pool1, not the built-in serverless pool, then use sys.dm_pdw_nodes_db_partition_stats to analyze any skewness in the data. https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/cheat-sheet
Community Discussion
No community discussion yet for this question.