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 are designing an inventory updates table with a clustered columnstore index in an Azure Synapse Analytics dedicated SQL pool. The table has the following columns:

  • WarehouseID
  • ProductCategoryType
  • Date
  • InventoryEventType
  • Quantity

The identified usage patterns are:

  • Analysts will most commonly analyze transactions for a specific warehouse.
  • Queries will summarize data by product category type, date, and/or inventory event type.

To minimize query times, on which column should you partition the table?

Exam-Like
Quiz related visual



Powered ByGPT-5