Microsoft Exam DP-203 Topic 4 Question 63 Discussion

You have an Azure Synapse Analytics dedicated SQL pool.

You need to Create a fact table named Table1 that will store sales data from the last three years. The solution must be optimized 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 data should you use to partition Table1?