Databricks Certified Data Engineer Associate · Free Practice Question Easy
Question 36
When using the complete mode to write stream data, how does it impact the target table?
-
A
Entire stream waits for complete data to write
-
B
Stream must complete to write the data
-
C
Target table cannot be updated while stream is pending
-
D
Target table is overwritten for each batch
-
E
Delta commits transaction once the stream is stopped
Reveal correct answer
Correct answer: D
Explanation
The answer is Target table is overwritten for each batch
Complete mode - The whole Result Table will be outputted to the sink after every trigger. This is supported for aggregation queries
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
