Skip to content
Associate · Data Analyst AssociatePrep available

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.

Data Analyst Associate exam pack:

$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.

Your results on this device →

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.

  1. Module 1: Understanding of Databricks Data Intelligence Platform (Lakehouse Platform)

    1. 1The platform's components: Delta Lake, Unity Catalog, Databricks SQL, Lakeflow and LakebaseTask 1.1

      Lesson coming

    2. 2Databricks Marketplace: listings, private exchanges and shared catalogsTask 1.1

      Lesson coming

    3. 3Catalog Explorer: catalogs, schemas, managed and external tables, views and metric viewsTask 1.2

      Lesson coming

    4. 4Certified tables, access controls and lineage in Catalog ExplorerTask 1.2

      Lesson coming

  2. Module 2: Managing Data

    1. 5Discovering certified data, governed tags and lineageTask 2.1

      Lesson coming

    2. 6Cleaning data in SQL: NULLs, invalid values and constraintsTask 2.2

      Partly covered by: WHERE and Filtering

  3. Module 3: Importing Data

    1. 7Bringing data in: S3, Auto Loader, COPY INTO, managed connectors, OpenSharing and MarketplaceTask 3.1

      Lesson coming

    2. 8Uploading a file through the workspace UITask 3.1

      Lesson coming

  4. Module 4: Executing queries using Databricks SQL and Databricks SQL Warehouses

    1. 9Genie Code in the SQL editor and notebooksTask 4.1

      Lesson coming

    2. 10SQL warehouses: types, sizing, scaling and queuingTask 4.1

      Lesson coming

    3. 11Federated queries and materialized views, streaming tables and dynamic viewsTask 4.2

      Lesson coming

    4. 12Aggregates, joins and set operators in Databricks SQLTask 4.3

      Partly covered by: Aggregations & GROUP BY, INNER and OUTER JOINs

    5. 13Sorting and filteringTask 4.3

      Partly covered by: WHERE and Filtering, ORDER BY and LIMIT

    6. 14Managed and external tables, CREATE TABLE AS SELECT and Delta time travelTask 4.4

      Partly covered by: Transactions & ACID

  5. Module 5: Analyzing Queries

    1. 15Photon, query history, the query profile and performance insightsTask 5.1

      Partly covered by: Reading a Query Plan

    2. 16Table history and query cachingTask 5.2

      Partly covered by: Caching

    3. 17Predictive optimization and automatic liquid clusteringTask 5.3

      Lesson coming

    4. 18Fixing a query: grouping, NULLs, casts and window functionsTask 5.3

      Partly covered by: Query Execution Order, Window Functions

  6. Module 6: Working with Dashboards and Visualizations in Databricks

    1. 19AI/BI dashboards: pages, datasets and widgetsTask 6.1

      Lesson coming

    2. 20Visualizations in notebooks and the SQL editor, and choosing a visualization typeTask 6.1

      Lesson coming

    3. 21Parameters, publishing, permissions and embeddingTask 6.2

      Lesson coming

    4. 22Dashboard schedules and subscriptionsTask 6.3

      Lesson coming

    5. 23Databricks SQL alerts: thresholds and destinationsTask 6.3

      Partly covered by: CloudWatch, Alarms & X-Ray

  7. Module 7: Developing, Sharing, and Maintaining AI/BI Genie Agents (Genie Spaces)

    1. 24Genie Agents: purpose, components and setupTask 7.1

      Lesson coming

    2. 25Sharing, embedding and tuning Genie Agents with benchmarksTask 7.2

      Lesson coming

  8. Module 8: Data Modeling with Databricks SQL

    1. 26Star, snowflake and data vault models on Databricks and the medallion layersTask 8.1

      Lesson coming

  9. Module 9: Securing Data

    1. 27Unity Catalog privileges, the three-level namespace and sharing settingsTask 9.1

      Partly covered by: Shared Responsibility & IAM

    2. 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.

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.