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 4 Question 63 Discussion

Actual exam question for Microsoft's DP-203 exam
Question #: 63
Topic #: 4
[All DP-203 Questions]

You have an Azure Synapse Analytics dedicated SQL pool.

You need to Create a fact table named Table1 that will store sales data from the last three years. The solution must be optimized for the following query operations:

Show order counts by week.

* Calculate sales totals by region.

* Calculate sales totals by product.

* Find all the orders from a given month.

Which data should you use to partition Table1?

Show Suggested Answer Hide Answer
Suggested Answer: C

Contribute your Thoughts:

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

Save Cancel