Posted by: Pdfprep
Post Date: June 5, 2021
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