Ultimate access to all questions.
You are designing a partition strategy for a fact table in an Azure Synapse Analytics dedicated SQL pool. The table has the following specifications:
Which number of partition ranges provides optimal compression and performance for the clustered columnstore index?