Microsoft Exam DP-300 Topic 11 Question 106 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 106
Topic #: 11

You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and a database named DB1. DB1 contains a fact table named Table.

You need to identify the extent of the data skew in Table1.

What should you do in Synapse Studio?

AConnect to Pool1 and query sys.dm_pdw_nodes_db_partition_stats.

BConnect to the built-in pool and run DBCC CHECKALLOC.

CConnect to Pool1 and run DBCC CHECKALLOC.

DConnect to the built-in pool and query sys.dm_pdw_nodes_db_partition_stats.

Show Suggested Answer

Suggested Answer: C

by Agustin at Nov 18, 2024, 08:28 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!