Databricks-DA-Assoc Importing Data Practice Question
A data analyst needs to perform a one-time upload of a 15 MB compressed Parquet file from a local laptop into a Unity Catalog volume in a Databricks workspace. The analyst has the Databricks SQL editor open and no cluster running. Which approach should the analyst take to place the file into the volume path?
⚠ Common exam trap
The trap here is reaching for cluster-based or DBFS-based tooling such as COPY INTO or dbfs cp when a simple UI upload into a Unity Catalog volume is both supported and sufficient.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Navigate to the volume in Catalog Explorer, use the Upload to volume action, and select the local Parquet file to transfer it into the volume path.
Unity Catalog volumes are designed to hold non-tabular files, and Catalog Explorer provides an Upload to volume action that pushes a local file directly into the chosen volume directory. This avoids spinning up a cluster and does not require the SQL warehouse, making it the appropriate tool for a small, one-time upload from a laptop into a governed storage location.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Navigate to the volume in Catalog Explorer, use the Upload to volume action, and select the local Parquet file to transfer it into the volume path.
Why this is correct
Catalog Explorer exposes an Upload to volume action on Unity Catalog volumes that transfers local files directly into the volume directory without requiring a running cluster. This is the supported, low-friction path for small one-time uploads and places the file exactly where downstream SQL or notebook code can read it by its volume path.
- ✗
Run COPY INTO from the SQL editor, referencing the local file path as the source and the volume path as the target.
Why it's wrong here
COPY INTO reads from cloud object storage or other supported remote sources, not from a client machine's local filesystem, and it requires an existing SQL warehouse or cluster. The local file is not visible to the SQL engine, so this statement cannot move the file into the volume and would fail at parse or resolution time.
- ✗
Use dbfs cp from a terminal with the Databricks CLI to copy the file into /Volumes/catalog/schema/volume/path.
Why it's wrong here
The dbfs CLI commands target DBFS paths, not Unity Catalog volume paths, and require the Databricks CLI to be configured with authentication. Even when volumes are mounted under /Volumes, dbfs cp does not write through the volume API, so the copy would fail or land in the wrong location. This option misapplies a DBFS-era tool to a Unity Catalog volume.
- ✗
Use the Catalog Explorer's Create table UI to upload the file, selecting the target volume as the destination and the Parquet format.
Why it's wrong here
The Create table UI in Catalog Explorer is designed to create a table from a file and stores data in a managed or external table location, not in an arbitrary volume directory. Using it to place a raw file into a volume path conflates table creation with file storage and would produce an unexpected table rather than the intended volume-resident file.
About these practice questions
Courseiva writes every Databricks-DA-Assoc question from scratch — 291 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Databricks exam blueprint
This Databricks-DA-Assoc practice question is part of Courseiva's free Databricks certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the Databricks-DA-Assoc exam.