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

6 days ago

I agree with Arletta. Going with option C and connecting to Pool1 to run DBCC CHECKALLOC seems like the logical choice here.

upvoted 0 times

...

8 days ago

I'm not sure about using the built-in pool for this task. Shouldn't we be focusing on the dedicated SQL pool where the actual table resides?

upvoted 0 times

...

12 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

...

13 days ago

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

upvoted 0 times

...

14 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

...

14 days ago

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

upvoted 0 times

...