Noos
PT EN
RAN-DBDEA-00033
Ranvier · DBDEA

Exam DBDEA Topics: transformation Difficulty: easy

A data engineer is building the silver layer of a medallion pipeline. The bronze table catalog.sales.bronze_customers contains a nullable STRING column named region. For catalog.sales.silver_customers, every customer row must be kept, but region must never be NULL in silver — rows without a region must show the value "Unknown". ```python bronze = spark.read.table("catalog.sales.bronze_customers") silver = <cleaning step> silver.write.saveAsTable("catalog.sales.silver_customers") ``` Which cleaning step meets this requirement?

Options (Reading Mode) Click to filter discussion →
  1. A. silver = bronze.fillna('Unknown', subset=['region'])
  2. B. silver = bronze.fillna(0, subset=['region'])
  3. C. silver = bronze.dropna(subset=['region'])
  4. D. silver = bronze.withColumn('region', lit('Unknown'))
Reveal answer

Correct answer: silver = bronze.fillna('Unknown', subset=['region'])

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

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): silver = bronze.fillna('Unknown', subset=['region'])

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.