Question 244
DP-203 voucher + Udemy course (lifetime access) = ₹3,500 for Indian ID card holders.
Details →You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and a database named DB1. DB1 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?
- AConnect to the built-in pool and run DBCC PDW_SHOWSPACEUSED.
- BConnect to the built-in pool and run DBCC CHECKALLOC.
- CConnect to Pool1 and query sys.dm_pdw_node_status.
- DConnect to Pool1 and query sys.dm_pdw_nodes_db_partition_stats.