Noos
PT EN
RAN-DBDEA-00037
Ranvier · DBDEA

Exam DBDEA Topics: transformation Difficulty: medium

A silver table of customer contacts is usable as long as a customer can be reached by at least one channel. Rows where BOTH email and phone are NULL must be removed. Rows where only one of the two is NULL must be kept, with the NULL value preserved in place. ```python bronze = spark.read.table("catalog.crm.bronze_contacts") silver = <drop rule> ``` Which dropna call implements this rule?

Options (Reading Mode) Click to filter discussion →
  1. A. silver = bronze.dropna(how='any', subset=['email', 'phone'])
  2. B. silver = bronze.dropna(how='all', subset=['email', 'phone'])
  3. C. silver = bronze.dropna(subset=['email'])
  4. D. silver = bronze.dropna(thresh=2)
Reveal answer

Correct answer: silver = bronze.dropna(how='all', subset=['email', 'phone'])

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

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 (B): silver = bronze.dropna(how='all', subset=['email', 'phone'])

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.