ExamTopics Logo
Mail Us[email protected]
Menu
Databricks Discussions
exam questions

Exam Certified Data Engineer Professional All Questions

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

Exam Certified Data Engineer Professional topic 1 question 194 discussion

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

A data engineer is performing a join operation to combine values from a static userLookup table with a streaming DataFrame streamingDF.

Which code block attempts to perform an invalid stream-static join?

  • A. userLookup.join(streamingDF, ["user_id"], how="right")
  • B. streamingDF.join(userLookup, ["user_id"], how="inner")
  • C. userLookup.join(streamingDF, ["user_id"), how="inner")
  • D. userLookup.join(streamingDF, ["user_id"], how="left")
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by temple1305 at Dec. 5, 2024, 10:21 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
temple1305
Highly Voted 2 months ago
Selected Answer: D
D correct https://spark.apache.org/docs/latest/structured-streaming-programming-guide.html#support-matrix-for-joins-in-streaming-queries Static join stream - left join not supported
upvoted 6 times
arekm
1 month ago
That is what the documentation says. We take all the records from the stream and join to the static table - left or right shows us where the stream in the join is. Static table-stream - right outer is supported, stream-static table - left outer is supported.
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago