Question 257
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 sys.dm_pdw_nodes_db_partition_stats.
- BConnect to Pool1 and run DBCC CHECKALLOC.
- CConnect to the built-in pool and run DBCC CHECKALLOC.
- DConnect to Pool1 and query sys.dm_pdw_nodes_db_partition_stats.