Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
Given the following query:
.filter(“recent = true“) .dropDuplicates([“item_id“, “item_timestamp“]) .write .mode (“overwrite“) .table(“stream_data_stage“)
Which statement accurately describes the outcome of executing this query?
A
An incremental job will overwrite the stream_sink table by those deduplicated records from stream_data_stage that have been added since the last time the job was run.
B
A batch job will overwrite the stream_data_stage table by deduplicated records calculated from all 'recent' items in the stream_sink table.
C
An incremental job will overwrite the stream_data_stage table by those deduplicated records from stream_sink that have been added since the last time the job was run.
D
A batch job will overwrite the stream_sink table by deduplicated records calculated from all 'recent' items in the stream_data_stage table.
E
A batch job will overwrite the stream_data_stage table by those deduplicated records from stream_sink that have been added since the last time the job was run.