Microsoft
DP-203 · Question #33
You have a partitioned table in an Azure Synapse Analytics dedicated SQL pool. You need to design queries to maximize the benefits of partition elimination. What should you include in the Transact-SQL
The correct answer is B. WHERE. When you add the "WHERE" clause to your T-SQL query it allows the query optimizer accesses only the relevant partitions to satisfy the filter criteria of the query - which is what partition elimination is all about.
Submitted by ngozi_ng· Mar 30, 2026Secure, monitor, and optimize data storage and data processing
Question
You have a partitioned table in an Azure Synapse Analytics dedicated SQL pool. You need to design queries to maximize the benefits of partition elimination. What should you include in the Transact-SQL queries?
Options
- AJOIN
- BWHERE
- CDISTINCT
- DGROUP BY
How the community answered
(45 responses)- A9% (4)
- B73% (33)
- C13% (6)
- D4% (2)
Explanation
When you add the "WHERE" clause to your T-SQL query it allows the query optimizer accesses only the relevant partitions to satisfy the filter criteria of the query - which is what partition elimination is all about.
Topics
#partition elimination#query optimization#Synapse SQL pool#WHERE clause
Community Discussion
No community discussion yet for this question.