Databricks Certified Data Engineer Professional — Question 108

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

Answer options

• A. The checkpoint directory will be used to track updates to the static Delta table.
• 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.

Correct answer: B

Explanation

The correct answer is B because each microbatch utilizes the most recent version of the static Delta table at the time of job initialization, ensuring data consistency. Option A is incorrect as the checkpoint directory tracks the state of the stream, not updates to the static table. Options C and D are also wrong because C inaccurately describes the purpose of the checkpoint directory, and D is incorrect as stream-static joins can use static Delta tables without consistency issues.