Noos
PT EN
RAN-DBDEA-00238
Ranvier · DBDEA

Exam DBDEA Topics: transformation Difficulty: medium

A monthly reconciliation must compare the bank statement feed with the ledger: every row from either side must appear in the output, matched rows side by side, and rows present on only one side kept with NULLs on the other. Which join produces this result?

Options (Reading Mode) Click to filter discussion →
  1. A. A FULL OUTER JOIN keeps rows from both sides, matching on keys and filling NULLs otherwise
  2. B. An INNER JOIN on transaction_id, which guarantees that every row of both sides appears in the result
  3. C. A LEFT JOIN of bank against ledger, which keeps unmatched ledger rows as NULLs
  4. D. A UNION of both feeds, which places corresponding rows side by side for comparison
Reveal answer

Correct answer: A FULL OUTER JOIN keeps rows from both sides, matching on keys and filling NULLs otherwise

Reference: https://docs.databricks.com/aws/en/pyspark/reference

Train this exam on Ranvier →

02 — The Myelin Layer · Canonical Discussion

Where the exam tries to trick you — and how those who passed solved it.

0 Passed

contributed to this question

Answer Distractor Matrix Click an option to filter or open its dissection.
✦ Consolidated Synthesis (Wiki) rev. #1 (baseline) · CC BY-SA 4.0
Start synthesis for this question →

No community synthesis consolidated for this question yet. Below is the verifiable official starting point — if you passed the exam, open the option dissection.

Official Answer (A): A FULL OUTER JOIN keeps rows from both sides, matching on keys and filling NULLs otherwise

⚓ Official Documentation Anchor: https://docs.databricks.com/aws/en/pyspark/reference
Ranvier · DBDEA

Contribute to this Question

Your contribution builds your Orbital Sheath

Peer contributions

No public contribution yet. Be the first who passed to explain why the distractors trick candidates — your contribution builds your Orbital Sheath.