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 4 Question 63 Discussion
Actual exam question for
Microsoft's
DP-203 exam
Question #: 63
Topic #: 4
[All DP-203 Questions]
Topic #: 4
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?
Suggested Answer:
C
Currently there are no comments in this discussion, be the first to comment!