You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and a database named DB1. DB1 contains a fact table named Table1. You need to identify the extent of the data skew in Table1. What should you do in Synapse Studio?
A.
Connect to the built-in pool and query sys.dm_pdw_nodes_db_partition_stats.
B.
Connect to the built-in pool and run DBCC CHECKALLOC.
C.
Connect to Pool1 and query sys.dm_pdw_node_status.
D.
Connect to Pool1 and query sys.dm_pdw_nodes_db_partition_stats.
Copilot
Sent by Copilot:
To identify the extent of the data skew in Table1 within your Azure Synapse Analytics dedicated SQL pool (Pool1), you should:
D. Connect to Pool1 and query sys.dm_pdw_nodes_db_partition_stats.
This system view provides detailed information about the distribution of data across the nodes and partitions, which is essential for analyzing data skew.
To identify the extent of data skew in a table within an Azure Synapse Analytics dedicated SQL pool, you should connect to the specific pool (Pool1) and query the sys.dm_pdw_nodes_db_partition_stats dynamic management view. This view provides detailed information about data distribution across nodes, which is essential for identifying skew.
Built-in Pool Limitation: The built-in pool in Synapse Analytics is typically used for on-demand SQL queries and doesn't have access to the detailed statistics of the dedicated SQL pool's partitioned tables.
sys.dm_pdw_nodes_db_partition_stats is a system view in Azure Synapse Analytics dedicated SQL pool that provides statistics about the distribution of data across distributions (similar to nodes or segments) within the pool.
A is not an option because there's no specific concept of a "built-in pool" in Azure Synapse Analytics dedicated SQL pool context. You connect directly to the SQL pool instance (like Pool1) to execute commands.
Its D!
Official Learning path:Returns page and row-count information for every partition in the current database.
nodes_db_partition_stats
https://learn.microsoft.com/en-us/training/modules/analyze-optimize-data-warehouse-storage-azure-synapse-analytics/2-understand-skewed-data-space-usage
Answer is not so clear!, because I can't see any refernece on built-in pool. What is built-in pool?
Anyway looking at the doc here:
https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-partition-stats-transact-sql?view=sql-server-ver16
that claims: "This syntax is not supported by serverless SQL pool in Azure Synapse Analytics."
So if built-in pool is serverless SQL pool the correct answer should be D (Connect to Pool1 and query sys.dm_pdw_nodes_db_partition_stats).
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.
Ngol
Highly Voted 2 years, 7 months agorenan_ineu
11 months agoanks84
Highly Voted 2 years, 11 months agoahana1074
Most Recent 11 months agoiceberge
1 year agoevangelist
1 year agoevangelist
1 year, 1 month agolearnwell
1 year, 1 month agoMBRSDG
1 year, 4 months agoArdiShah
1 year, 5 months agoArdiShah
1 year, 5 months agoj888
1 year, 5 months agoj888
1 year, 5 months agodakku987
1 year, 7 months agoShrikantW
1 year, 7 months agokkk5566
1 year, 11 months agobp_a_user
2 years, 3 months agoVikram1710
2 years, 5 months agovrodriguesp
2 years, 6 months agoOldSchool
2 years, 9 months agoOldSchool
2 years, 8 months ago