On this page
The short answer
- The real exam: 45 questions in 90 min, for $200.
- 5 sample questions below, from 5 of the exam’s 9 domains, each with its answer and why it’s right.
- They are original questions, written from Databricks’ published outline. They aren’t copies of real exam questions, and we don’t publish those.
- For a score by domain, take the free 10-question practice test. Nothing to download: it runs in your browser.
The Databricks Data Analyst Associate exam at a glance
From our Databricks Data Analyst Associate exam guide, which follows Databricks’ own page and is checked every week. Databricks hasn’t announced a retirement date for Data Analyst Associate.
| Databricks Data Analyst Associate | |
|---|---|
| Level | Associate |
| Written for | Data Analyst |
| Questions | 45 |
| Time | 90 min |
| Passing score | Not published by Databricks |
| Cost | $200 |
| Recommended experience | 6+ months of hands-on data analysis |
What the exam covers
The exam has 9 domains: Understanding of Databricks Data + AI Platform (11%), Managing Data (8%), Importing Data (5%), Executing Queries Using Databricks SQL and SQL Warehouses (20%), Analyzing Queries (15%), Creating Dashboards and Visualizations (16%), Developing, Sharing, and Maintaining AI/BI Genie Spaces (12%), Data Modeling with Databricks SQL (5%), Securing Data (8%). Executing Queries Using Databricks SQL and SQL Warehouses is the largest, at 20%, so it deserves the largest share of your study time.
The sample questions below start with one from each domain in turn, so you can see how each is asked.
5 sample questions, with answers
Answer each one before you open its answer. If you get it right for the wrong reason, count it as wrong: the explanation matters more than the letter.
Question 1 · Understanding of Databricks Data + AI Platform
What is the three-level namespace for a table in Unity Catalog?
- Adatabase.table.column
- Bworkspace.folder.table
- Cschema.catalog.table
- Dcatalog.schema.table
Show the answer
D. catalog.schema.table
Unity Catalog names objects as catalog, then schema, then table. The other orders or levels don’t exist in Unity Catalog.
Question 2 · Managing Data
Which kind of table has its data files managed by Unity Catalog and removed when the table is dropped?
- AAn external table
- BA managed table
- CA temporary view
- DA materialized view
Show the answer
B. A managed table
Managed tables store data in Unity Catalog’s managed storage, which it cleans up after a drop. External tables leave files in place, temporary views hold no data, and materialized views store query results.
Question 3 · Executing Queries Using Databricks SQL and SQL Warehouses
Which compute runs the queries behind Databricks SQL dashboards and the SQL editor?
- AA SQL warehouse
- BA single-user ML cluster
- CA job cluster for Python tasks
- DThe driver of a notebook session
Show the answer
A. A SQL warehouse
SQL warehouses, ideally serverless, are compute built for SQL workloads and BI. Clusters and notebook drivers serve other workloads.
Question 4 · Analyzing Queries
Where can an analyst see why a query was slow, such as time spent scanning files?
- AThe query profile in query history
- BThe dashboard’s refresh schedule
- CThe catalog permissions tab
- DA Genie space’s instructions
Show the answer
A. The query profile in query history
The query profile breaks a query into operators with time, rows and bytes read. Schedules, permissions and Genie instructions don’t explain performance.
Question 5 · Creating Dashboards and Visualizations
Viewers should pick a date range that updates every chart on a dashboard. What should the author add?
- AA new SQL warehouse
- BA comment on the table
- CA Unity Catalog tag
- DA date filter widget
Show the answer
D. A date filter widget
Filters and parameters on an AI/BI dashboard apply across the datasets and visualizations they’re linked to. Warehouses, comments and tags don’t filter dashboards.
How to use practice questions
Test before you study. A short test at the start shows which domains you already know, so you don’t spend a week on them.
Read every explanation, including the ones for questions you got right. Most exam questions turn on one detail in the scenario, and the explanation names it.
Then go full length. A few questions check your understanding; they don’t tell you whether you can hold your attention for 90 min. Before you book, sit full, timed practice exams until you pass them comfortably more than once.
Practice exams, downloads and dumps
You don’t need to download anything to practice. Our practice test is free and runs in the browser, on a phone or a computer.
Dumps are a different thing: collections sold or shared as the “real” exam questions. We don’t publish or link to them. They are taken from the exam in breach of the agreement every candidate accepts, they go out of date when Databricks refreshes its questions, and nobody stands behind their answers.
There is also a plainer reason. An exam is a sample of what the job needs. If you memorize the sample, you pass without the knowledge, and the first week of work shows it.
What to do next
Take the practice test, note your weakest domain, and build your study time around it.