Question 127
DP-300 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 Table. You need to identify the extent of the data skew in Table1. What should you do in Synapse Studio?
- AConnect to Pool1 and query sys.dm_pdw_nodes_db_partition_stats.
- BConnect to the built-in pool and run DBCC CHECKALLOC.
- CConnect to Pool1 and run DBCC CHECKALLOC.
- DConnect to the built-in pool and query sys.dm_pdw_nodes_db_partition_stats.