When using the complete mode to write stream data, how does it impact the target table?

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

View Answer

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