Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Free Preparation Discussions
MENU
Microsoft Exam DP-203 Topic 8 Question 34 Discussion
Actual exam question for
Microsoft's
DP-203 exam
Question #: 34
Topic #: 8
[All DP-203 Questions]
Topic #: 8
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?
Suggested Answer:
B
Currently there are no comments in this discussion, be the first to comment!