Noos
PT EN
RAN-DBDEA-00190
Ranvier · DBDEA

Exam DBDEA Topics: ingestion Difficulty: medium

A supplier landing directory has accumulated more than 40,000 small CSV files over two years of daily deliveries. The nightly COPY INTO run keeps getting slower: most of its time now goes into discovering which files in the path are new and which were already loaded. Total daily volume is modest. What should the team conclude about this slowdown?

Options (Reading Mode) Click to filter discussion →
  1. A. No structural limit: COPY INTO handles any file count without degradation, so the slowdown must come from warehouse sizing, not ingestion design
  2. B. File size only: compacting the thousands of small files into fewer large ones solves everything, because file count never drives ingestion cost
  3. C. Scale mismatch: COPY INTO suits small to medium sets of files, while Auto Loader is built for this scale, handling millions of files efficiently
  4. D. Mode mismatch: Auto Loader only serves always-on, real-time streaming, so it cannot replace a nightly batch-style incremental load
Reveal answer

Correct answer: Scale mismatch: COPY INTO suits small to medium sets of files, while Auto Loader is built for this scale, handling millions of files efficiently

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): Scale mismatch: COPY INTO suits small to medium sets of files, while Auto Loader is built for this scale, handling millions of files efficiently

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