Noos
PT EN
RAN-DBDEA-00197
Ranvier · DBDEA

Exam DBDEA Topics: ingestion Difficulty: medium

A producer team can deliver its event feed either as Avro or as raw XML files, and it asks the ingestion team which formats can be loaded directly into Delta tables with COPY INTO or Auto Loader — without any custom parsing code — before they commit to a serialization. Which answer is accurate for the current platform?

Options (Reading Mode) Click to filter discussion →
  1. A. Only CSV and JSON load natively; Avro and XML must both be converted to Parquet before ingestion
  2. B. Avro requires a Lakeflow Connect database connector, while XML loads directly with COPY INTO
  3. C. Both load natively: formats include CSV, JSON, XML, Avro, ORC, Parquet, text, and binary files
  4. D. Auto Loader reads XML, but COPY INTO is limited to CSV, JSON, and Parquet sources
Reveal answer

Correct answer: Both load natively: formats include CSV, JSON, XML, Avro, ORC, Parquet, text, and binary files

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

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 (C): Both load natively: formats include CSV, JSON, XML, Avro, ORC, Parquet, text, and binary files

⚓ 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.