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 the data skew in Table1.
What should you run in Synapse Studio?
A
Connect to Pool1 and run DBCC PDW_SHOWSPACEUSED.
B
Connect to the built-in pool and run DBCC PDW_SHOWSPACEUSED.
C
Connect to Pool1 and run DBCC CHECKALLOC.
D
Connect to the built-in pool and query sys.dm_pdw_sys_info.
