DP-300 Certification Practice Question #128

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 dbo.FactInternetSales table?

Accepted Answer

The `DBCC PDW_SHOWSPACEUSED` command output shows the distribution of rows across the 60 Azure Synapse Analytics SQL pool distributions. In the provided output, we see a significant imbalance: some distributions contain thousands of rows (e.g., Distribution 7 has 5,995 rows and Distribution 10 has 3,008 rows), while others contain exactly zero rows (e.g., Distributions 8, 56, and 58). This uneven distribution of rows across distributions is the definition of data skew, which can lead to performance bottlenecks where a subset of distributions does most of the query processing.

More DP-300 practice questions