You have an Azure Synapse Analytics dedicated SQL pool. You run PDW_SHOWSPACEUSED('dbo.FactInternetSales'); and get the results shown in the following table. Which statement accurately describes the…

The correct answer is D. The table is skewed. Data skew means the data is not distributed evenly across the distributions. https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data- warehouse-tables-distribute

Submitted by rachelw· Mar 30, 2026Secure, monitor, and optimize data storage and data processing

Question

You have an Azure Synapse Analytics dedicated SQL pool. You run PDW_SHOWSPACEUSED('dbo.FactInternetSales'); and get the results shown in the following table. Which statement accurately describes the table? dbo.FactInternetSales

Exhibit

Options

AAll distributions data.
BThe table contains less than 10,000 rows.
CThe table uses round-robin distribution.
DThe table is skewed.

How the community answered

(14 responses)

A
14% (2)
C
7% (1)
D
79% (11)

Explanation

Data skew means the data is not distributed evenly across the distributions. https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data- warehouse-tables-distribute

Topics

#distribution skew#PDW_SHOWSPACEUSED#dedicated SQL pool#data distribution

Community Discussion

No community discussion yet for this question.

Full DP-203 Practice