Databricks Certified Data Analyst Associate (Data Analyst Associate) practice exam and study path
A free, timed 45-question Data Analyst Associate practice exam in 90 minutes, scored by domain, with every option explained after you submit. Also 119 practice questions you can check one at a time, a page for every task in the exam guide, and a study path. No sign-up.
$6.99for 12 months
The foundational Databricks analytics exam: the platform and Unity Catalog objects, discovering, tagging and cleaning governed data, bringing data in, writing and tuning Databricks SQL on SQL warehouses, building AI/BI dashboards, alerts and Genie Agents, modeling data for analytics, and securing it.
The exam
- Exam code
- Data Analyst Associate
- Questions
- Not yet published
- Time
- 90 minutes
- Passing score
- Not published
- Exam fee
- $200 (USD)
- Question types
- multiple choice
45 scored multiple-choice questions in 90 minutes (up to 10 unscored items may be added and are not identified), USD 200 plus applicable taxes, online proctored or at a test center, no test aids, in English. No prerequisite; related training and six months of hands-on Databricks experience are recommended. The SQL on the exam follows ANSI SQL. Valid for 2 years; to recertify you take the current exam. Passing score: Not published. This outline is the version published October 19, 2026.
From Databricks's certification page and exam guide, checked Nov 12, 2026.
Domains and weights
Domain 1: Understanding of Databricks Data Intelligence Platform (Lakehouse Platform)
11%
Domain 2: Managing Data
8%
Domain 3: Importing Data
5%
Domain 4: Executing queries using Databricks SQL and Databricks SQL Warehouses
20%
Domain 5: Analyzing Queries
15%
Domain 6: Working with Dashboards and Visualizations in Databricks
16%
Domain 7: Developing, Sharing, and Maintaining AI/BI Genie Agents (Genie Spaces)
12%
Domain 8: Data Modeling with Databricks SQL
5%
Domain 9: Securing Data
8%
Practice
119 original practice questions, every option explained with the Databricks documentation page that proves it. Free, no sign-up; progress stays on this device.
119 questions · practice mode
All domains
Every sample question for this exam, in domain order.
13 questions · practice mode
Topic quiz — Domain 1: Understanding of Databricks Data Intelligence Platform (Lakehouse Platform)
A topic quiz on domain 1 (11% of the exam).
10 questions · practice mode
Topic quiz — Domain 2: Managing Data
A topic quiz on domain 2 (8% of the exam).
6 questions · practice mode
Topic quiz — Domain 3: Importing Data
A topic quiz on domain 3 (5% of the exam).
24 questions · practice mode
Topic quiz — Domain 4: Executing queries using Databricks SQL and Databricks SQL Warehouses
A topic quiz on domain 4 (20% of the exam).
18 questions · practice mode
Topic quiz — Domain 5: Analyzing Queries
A topic quiz on domain 5 (15% of the exam).
19 questions · practice mode
Topic quiz — Domain 6: Working with Dashboards and Visualizations in Databricks
A topic quiz on domain 6 (16% of the exam).
13 questions · practice mode
Topic quiz — Domain 7: Developing, Sharing, and Maintaining AI/BI Genie Agents (Genie Spaces)
A topic quiz on domain 7 (12% of the exam).
6 questions · practice mode
Topic quiz — Domain 8: Data Modeling with Databricks SQL
A topic quiz on domain 8 (5% of the exam).
10 questions · practice mode
Topic quiz — Domain 9: Securing Data
A topic quiz on domain 9 (8% of the exam).
45 questions · 90 min · timed
Free practice exam
The real exam's pace, no feedback until you submit.
45 questions · 90 min · timed · exam pack
Practice exam 1
Included in the Data Analyst Associate exam pack.
45 questions · 90 min · timed · exam pack
Practice exam 2
Included in the Data Analyst Associate exam pack.
45 questions · 90 min · timed · exam pack
Practice exam 3
Included in the Data Analyst Associate exam pack.
More practice exams
The lessons, the sample questions on every task page and the first full practice exam are free and stay free. A pack adds the further timed Data Analyst Associate practice exams.
Data Analyst Associate exam pack
$6.99for 12 months
- Every paid Data Analyst Associate practice exam, timed, with every option explained
- The next version of this exam included when it changes within your 12 months
- 12 months of access. One payment, nothing renews by itself.
- 14-day refund, no conditions
- 14-day refund, no conditions: ask within 14 days of buying and you get the whole payment back.
- No pass guarantee. These are practice exams written by us from the exam guide and the Databricks documentation; a score here does not predict your result on the real exam.
Study path
One module per exam domain. Lessons that already exist on BytePatterns are linked; the rest are being written.
Module 1: Understanding of Databricks Data Intelligence Platform (Lakehouse Platform)
1The platform's components: Delta Lake, Unity Catalog, Databricks SQL, Lakeflow and LakebaseTask 1.1
Lesson coming
2Databricks Marketplace: listings, private exchanges and shared catalogsTask 1.1
Lesson coming
3Catalog Explorer: catalogs, schemas, managed and external tables, views and metric viewsTask 1.2
Lesson coming
4Certified tables, access controls and lineage in Catalog ExplorerTask 1.2
Lesson coming
Module 2: Managing Data
5Discovering certified data, governed tags and lineageTask 2.1
Lesson coming
6Cleaning data in SQL: NULLs, invalid values and constraintsTask 2.2
Partly covered by: WHERE and Filtering
Module 3: Importing Data
7Bringing data in: S3, Auto Loader, COPY INTO, managed connectors, OpenSharing and MarketplaceTask 3.1
Lesson coming
8Uploading a file through the workspace UITask 3.1
Lesson coming
Module 4: Executing queries using Databricks SQL and Databricks SQL Warehouses
9Genie Code in the SQL editor and notebooksTask 4.1
Lesson coming
10SQL warehouses: types, sizing, scaling and queuingTask 4.1
Lesson coming
11Federated queries and materialized views, streaming tables and dynamic viewsTask 4.2
Lesson coming
12Aggregates, joins and set operators in Databricks SQLTask 4.3
Partly covered by: Aggregations & GROUP BY, INNER and OUTER JOINs
13Sorting and filteringTask 4.3
Partly covered by: WHERE and Filtering, ORDER BY and LIMIT
14Managed and external tables, CREATE TABLE AS SELECT and Delta time travelTask 4.4
Partly covered by: Transactions & ACID
Module 5: Analyzing Queries
15Photon, query history, the query profile and performance insightsTask 5.1
Partly covered by: Reading a Query Plan
16Table history and query cachingTask 5.2
Partly covered by: Caching
17Predictive optimization and automatic liquid clusteringTask 5.3
Lesson coming
18Fixing a query: grouping, NULLs, casts and window functionsTask 5.3
Partly covered by: Query Execution Order, Window Functions
Module 6: Working with Dashboards and Visualizations in Databricks
19AI/BI dashboards: pages, datasets and widgetsTask 6.1
Lesson coming
20Visualizations in notebooks and the SQL editor, and choosing a visualization typeTask 6.1
Lesson coming
21Parameters, publishing, permissions and embeddingTask 6.2
Lesson coming
22Dashboard schedules and subscriptionsTask 6.3
Lesson coming
23Databricks SQL alerts: thresholds and destinationsTask 6.3
Partly covered by: CloudWatch, Alarms & X-Ray
Module 7: Developing, Sharing, and Maintaining AI/BI Genie Agents (Genie Spaces)
24Genie Agents: purpose, components and setupTask 7.1
Lesson coming
25Sharing, embedding and tuning Genie Agents with benchmarksTask 7.2
Lesson coming
Module 8: Data Modeling with Databricks SQL
26Star, snowflake and data vault models on Databricks and the medallion layersTask 8.1
Lesson coming
Module 9: Securing Data
27Unity Catalog privileges, the three-level namespace and sharing settingsTask 9.1
Partly covered by: Shared Responsibility & IAM
28Table ownership and protecting PIITask 9.2
Partly covered by: Finding and Masking PII
Every task in the exam guide
The exam guide splits each domain into task statements. Each one has a page with a short summary, the lessons that teach it and open sample questions.
Domain 1: Understanding of Databricks Data Intelligence Platform (Lakehouse Platform)
- 1.1Describe the core components of the Databricks Data Intelligence Platform (Lakehouse Platform), including Mosaic AI, Lakeflow Declarative Pipelines (DeltaLive tables), Lakeflow Jobs, Data Intelligence Engine, Delta Lake, Lakebase, Unity Catalog, and Databricks SQL; Describe the role and features of Databricks Marketplace7 sample questions
- 1.2Understand catalogs, schemas, managed and external tables, access controls, views, certified tables, metric views, and lineage within the Catalog Explorer interface6 sample questions
Domain 2: Managing Data
- 2.1Use Unity Catalog to discover, query, and manage certified datasets; Use the Catalog Explorer to tag a data asset with governed tags and view its lineage, including external lineage6 sample questions
- 2.2Perform data cleaning on Unity Catalog Tables in SQL, including removing invalid data or handling missing values4 sample questions
Domain 4: Executing queries using Databricks SQL and Databricks SQL Warehouses
- 4.1Utilize Genie Code (Databricks Assistant) within a Notebook or SQL Editor to facilitate query writing and debugging; Explain the role a SQL Warehouse plays in query execution5 sample questions
- 4.2Querying cross-system analytics by joining data from a Delta table and a federated data source; Create a materialized view, including knowing when to use Streaming Tables and Materialized Views, and differentiate between dynamic and materialized views6 sample questions
- 4.3Perform aggregate operations such as count, approximate count distinct, mean, and summary statistics; Write queries to combine tables using various join operations (inner, left, right, and so on) with single or multiple keys, as well as set operations like union and union all, including the differences between the joins (inner, left, right, and so on); Perform sorting and filtering operations on a table7 sample questions
- 4.4Create managed tables and external tables, including creating tables by joining data from multiple sources (e.g., CSV, Parquet, Delta tables) to create unified datasets, including Unity Catalog; Use Delta Lake's time travel to access and query historical data versions6 sample questions
Domain 5: Analyzing Queries
- 5.1Understand the Features, Benefits, and Supported Workloads of Photon; Identify poorly performing queries in the Databricks Intelligence platform, such as Query Insights, Query Profiler log, etc7 sample questions
- 5.2Utilize Delta Lake to audit and view history, validate results, and compare historical results or trends; Utilize query history and caching to reduce development time and query latency6 sample questions
- 5.3Analyze table access patterns and query workloads to determine when to leverage Predictive Optimization and Automatic Liquid Clustering to optimize table performance; Fix a query to achieve the desired results5 sample questions
Domain 6: Working with Dashboards and Visualizations in Databricks
- 6.1Build dashboards using AI/BI Dashboards, including multi-tabs/page layouts, multiple data sources/datasets, and widgets (visualizations, text, images); Create visualizations in notebooks and the SQL editor; Identify the effective visualization type to communicate insights clearly8 sample questions
- 6.2Work with parameters in SQL queries and dashboards, including defining, configuring, and testing parameters; Configure permissions through the UI to share dashboards with workspace users/groups, external users through shareable links, and embed dashboards in external apps6 sample questions
- 6.3Schedule an automatic dashboard refresh; Configure an alert with a desired threshold and destination5 sample questions
Domain 7: Developing, Sharing, and Maintaining AI/BI Genie Agents (Genie Spaces)
- 7.1Describe the purpose, key features, and components of AI/BI Genie Agents (Genie spaces); Create Genie Agents (Genie spaces) by defining reasonable sample questions and domain-specific instructions, choosing SQL warehouses, curating Unity Catalog datasets (tables, views...), and vetting queries as Trusted Assets7 sample questions
- 7.2Assign permissions via the UI and distribute Genie Agents (Genie spaces) using embedded links, external app integrations, and channel apps; Optimize AI/BI Genie Agents (Genie spaces) by tracking user questions, response accuracy, and feedback; updating instructions and trusted assets based on stakeholder input; validating accuracy with benchmarks; refreshing Unity Catalog metadata6 sample questions
Domain 8: Data Modeling with Databricks SQL
Domain 9: Securing Data
- 9.1Use Unity Catalog roles and sharing settings to ensure workspace objects are secure; Understand how the 3-level namespace (Catalog / Schema / Tables or Volumes) works in the Unity Catalog6 sample questions
- 9.2Apply best practices for storage and management to ensure data security, including table ownership and PII protection4 sample questions
How these questions are made
- Written by us from the exam guide's task statements and the Databricks documentation — never from real exam content.
- Every option carries its own explanation and a link to the Databricks page that proves it.
- A question enters a timed exam only after an independent check; until then it is a practice question.
- Results are a plain percentage, per domain too — not an imitation of Databricks's scaled score.
Questions about the Data Analyst Associate practice exam
- Is the Data Analyst Associate practice exam free?
- Yes. The full practice exam (45 questions, 90 minutes) is free with no sign-up, and so are the 119 practice questions, the task pages and the study path. Your attempts are saved in this browser, on this device.
- How many questions does it have, and is it timed?
- 45 questions in 90 minutes: the real Data Analyst Associate pace, scaled to this form. When the time runs out, the exam is submitted as it stands.
- Are the answers explained?
- After you submit, not during: like the real exam, the timed exam gives no feedback until the end. Then you get your score overall and per exam domain, and every question with each option explained and a link to the Databricks documentation page behind it. In practice mode an answer is explained as soon as you check it.
- What does the Data Analyst Associate exam pack add?
- 3 more timed practice exams (Practice exam 1: 45 questions, 90 minutes; Practice exam 2: 45 questions, 90 minutes; Practice exam 3: 45 questions, 90 minutes), each scored and explained the same way, and the next version of this exam if it changes within your 12 months. 12 months of access. One payment, nothing renews by itself. Everything above stays free. See the pack.
- Can I get a refund?
- Yes, with no conditions: ask within 14 days of buying and you get the whole payment back. The details are in the terms.
- Is this an official Databricks practice exam?
- No. BytePatterns is not affiliated with, endorsed or sponsored by Databricks. Every question is written by us from the public exam guide and the Databricks documentation, never from real exam content, and a score here does not predict your result on the real exam. Databricks lists its own preparation resources on its certification page.