Databricks Certified Data Engineer Professional — Question 16

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

Answer options

• 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.

Correct answer: A

Explanation

The correct answer is A because stream-static joins indeed utilize the most recent version of the static Delta table for each microbatch, ensuring up-to-date data is used. Option B is incorrect as it suggests that the version remains static from job initialization, which is not the case. Options C, D, and E also misrepresent the functionality and purpose of the checkpoint directory in the context of stream-static joins.