What should you recommend?

You are planning a streaming data solution that will use Azure Databricks. The solution will stream sales transaction data from an online store.

The solution has the following specifications:

* The output data will contain items purchased, quantity, line total sales amount, and line total tax amount.

* Line total sales amount and line total tax amount will be aggregated in Databricks.

* Sales transactions will never be updated. Instead, new rows will be added to adjust a sale.

You need to recommend an output mode for the dataset that will be processed by using Structured Streaming. The solution must minimize duplicate data.

What should you recommend?
A . Append
B. Update
C. Complete

View Answer

Answer: B

Explanation:

By default, streams run in append mode, which adds new records to the table.

https://docs.databricks.com/delta/delta-streaming.html