Notifications
Clear all
Topic starter
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?
- A . region
B. product
C. week
D. month
Suggested Answer: C
Posted : 02/02/2023 2:51 pm