You plan to build a structured streaming solution in Azure Databricks. The solution will count new events in five-minute intervals and report only events that arrive during the interval. The output…

The correct answer is B. append. Append Mode: Only new rows appended in the result table since the last trigger are written to external storage. This is applicable only for the queries where existing rows in the Result Table are not expected to change. Complete Mode: The entire updated result table is written…

Submitted by andres_qro· Mar 6, 2026Plan and implement data platform resources

Question

You plan to build a structured streaming solution in Azure Databricks. The solution will count new events in five-minute intervals and report only events that arrive during the interval. The output will be sent to a Delta Lake table. Which output mode should you use?

Options

Acomplete
Bappend
Cupdate

How the community answered

(22 responses)

A
14% (3)
B
82% (18)
C
5% (1)

Explanation

Append Mode: Only new rows appended in the result table since the last trigger are written to external storage. This is applicable only for the queries where existing rows in the Result Table are not expected to change. Complete Mode: The entire updated result table is written to external storage. It is up to the storage connector to decide how to handle the writing of the entire table. Update Mode: Only the rows that were updated in the result table since the last trigger are written to external storage. This is different from Complete Mode in that Update Mode outputs only the rows that have changed since the last trigger. If the query doesn't contain aggregations, it is equivalent to Append mode. https://docs.databricks.com/getting-started/spark/streaming.html

Topics

#structured streaming#output modes#Delta Lake#Azure Databricks

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice