FEFreeExamDumps.in

Data Engineering on Microsoft Azure

Topic 4

Question 265

DP-203 voucher + Udemy course (lifetime access) = ₹3,500 for Indian ID card holders.

Details →

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 Pool1 and DBCC PDW_SHOWSPACEUSED.
  • BConnect to the built-in pool and run DBCC PDW_SHOWSPACEUSED.
  • CConnect to the built-in pool and run DBCC CHECKALLOC.
  • DConnect to the built-in pool and query sys.dm_pdw_sys_info.