Which statement regarding stream-static joins and static Delta tables is correct?

Which statement regarding stream-static joins and static Delta tables is correct?
A . Each microbatch of a stream-static join will use the most recent version of the static Delta table as of each microbatch.
B . Each microbatch of a stream-static join will use the most recent version of the static Delta table as of the job’s initialization.
C . The checkpoint directory will be used to track state information for the unique keys present in the join.
D . Stream-static joins cannot use static Delta tables because of consistency issues.
E . The checkpoint directory will be used to track updates to the static Delta table.

View Answer

Answer: A

Explanation:

This is the correct answer because stream-static joins are supported by Structured Streaming when one of the tables is a static Delta table. A static Delta table is a Delta table that is not updated by any concurrent writes, such as appends or merges, during the execution of a streaming query. In this case, each microbatch of a stream-static join will use the most recent version of the static Delta table as of each microbatch, which means it will reflect any changes made to the static Delta table before the start of each microbatch.

Verified Reference: [Databricks Certified Data Engineer Professional], under “Structured Streaming” section; Databricks Documentation, under “Stream and static joins” section.