Question 360
A left join loses unmatched orders after a WHERE filter references nullable columns from the right table. Which verification outcome is the strongest evidence of a successful fix?
Explanation
Correct Answer
Unmatched orders are preserved and matched orders satisfy the intended filter. This is the most directly relevant verification because a post-join WHERE predicate rejects null-extended outer-join rows. A concrete acceptance check is: Unmatched orders are preserved and matched orders satisfy the intended filter. To reduce recurrence: Test null and unmatched records when changing outer joins.
Incorrect Answers
Semi-structured schemas can evolve more rapidly than a fixed relational projection. The controlling issue in this question is that a post-join WHERE predicate rejects null-extended outer-join rows.
Window functions do not infer entity boundaries unless a partition is specified. Here the important technical distinction is that a post-join WHERE predicate rejects null-extended outer-join rows.
Generic dropDuplicates does not implement latest-event business semantics. The reported failure instead depends on this fact: a post-join WHERE predicate rejects null-extended outer-join rows.