Noos
PT EN
RAN-DBDEA-00010
Ranvier · DBDEA

Exam DBDEA Topics: ingestion Difficulty: easy

A product manager e-mails the data engineering team a weekly CSV export that lives on her laptop. The team needs its contents in a Unity Catalog-governed Delta table and plans to run this statement once the file is available on a storage path: ```sql COPY INTO main.ops.weekly_orders FROM '/Volumes/main/ingest/uploads/' FILEFORMAT = CSV; ``` Which approach correctly makes the laptop file available to this statement?

Options (Reading Mode) Click to filter discussion →
  1. A. Point the FROM clause at the file path on the product manager's laptop, such as 'C:/exports/orders.csv', because COPY INTO can read any path the analyst can open
  2. B. Upload the file into a Unity Catalog volume (for example, with the Catalog Explorer upload option) so it lands on a UC-governed cloud storage path that COPY INTO can read
  3. C. Place the file in the workspace DBFS root with dbutils.fs.put, because DBFS paths are automatically governed by Unity Catalog
  4. D. Attach the CSV to a notebook cell and run spark.read.csv on the uploaded artifact, since notebook attachments behave like Unity Catalog tables
Reveal answer

Correct answer: Upload the file into a Unity Catalog volume (for example, with the Catalog Explorer upload option) so it lands on a UC-governed cloud storage path that COPY INTO can read

Reference: https://docs.databricks.com/aws/en/ingestion/cloud-object-storage/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): Upload the file into a Unity Catalog volume (for example, with the Catalog Explorer upload option) so it lands on a UC-governed cloud storage path that COPY INTO can read

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.