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?
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?
To identify the extent of data skew in Table1 within an Azure Synapse Analytics dedicated SQL pool, you should connect to Pool1 and query the sys.dm_pdw_nodes_db_partition_stats dynamic management view. This system view provides detailed information about data distribution across the different nodes, which is essential for analyzing data skew.
I don't understand why Exam Topics should be giving different answers for questions they have repeated...like this one!
Correct answer is D.
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).
We had the same question before. The correct answer is D
Questione already seen
It can't be A and B because those two are connecting to Built-In pool (serverless) and the Q is about dedicated pool.
If it is the mistake in wording the question and instead of dedicated is serverless, then the answer is A.
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.
Correct, you can only launch DMV and DBCC from built-in, not from pool1
In this series of question, we had the same question and correct answer was D.
D is correct
A built-in pool usually means a dedicated SQL pool, I think A will be my choice.
On second thought the word 'pool1' is more definitive than the simple term 'built-in'. So D is correct
D. Connect to Pool1 and query sys.dm_pdw_nodes_db_partition_stats. bcz its connect to pool1
D is the correct answer!
repetd
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
Option A is confusing as we have different answer for same question.