Another explanation to support option B as the most appropriate:
To analyze data skew specifically in a dedicated SQL pool, you should use sys.dm_pdw_nodes_db_partition_stats. The option says "connect to the built-in", but built-in is Serverless and this view is not available for querying from Serverless, even against a Dedicated pool.
Option B (DBCC PDW_SHOWSPACEUSED) is a valid alternative but provides less detailed information about data skew compared to sys.dm_pdw_nodes_db_partition_stats. It is meant to show the space used, as the command implies, but may give an idea about skew.
The built in pool is serverless, we cannot use those A's DMV is not supported by serverless pools, https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-partition-stats-transact-sql?toc=%2Fazure%2Fsynapse-analytics%2Fsql-data-warehouse%2Ftoc.json&bc=%2Fazure%2Fsynapse-analytics%2Fsql-data-warehouse%2Fbreadcrumb%2Ftoc.json&view=azure-sqldw-latest&preserve-view=true
Explanation:
To identify the extent of data skew in a table within an Azure Synapse Analytics dedicated SQL pool, the DBCC PDW_SHOWSPACEUSED command is most appropriate. This command provides information about space usage and data distribution, which can help identify skew. You need to connect to the specific pool (Pool1) to run this command.
It is indeed B:
https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-distribute#determine-if-the-table-has-data-skew
...no. Please read better the resource:
"Create the view dbo.vTableSizes that is shown in the Tables overview article."
the article --> https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-overview#table-size-queries
The cited view indeed uses dm_pdw_nodes_db_partition_stats, so A is the correct answer, not B.
"However, using DBCC commands can be quite limiting. Dynamic management views (DMVs) show more detail than DBCC commands."
upvoted 1 times
...
...
This section is not available anymore. Please use the main Exam Page.DP-203 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Nidie
Highly Voted 1 year, 10 months agorenan_ineu
Most Recent 8 months, 3 weeks agoDanweo
10 months, 3 weeks agoevangelist
10 months, 3 weeks agoAlongi
1 year, 2 months agoTrulysme
1 year, 6 months agokkk5566
1 year, 9 months agopatjoo
1 year, 9 months agoMBRSDG
1 year, 2 months agoMBRSDG
1 year, 2 months ago