Free study guide

Databricks Data Analyst Associate Study Guide

Databricks Certified Data Analyst Associate

The Databricks Certified Data Analyst Associate exam is for analysts who query and present data on the Databricks Platform. It covers the platform and Unity Catalog, managing and importing data, writing and analyzing queries with Databricks SQL and SQL warehouses, building AI/BI dashboards and alerts, creating and tuning AI/BI Genie Agents, data modeling, and securing data.

  • Databricks certification
  • Associate level
  • 9 exam sections

This guide is free, with no sign-up. It explains every Databricks Data Analyst Associate exam topic in plain English, one chapter at a time. Read them in order or jump straight to the topic you need.

  • 9chapters
  • 14topics
  • 5diagrams and exhibits
  • 1 h 11 minfast track
Start with Databricks Data Intelligence Platform
  • Every topic follows the same simple pattern: what it is, how it works, common mistakes
  • Diagrams and real command output where a picture explains it best
  • Exam tips and worked subnetting and IPv6 practice, with answers

How the exam is weighted

Each domain is worth this share of the exam, so spend your study time in proportion. Select a domain to open its chapter.

Chapters

Open a chapter to see its topics and how long each takes.

1Databricks Data Intelligence Platform1 topic · 5 min fast trackCore components, Unity Catalog objects in Catalog Explorer, metric views and Marketplace.
  1. 1Platform Components, Catalog Explorer and Marketplace5 min
Read the chapter overview →
2Managing Data1 topic · 5 min fast trackCertified datasets, governed tags, lineage including external lineage, and SQL cleaning.
  1. 1Certified Data, Governed Tags, Lineage and Cleaning5 min
Read the chapter overview →
3Importing Data1 topic · 5 min fast trackS3 files, Auto Loader, Delta Sharing, APIs, Lakeflow Connect, Marketplace and the file upload UI.
  1. 1Ways to Bring Data into Databricks5 min
Read the chapter overview →
4Executing Queries with Databricks SQL3 topics · 15 min fast trackSQL warehouses, Genie Code, federated joins, SQL aggregation, joins, tables, views and time travel.
  1. 1SQL Warehouses, Genie Code and Federated Queries5 min
  2. 2Aggregations, Joins, Set Operations and Filtering5 min
  3. 3Tables, Views, Materialized Views and Time Travel5 min
Read the chapter overview →
5Analyzing Queries2 topics · 10 min fast trackPhoton, query history and profile, caching, Delta history, predictive optimization, query fixes.
  1. 1Photon, Query History and Caching5 min
  2. 2Delta History, Table Optimization and Query Fixes5 min
Read the chapter overview →
6Working with Dashboards and Visualizations2 topics · 11 min fast trackAI/BI Dashboards, visualizations, parameters, sharing and embedding, scheduled refresh and SQL alerts.
  1. 1Building AI/BI Dashboards and Visualizations5 min
  2. 2Sharing, Scheduling and Alerts6 min
Read the chapter overview →
7AI/BI Genie Agents2 topics · 10 min fast trackPurpose, setup, trusted assets, permissions, sharing, monitoring and benchmarks.
  1. 1Genie Agents Purpose and Setup5 min
  2. 2Sharing and Improving Genie Agents5 min
Read the chapter overview →
8Data Modeling with Databricks SQL1 topic · 5 min fast trackStar, snowflake and data vault schemas and how they map to the Medallion Architecture.
  1. 1Data Models and the Medallion Architecture5 min
Read the chapter overview →
9Securing Data1 topic · 5 min fast trackUnity Catalog privileges, the three level namespace, ownership and PII protection.
  1. 1Unity Catalog Security and PII Protection5 min
Read the chapter overview →

Ready for more practice?

The full Databricks Data Analyst Associate question bank has 600 questions, with timed practice exams and an explanation for every answer.

Get Full AccessTry Sample Exam

This study guide is independent and is not affiliated with, endorsed by, or sponsored by Databricks. Vendor names, certification names and exam codes are trademarks of their respective owners and are used for identification only.