What should you include in the Transact-SQL queries?

exams DP-203 V2 DP-203 exam 0 Comments

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

Answer: B