Microsoft Exam DP-203 Topic 8 Question 34 Discussion

You are designing a partition strategy for a fact table in an Azure Synapse Analytics dedicated SQL pool. The table has the following specifications:

* Contain sales data for 20,000 products.

* Use hash distribution on a column named ProduclID,

* Contain 2.4 billion records for the years 20l9 and 2020.

Which number of partition ranges provides optimal compression and performance of the clustered columnstore index?