Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
The data engineering team has implemented a join logic between three Delta tables: students, courses, and enrollments. The final output is written to a table named students_courses_details. What happens each time this code block is executed?
students
courses
enrollments
students_courses_details
A
Only newly added records to any of the source tables will be considered in the join operations. The matched records will overwrite the students_courses_details table.
B
All records in the current version of the source tables will be considered in the join operations. The matched records will overwrite the students_courses_details table.
C
These join operations are stateful, meaning that they will wait for unmatched records to be added to the source tables prior to calculating the results.
D
All records in the current version of the source tables will be considered in the join operations. The unmatched records will overwrite the students_courses_details table.
E
Only newly added records to any of the source tables will be considered in the join operations. The unmatched records will overwrite the students_courses_details table.
