DP-203 · Question #86
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 ou
The correct answer is A. Append. The "Append" output mode is appropriate when the output dataset is a set of new records and does not include any updates or deletions. It will only append new rows to the output dataset, which means there will be no duplicate data created as a result of the streaming data solutio
Question
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?
Options
- AAppend
- BUpdate
- CComplete
How the community answered
(23 responses)- A83% (19)
- B4% (1)
- C13% (3)
Explanation
The "Append" output mode is appropriate when the output dataset is a set of new records and does not include any updates or deletions. It will only append new rows to the output dataset, which means there will be no duplicate data created as a result of the streaming data solution. Since the solution will never update existing rows, but rather add new rows, the "Append" mode is the best choice to meet the requirements.
Topics
Community Discussion
No community discussion yet for this question.