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 that contains a fact table named Table1. You need to determine the extent of data skew in Table1. What should you run in Synapse Studio?
A
Connect to the built-in pool and run DBCC PDW_SHOWSPACEUSED.
B
Connect to the built-in pool and run DBCC CHECKALLOC.
C
Connect to Pool1 and query sys.dm_pdw_node_status.
D
Connect to Pool1 and query sys.dm_pdw_nodes_db_partition_stats.