Data Engineer Professional & Data Analyst Associate
Databricks · Certification & Interview
Theory
After the Associate exam, two related certifications are common. The Databricks Certified Data Engineer Professional is the advanced data engineering exam. Its current guide covers production Python and SQL (bundles, UDFs, streaming, Lakeflow Jobs control flow, AUTO CDC for SCD 1 and 2), ingestion from message buses and CDC sources, VARIANT and AI functions, monitoring with system tables and event logs, cost and performance tuning, security (ABAC, PII, purging), governance, deployment with bundles and Git CI/CD, and data modelling. The Databricks Certified Data Analyst Associate targets SQL analysts: Databricks SQL and warehouses, Unity Catalog basics, importing data, analysing query performance, AI/BI dashboards, Genie Agents, data modelling (star schema, medallion) and securing data.
Why we use it
Choosing the right next certification signals your direction: the Professional proves you can design and run production pipelines, while the Analyst Associate proves you can turn lakehouse data into dashboards and self-service analytics.
When to use it
Go for Professional after real project experience (about a year is recommended) with streaming, CDC, CI/CD and tuning. Go for Data Analyst Associate if your role is SQL, BI and dashboards. Analytics engineers often take both Associate exams before the Professional.
How it works
- Associate passed or SQL/BI role
- Is your work mainly SQL, dashboards and BI? Yes: Data Analyst Associate. No: Next question.
- Do you run production pipelines with streaming, CDC and CI/CD? Yes: Data Engineer Professional. No: Get more project experience first.
- Download the current exam guide and map gaps
- Practise hands-on, then book the exam
Syntax
Data Engineer Professional: advanced pipelines, CDC, streaming, monitoring, optimisation, security, CI/CD, modelling
Data Analyst Associate: Databricks SQL, warehouses, dashboards, Genie Agents, query analysis, modelling, security
Check: databricks.com → Certification → exam guide PDFs (formats and versions change)Example
-- Professional-style task: SCD 2 with AUTO CDC (you should write this from memory)
CREATE OR REFRESH STREAMING TABLE customers_history;
CREATE FLOW customers_scd2 AS AUTO CDC INTO customers_history
FROM stream(customers_cdc)
KEYS (customer_id)
SEQUENCE BY seq
COLUMNS * EXCEPT (op, seq)
STORED AS SCD TYPE 2;
-- Analyst-style task: dashboard dataset with a parameter
SELECT c.city, SUM(o.amount) AS sales
FROM main.sales.orders o
JOIN main.sales.customers c ON o.customer_id = c.customer_id
WHERE o.order_date BETWEEN :start_date AND :end_date
GROUP BY c.city
ORDER BY sales DESC;Key points
- Professional assumes hands-on production experience, not just course study
- Professional topics: AUTO CDC, streaming state, system tables, ABAC, bundles, tuning
- Analyst Associate topics: DBSQL, warehouses, AI/BI dashboards, Genie Agents, modelling
- Exam guides get new versions; check which version applies on your exam date
- Older material may say Delta Sharing, Genie spaces or Asset Bundles for current products
- Hands-on labs in a workspace remain the best preparation for both