| title | Data Analyst Associate | |||
|---|---|---|---|---|
| tags |
|
|||
| type | certification | |||
| aliases |
|
Important
What changed in the October 2025 exam guide
- Restructured from 5 broad sections into 9 explicitly weighted domains
- AI/BI Genie Spaces is now a first-class domain (12 %) — natural-language analytics on top of Unity Catalog
- Securing Data broken out as its own 8 % domain
- Importing Data and Data Modeling with Databricks SQL are now distinct 5 % domains
- Pass / fail — the October 2025 exam guide does not publish a numeric passing score
The official source of truth: Databricks Certified Data Analyst Associate. The folder structure in this guide now matches the official 9-domain blueprint 1 : 1.
| Detail | Information |
|---|---|
| Certification | Databricks Certified Data Analyst Associate |
| Exam guide | October 2025 |
| Scored questions | 45 multiple-choice |
| Duration | 90 minutes |
| Result | Pass / fail (no numeric threshold in the October 2025 exam guide) |
| Languages | English |
| Code in stems | SQL (ANSI-compliant) |
| Experience | 6+ months hands-on with Databricks SQL (recommended) |
| Recertification | Every 2 years — see Renewal Guide |
| Cost | $200 USD |
| Delivery | Online proctored or test center |
pie title Exam Topic Distribution (9 domains)
"Executing Queries Using Databricks SQL and Warehouses" : 20
"Creating Dashboards and Visualizations" : 16
"Analyzing Queries" : 15
"Developing, Sharing, and Maintaining AI/BI Genie Spaces" : 12
"Understanding Databricks Data Intelligence Platform" : 11
"Managing Data" : 8
"Securing Data" : 8
"Importing Data" : 5
"Data Modeling with Databricks SQL" : 5
| Domain | Weight |
|---|---|
| Executing Queries Using Databricks SQL and Warehouses | 20 % |
| Creating Dashboards and Visualizations | 16 % |
| Analyzing Queries | 15 % |
| Developing, Sharing, and Maintaining AI/BI Genie Spaces | 12 % |
| Understanding Databricks Data Intelligence Platform | 11 % |
| Managing Data | 8 % |
| Securing Data | 8 % |
| Importing Data | 5 % |
| Data Modeling with Databricks SQL | 5 % |
The folder structure below matches the October 2025 official 9-domain blueprint. Read in order; each folder's README.md has the section contents and key concepts.
| Section | Weight | Focus |
|---|---|---|
| 01 — Executing Queries Using Databricks SQL and Warehouses | 20 % | SQL Warehouses, query editor, run-as identity |
| 02 — Creating Dashboards and Visualizations | 16 % | AI/BI Dashboards, charts, alerts, sharing |
| 03 — Analyzing Queries | 15 % | Joins, aggregations, window functions, query parameters |
| 04 — Developing, Sharing, and Maintaining AI/BI Genie Spaces | 12 % | Genie Spaces creation, curation, tuning |
| 05 — Understanding Databricks Data Intelligence Platform | 11 % | Unity Catalog, connections, lakehouse arch |
| 06 — Managing Data | 8 % | Tables, schemas, managed vs external |
| 07 — Securing Data | 8 % | GRANT/REVOKE, row filters, column masks |
| 08 — Importing Data | 5 % | UI upload, COPY INTO, Lakehouse Federation |
| 09 — Data Modeling with Databricks SQL | 5 % | Medallion, star/snowflake, views vs MVs |
| Resource | Description |
|---|---|
| Practice Questions | Topic-specific practice questions |
| Mock Exam 1 | Full-length practice exam |
| Mock Exam 2 | Alternative practice exam |
| Exam Tips | Exam strategies and tips |
| Official Links | Documentation and resources |
After completing this certification, explore:
- Interview Prep Resource - Complement your SQL knowledge with system design and architecture
Review these shared fundamentals:
- Master Databricks SQL interface and warehouses
- Build dashboards and visualizations
- Practice complex SQL queries and analysis
- Build a Genie Space on a UC schema (and tune it)
- Understand UC + lakehouse vocabulary
- Manage tables and schemas safely
- Apply row filters and column masks
- Practice
COPY INTOand federation - Compare standard vs materialised views