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:
Which column should you use to partition Table1
?