Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

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]

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?

Show Suggested Answer Hide Answer
Suggested Answer: B

Contribute your Thoughts:

Currently there are no comments in this discussion, be the first to comment!

Save Cancel