Data Engineering on Microsoft Azure — Question 16

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?

Answer options

• A. JOIN
• B. WHERE
• C. DISTINCT
• D. GROUP BY

Correct answer: B

Explanation

The correct answer is B, as using a WHERE clause allows for filtering on partitioned columns, enabling the query to skip irrelevant partitions. Options A, C, and D do not directly facilitate partition elimination, as they do not restrict the data being accessed based on partitioning criteria.