Noos
PT EN
RAN-DBDEA-00188
Ranvier · DBDEA

Exam DBDEA Topics: ingestion Difficulty: medium

A finance tool exports nightly CSV files, each starting with a header row of column names. The team loads them with the statement below, and the first run produced generic columns such as _c0 whose values are header text like transaction_id, with every data row shifted. Which change makes the load treat the first line of each file as a header? ```sql COPY INTO main.finance.payments_raw FROM '/Volumes/main/finance/landing/payments/' FILEFORMAT = CSV; ```

Options (Reading Mode) Click to filter discussion →
  1. A. Keep the statement unchanged: COPY INTO detects header rows automatically in every supported file format
  2. B. Add FORMAT_OPTIONS ('header' = 'true') so the reader treats each file's first line as column names instead of data
  3. C. Run a preprocessing job that removes the first line of every CSV file in the landing volume before each nightly load runs
  4. D. Change FILEFORMAT to JSON, because CSV files do not accept format options such as header handling
Reveal answer

Correct answer: Add FORMAT_OPTIONS ('header' = 'true') so the reader treats each file's first line as column names instead of data

Reference: https://docs.databricks.com/aws/en/ingestion/copy-into

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 (B): Add FORMAT_OPTIONS ('header' = 'true') so the reader treats each file's first line as column names instead of data

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