What should you include in the Transact-SQL queries?

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?
A . JOIN
B. WHERE
C. DISTINCT
D. GROUP BY

View Answer

Answer: B