Noos
PT EN
RAN-DBDEA-00142
Ranvier · DBDEA

Exam DBDEA Topics: transformation Difficulty: medium

A Delta table catalog.sales.payments declares amount as DOUBLE. A new ingestion job builds a DataFrame in which amount is still STRING, with raw values like '125.50', and appends the DataFrame to the table. The job author asks what Delta Lake will do when the write is attempted. What is the expected behavior?

Options (Reading Mode) Click to filter discussion →
  1. A. The write fails: Delta enforces the table schema and rejects a column type that does not match
  2. B. The write succeeds, storing STRING values that are converted back to DOUBLE whenever readers query
  3. C. Delta automatically adds a second column, amount_string, to hold the mismatched incoming values
  4. D. Delta writes only the columns whose types are compatible and silently drops the mismatched one
Reveal answer

Correct answer: The write fails: Delta enforces the table schema and rejects a column type that does not match

Reference: https://docs.databricks.com/aws/en/delta/

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): The write fails: Delta enforces the table schema and rejects a column type that does not match

⚓ Official Documentation Anchor: https://docs.databricks.com/aws/en/delta/
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.