Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam Certified Data Engineer Professional All Questions

View all questions & answers for the Certified Data Engineer Professional exam

Exam Certified Data Engineer Professional topic 1 question 18 discussion

Actual exam question from Databricks's Certified Data Engineer Professional
Question #: 18
Topic #: 1
[All Certified Data Engineer Professional Questions]

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.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Eertyy
Highly Voted 1 year, 2 months ago
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.
upvoted 10 times
hamzaKhribi
11 months, 4 weeks ago
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
upvoted 9 times
...
...
BrianNguyen95
Highly Voted 1 year, 3 months ago
correct answer is A
upvoted 5 times
...
akashdesarda
Most Recent 1 month, 3 weeks ago
Selected Answer: A
This is straight from docs, "A stream-static join joins the latest valid version of a Delta table (the static data) to a data stream using a stateless join. 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. Because the join is stateless, you do not need to configure watermarking and can process results with low latency. The data in the static Delta table used in the join should be slowly-changing." https://learn.microsoft.com/en-us/azure/databricks/transform/join#stream-static
upvoted 1 times
...
kz_data
10 months, 2 weeks ago
Selected Answer: A
correct answer is A
upvoted 1 times
...
hamzaKhribi
11 months, 4 weeks ago
Selected Answer: A
Correct Answer A
upvoted 1 times
...
sturcu
1 year, 1 month ago
Selected Answer: A
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
upvoted 1 times
...
sagar21692
1 year, 1 month ago
Correct answer is A. https://docs.databricks.com/en/structured-streaming/delta-lake.html
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...