
Ultimate access to all questions.
You have an Azure Synapse Analytics dedicated SQL pool and need to create a fact table named Table1 to store sales data from the last three years. The solution must optimize performance for the following query operations:
Show order counts by week.
Calculate sales totals by region.
Calculate sales totals by product.
Find all the orders from a given month.
Which column should you use to partition Table1?
A
product
B
month
C
week
D
region