DP-300 · Question #119
DP-300 Question #119: Real Exam Question with Answer & Explanation
The correct answer is D: The table is skewed.. The rows per distribution can vary up to 10% without a noticeable impact on performance. Here the distribution varies more than 10%. It is skewed. Note: SHOWSPACEUSED displays the number of rows, disk space reserved, and disk space used for a specific table, or for all tables in
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?
Options
- AThe table contains less than 10,000 rows.
- BAll distributions contain data.
- CThe table uses round-robin distribution
- DThe table is skewed.
Explanation
The rows per distribution can vary up to 10% without a noticeable impact on performance. Here the distribution varies more than 10%. It is skewed. Note: SHOWSPACEUSED displays the number of rows, disk space reserved, and disk space used for a specific table, or for all tables in a Azure Synapse Analytics or Parallel Data Warehouse database. This is a very quick and simple way to see the number of table rows that are stored in each of the 60 distributions of your database. Remember that for the most balanced performance, the rows in your distributed table should be spread evenly across all the distributions. ROUND_ROBIN distributed tables should not be skewed. Data is distributed evenly across the nodes by design. https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data- warehouse-tables-distribute https://github.com/rgl/azure-content/blob/master/articles/sql-data-warehouse/sql-data-warehouse- manage-distributed-data-skew.md
Community Discussion
No community discussion yet for this question.