Microsoft Exam DP-203 Topic 4 Question 63 Discussion

Actual exam question for Microsoft's DP-203 exam

Question #: 63
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?

Aregion

Bproduct

Cweek

Dmonth

Show Suggested Answer

Suggested Answer: C

by Lisha at Nov 15, 2022, 09:05 PM

Limited Time Offer

25%

Off

Get Premium DP-203 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

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