
Ultimate access to all questions.
You have an Azure Synapse Analytics dedicated SQL pool with a table named Table1. The table has the following properties:
Thirty million new rows are added to Table1 monthly. You plan to partition Table1 on the Sales Date column to optimize both query performance and data loading.
How often should you create a partition?