DP-203 Certification Practice Question #248

Question

You are designing an inventory updates table in an Azure Synapse Analytics dedicated SQL pool. The table will have a clustered columnstore index and will include the following columns:

You identify the following usage patterns:
✑ Analysts will most commonly analyze transactions for a warehouse.
✑ Queries will summarize by product category type, date, and/or inventory event type.
You need to recommend a partition strategy for the table to minimize query times.
On which column should you partition the table?

Accepted Answer

Stream Analytics uses explicit event-ordering and late-arrival policies to handle delayed events correctly. When the scenario is really about preserving accurate processing semantics for out-of-order or delayed data, the right fix is the time-handling configuration rather than unrelated service changes. That matches the answer supported by official Stream Analytics guidance.

More DP-203 practice questions