Databricks-DA-Assoc Importing Data Practice Question
A user wants to import a local 50MB CSV file into a Databricks workspace for a quick ad-hoc analysis. Which TWO methods are available within the Databricks UI to accomplish this task directly?
⚠ Common exam trap
Candidates often assume they must use 'dbutils.fs.put' or write complex code to upload files. They overlook the simple, built-in UI features available directly within the Databricks Catalog Explorer.
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
✓
Using the 'Create or modify table from file upload' feature in the 'Add' menu.
Databricks provides several entry points for local file uploads to facilitate rapid analysis. The 'Create or modify table from file upload' UI is the primary method for non-programmatic ingestion, while Unity Catalog Volumes offer a modern way to manage non-tabular data. Both options allow analysts to bypass complex cloud storage configurations when dealing with small, local datasets for immediate exploratory data science tasks.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Using the 'Create or modify table from file upload' feature in the 'Add' menu.
Why this is correct
The 'Create or modify table from file upload' interface allows users to drag and drop files directly into the browser. This tool automatically infers the schema, provides a data preview, and handles the conversion of the local CSV into a managed Delta table within the selected schema and catalog.
- ✗
Using the Databricks File System (DBFS) CLI to push the file to the workspace.
Why it's wrong here
DBFS CLI is a command-line interface tool rather than a native UI component within the Databricks workspace browser. While it can be used to move files to the Databricks File System, it requires local installation and configuration, making it a programmatic approach rather than a direct UI-based import method.
- ✗
Using the SQL Editor to copy and paste the raw text into a new table.
Why it's wrong here
The SQL Editor is used for writing and executing queries against existing tables or views but does not support direct file uploads. While you can query files using external locations, you cannot simply drag a local file into the editor to initiate an ingestion process without pre-staging that data.
- ✓
Uploading the file to a Unity Catalog Volume using the Catalog Explorer.
Why this is correct
Unity Catalog Volumes provide a UI-based upload feature specifically designed for managing unstructured or semi-structured files. Analysts can use the Catalog Explorer to upload local files into a Volume, which can then be easily referenced in SQL or Python for further processing and table creation within the Lakehouse.
- ✗
Using the Workspace Sidebar 'Import' button to select the local CSV file.
Why it's wrong here
The Workspace Sidebar 'Import' button is reserved for importing Databricks notebooks, folders, or archive files into the workspace file system. It is not designed for data ingestion or table creation from CSV files, as it focuses on the organization and migration of code assets rather than data.
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.