Exam DP-300 topic 1 question 21 discussion

The answer is correct.

• Append Mode: Outputs only the new rows added during each trigger (i.e., each 5-minute interval in this case). This is ideal when you're continuously adding new records to the destination (e.g., a Delta Lake table) without updating existing data.

In question not mentioned that we need to keep old data. so the correct answer should be A

The answer is append

Solution is 'Complete'. The Question stated - "will count new events in five-minute intervals and report only events that arrive during the interval. - Says 'NEW' events and 'ONLY ARRIVE DURING THE 5min INTERVAL' - so it can't be append because that would just add new data to the old data.

The preceding example continuously updates a table that contains the aggregate number of events by customer.

Complete - The question doesn't state we need to keep existing data, only that we need from the given interval.

Append

Append is the answer

I think append

complete - You can also use Structured Streaming to replace the entire table with every batch. One example use case is to compute a summary using aggregation https://docs.databricks.com/delta/delta-streaming.html

https://docs.microsoft.com/en-us/azure/databricks/getting-started/spark/streaming 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 Then must be complete. append is if the table is static, with few changes.

it should be append

The answer is correct.

Which is the correct answer? I think complete as the question do not ask to add new recrods.

compete mode is correct. It requires count but not add a new record.

Correc answer is B - Append