Certified Data Engineer Professional Exam QuestionsBrowse all questions from this exam

Certified Data Engineer Professional Exam - Question 18


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

Show Answer
Correct Answer: A

When a microbatch of a stream-static join is processed, the most recent version of the static Delta table is used. This ensures that the data being joined is up-to-date with the latest available information in the static Delta table at the time of processing each microbatch.

Discussion

6 comments
Sign in to comment
EertyyOption: B
Sep 21, 2023

B is the right answer as Option B is more typical for stream-static joins, as it provides a consistent static DataFrame snapshot for the entire job's duration. Option A might be suitable in specialized cases where you need real-time updates of the static DataFrame for each microbatch.

hamzaKhribi
Dec 2, 2023

Answer is A, When Azure Databricks processes a micro-batch of data in a stream-static join, the latest valid version of data from the static Delta table joins with the records present in the current micro-batch from https://learn.microsoft.com/en-us/azure/databricks/structured-streaming/delta-lake

BrianNguyen95Option: A
Aug 17, 2023

correct answer is A

sagar21692Option: A
Oct 1, 2023

Correct answer is A. https://docs.databricks.com/en/structured-streaming/delta-lake.html

sturcuOption: A
Oct 11, 2023

A is correct. When Databricks processes a micro-batch of data in a stream-static join, the latest valid version of data from the static

hamzaKhribiOption: A
Dec 2, 2023

Correct Answer A

kz_dataOption: A
Jan 10, 2024

correct answer is A