Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
You have an Azure Synapse Analytics dedicated SQL pool named Pool1 that contains a fact table named Table1. You need to determine the extent of data skew in Table1. What should you do in Synapse Studio?
A
Connect to the built-in pool and query sys.dm_pdw_nodes_db_partition_stats.
B
Connect to Pool1 and run DBCC PDW_SHOWSPACEUSED.
C
Connect to Pool1 and query sys.dm_pdw_node_status.
D
Connect to the built-in pool and query sys.dm_pdw_sys_info.
