DP-203 · Question #301
You have an Azure Synapse Analytics dedicated SQL pool named Pool1. Pool1 contains a fact table named Table1. You need to identify the extent of the data skew in Table1. What should you do in…
The correct answer is A. Connect to Pool1 and run DBCC PDW_SHOWSPACEUSED. Azure Synapse Analytics dedicated SQL pool (formerly known as Azure Synapse Analytics Parallel Data Warehouse) uses a Massively Parallel Processing (MPP) architecture and DBCC PDW_SHOWSPACEUSED is a system stored procedure that can be used to check the distribution of data…
Question
You have an Azure Synapse Analytics dedicated SQL pool named Pool1. Pool1 contains a fact table named Table1. You need to identify the extent of the data skew in Table1. What should you do in Synapse Studio?
Options
- AConnect to Pool1 and run DBCC PDW_SHOWSPACEUSED.
- BConnect to the built-in pool and run DBCC PDW_SHOWSPACEUSED.
- CConnect to Pool1 and run DBCC CHECKALLOC.
- DConnect to the built-in pool and query sys.dm_pdw_sys_info.
How the community answered
(26 responses)- A77% (20)
- B12% (3)
- C8% (2)
- D4% (1)
Explanation
Azure Synapse Analytics dedicated SQL pool (formerly known as Azure Synapse Analytics Parallel Data Warehouse) uses a Massively Parallel Processing (MPP) architecture and DBCC PDW_SHOWSPACEUSED is a system stored procedure that can be used to check the distribution of data across the compute nodes. By running this command on Pool1 and specifying the fact table Table1, you can identify the extent of data skew in Table1 and determine if the data is evenly distributed across the compute nodes or if it is skewed towards a specific node
Topics
Community Discussion
No community discussion yet for this question.