
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:
Contains one billion rows
Uses a clustered columnstore index
Is hash-distributed on the Product Key column
Has a non-nullable column named Sales Date of the date data type
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?
A
once per month
B
once per year
C
once per day
D
once per week