Question 274

You have an Azure Synapse Analytics dedicated SQL pool named Pool1. Pool1 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 query sys.dm_pdw_nodes_db_partition_stats.
• BConnect to Pool1 and run DBCC PDW_SHOWSPACEUSED.
• CConnect to Pool1 and query sys.dm_pdw_node_status.
• DConnect to the built-in pool and query sys.dm_pdw_sys_info.