Ultimate access to all questions.
You are designing an inventory updates table with a clustered columnstore index in an Azure Synapse Analytics dedicated SQL pool. The table has the following columns:
The identified usage patterns are:
To minimize query times, on which column should you partition the table?