Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
You have a partitioned table in an Azure Synapse Analytics dedicated SQL pool and need to design Transact-SQL queries to maximize partition elimination. What should you include in the queries?
A
JOIN
B
WHERE
C
DISTINCT
D
GROUP BY