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

2 days ago

I'm not sure, but I think A) is the best choice too. It seems like the most logical way to analyze the data skew.

upvoted 0 times

...

3 days ago

I agree with Laila. That option makes sense because we need to identify the data skew in the table.

upvoted 0 times

...

4 days ago

Hmm, I think option A is the way to go. Querying sys.dm_pdw_nodes_db_partition_stats seems like the direct approach to identifying data skew.

upvoted 0 times

...

4 days ago

I think the answer is A) Connect to Pool1 and query sys.dm_pdw_nodes_db_partition_stats.

upvoted 0 times

...