Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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?
A
Connect to the built-in pool and run sys.dm_pdw_nodes_db_partition_stats.
B
Connect to Pool1 and run DBCC CHECKALLOC.
C
Connect to the built-in pool and run DBCC CHECKALLOC.
D
Connect to Pool1 and query sys.dm_pdw_nodes_db_partition_stats.