Free Databricks-Certified-Associate-Developer-for-Apache-Spark-3.5 Actual Exam Questions - Question 5 Discussion
Which output mode at line 3 ensures that the entire result table is written to the console during each
trigger execution?
A/B? Append only adds new rows, so it can’t output the whole table. Complete mode outputs the full aggregation every trigger, which matches what the question asks. Options C and D don’t exist in standard Spark modes.
A, complete mode always outputs full aggregation results every trigger run.
Probably A here too. Since the question is about writing the entire result table every trigger, complete mode is the one that guarantees that. Append only outputs new rows, so it won’t show the full aggregation each time. Also, C and D aren’t actual output modes in Spark Structured Streaming, so they can be ruled out easily. Complete is the go-to for full aggregation outputs on console sinks.
Not B, since append mode only outputs new rows and won’t show the full aggregation result every time. Complete mode (A) fits because it writes the entire table after each trigger.
A, since complete mode outputs the full aggregation result every trigger.
Good catch on ruling out C and D since they’re not real modes. I’d also say append (B) can’t work here because aggregations don’t just add rows, so A is the only one that makes sense.
A/B? Complete mode outputs the full table every time, while append only shows new rows. Replace and aggregate don’t exist as output modes, so they can be ruled out easily.
Option A, complete mode is the only valid choice that outputs the full aggregation every trigger.
A, complete mode is the only one that reprints the full aggregation result every trigger. Append just adds new data and doesn’t rewrite the whole table. The others aren’t valid output modes anyway.
A, complete mode is the only one that outputs the full aggregated result each time the query runs. Append mode only outputs new rows, so it won’t show the entire table. The other options, replace and aggregate, aren’t valid output modes in Structured Streaming.
It's definitely A. complete mode writes the full result every time, which fits the question about the entire table output.