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…
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.