DP-203 Certification Practice Question #123

Question

You are designing an Azure Databricks table. The table will ingest an average of 20 million streaming events per day.
You need to persist the events in the table for use in incremental load pipeline jobs in Azure Databricks. The solution must minimize storage costs and incremental load times.
What should you include in the solution?

Accepted Answer

This question is noisy because the exam dump?s suggested answer and community majority point to B, which is not technically plausible: Azure Queue Storage is a messaging service, not the right way to persist 20 million events per day in a Databricks table for incremental pipelines. Microsoft Learn?s watermark guidance also does not support C for this requirement because watermarks manage streaming state, not persisted table layout or storage cost. Among the listed options, partitioning by DateTime fields is the only design choice that directly helps incremental reads prune data and reduce scan cost, so A is the best-supported answer despite the conflicting dump signals.

More DP-203 practice questions