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?
Currently there are no comments in this discussion, be the first to comment!