Exam DP-203 topic 4 question 36 discussion

https://github.com/rgl/azure-content/blob/master/articles/sql-data-warehouse/sql-data-warehouse-manage-distributed-data-skew.md

The only option available for a Dedicated Pool is A. The "built-in" always refers to Serverless. PDW_SHOWSPACEUSED is not the best choice to respond the question, but gives a hint about it.

The only option available for a Dedicated Pool is A. The "built-in" always refers to Serverless.

I found this question on my exam 30/04/2024, and I put A. I passed the exam with a high score, but I'm not sure if the answer is correct.

Examtopics chooses --> D. Connect to the built-in pool and query sys.dm_pdw_sys_info. Examtopics explains --> "Use sys.dm_pdw_nodes_db_partition_stats to analyze any skewness in the data" really, non-sense... Correct answer is --> B. Connect to the built-in pool and run DBCC PDW_SHOWSPACEUSED. since you need to use the built-in dedicated SQL pool to launch such a command.

A is correct

Chatgpt : A Option D suggests querying `sys.dm_pdw_sys_info`, which provides information about the SQL pool nodes and their characteristics, rather than details about data distribution or skew within a table. To investigate data skew specifically, you need to understand how the data is distributed across the distributions or partitions of a table, which is not information that `sys.dm_pdw_sys_info` would provide. Therefore, while `sys.dm_pdw_sys_info` could give you insights into the overall system, it would not be the right choice for diagnosing data skew within a specific table. For that purpose, `DBCC PDW_SHOWSPACEUSED` is more appropriate, despite it not being a direct indicator of skew, it can still give you an initial indication based on space usage which might suggest further investigation if there are anomalies.

it's dedicated Pool which basically eliminates all the other options except A

concept repeated , A is correct

sys.dm_pdw_sys_info actually provides a set of appliance-level counters that reflect overall activity on the appliance. DBCC PDW_SHOWSPACEUSED should be use instead since it displays the number of rows, disk space reserved, and disk space used for a specific table, or for all tables in a Azure Synapse Analytics or Analytics Platform System (PDW) database.

Ok, he did the typo for printing D. It should be "Connect to the built-in pool and use sys.dm_pdw_nodes_db_partition_stats"

Read Question 20, Topic 4 - Why examtopics giving 2 different answers for the same question? For Q.20, Topic 4 - it says answer is B here for Q.36, Topic 4 - it says answer is D Examtopics, you first decide what you want to answer.

-Use DBCC PDW_SHOWSPACEUSED for seeing the skewness (each size in distributions, etc) in a table. -By using sys.dm_pdw_request_steps table (dynamic management view, DMV) you can see how the operation is really executed and how long it took. ref: https://tsmatz.wordpress.com/2020/10/07/azure-synapse-analytics-sql-dedicated-pool-performance-distribution-hash/

need to connect Azure Synapse Analytics dedicated SQL pool1 not built-in pool (serverless pool)

A is the answer. Read Question 20, Topic 4

A is the right one!

Answer is A A quick way to check for data skew is to use DBCC PDW_SHOWSPACEUSED. The following SQL code returns the number of table rows that are stored in each of the 60 distributions. For balanced performance, the rows in your distributed table should be spread evenly across all the distributions. https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-distribute