✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
With reference to the Spark Structured Streaming programming model, as illustrated in the figure below, the "Output" is defined as what gets written out to the external storage. The output can be defined in three different modes.
Which of the following is true with reference to the aforementioned modes?
i) In Complete Mode, the entire updated Result Table will be written to the external storage. ii) In Append Mode, only the new rows appended in the Result Table since the last trigger will be written to the external storage.iii) In Update Mode, only the rows that were updated in the Result Table since the last trigger will be written to the external storage.iv) Update Mode is equivalent to Append Mode if the query contains aggregation.