LeetQuiz Logo
Privacy Policy•contact@leetquiz.com
© 2025 LeetQuiz All rights reserved.
Microsoft Azure Data Engineer Associate - DP-203

Microsoft Azure Data Engineer Associate - DP-203

Get started today

Ultimate access to all questions.


Comments

Loading comments...

You have an Azure Synapse Analytics dedicated SQL pool and need to create a fact table named Table1 to store sales data from the last three years. The solution must optimize performance 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 column should you use to partition Table1?

Exam-Like



Powered ByGPT-5