
Explanation:
The DBCC PDW_SHOWSPACEUSED command in Azure Synapse Analytics dedicated SQL pool reveals how data is distributed across the compute nodes. When examining the results, if some distributions show significantly more data than others (or some distributions have no data at all), this indicates data skew. Data skew occurs when the distribution key chosen for the table does not evenly distribute data across all distributions, leading to some nodes handling more data and processing than others. This can negatively impact query performance as workloads become unbalanced.
Ultimate access to all questions.
You have an Azure Synapse Analytics dedicated SQL pool. You execute the command DBCC PDW_SHOWSPACEUSED('dbo.FactInternetSales'); and receive the results shown in the following image.
Which statement accurately describes the dbo.FactInternetSales table?

A
All distributions contain data.
B
The table contains less than 10,000 rows.
C
The table uses round-robin distribution.
D
The table is skewed.
No comments yet.