Databricks Certified Data Analyst Associate

The Databricks Certified Data Analyst Associate validates proficiency in using Databricks SQL to perform data analysis, visualization, and dashboard creation on the Databricks Data Intelligence Platform. It covers data management with Unity Catalog, query execution and optimization using Databricks SQL Warehouses, building AI/BI dashboards, and securing data — equipping analysts to deliver insight-driven solutions on a modern lakehouse architecture.

Request Training Email Inquiry

What is the Databricks Certified Data Analyst Associate?

Who Should Take This Course?

Data Analysts transitioning to cloud-based analytics with Databricks
SQL Analysts and BI professionals working with Databricks SQL
Business Intelligence developers building dashboards in Databricks
Analytics engineers managing data with Unity Catalog
Data professionals integrating Databricks with BI tools (Tableau, Power BI)
Anyone seeking to validate Databricks SQL and data analysis skills

What You Will Learn in the DAA Course

A comprehensive curriculum covering all exam objectives with hands-on labs and real-world practice.

Databricks Data Intelligence Platform

Understand the Databricks platform and how it supports analytics workloads.

Databricks Lakehouse architecture and components
Databricks SQL Warehouses: serverless and classic compute
Unity Catalog overview for data governance
Navigating the Databricks workspace and SQL editor

Managing and Importing Data

Discover, manage, and import datasets using Unity Catalog and ingestion tools.

Unity Catalog: schemas, tables, volumes, and catalogs
Ingesting data via UI uploads, S3, and Auto Loader
Delta Sharing for external data access
Databricks Marketplace for third-party datasets

Executing and Optimizing Queries

Write efficient SQL queries and optimize performance on Databricks.

SQL fundamentals: SELECT, JOIN, GROUP BY, subqueries
Creating and managing views and CTEs
Aggregate functions, window functions, and advanced SQL
Query performance: Liquid Clustering and query history auditing

Analyzing Queries and Performance

Audit and tune queries for production-grade analytics.

Query profiling with Databricks query history
Identifying bottlenecks with query plans
Access logs and audit trails for compliance
Liquid Clustering and Z-ordering for faster scans

Dashboards, Visualizations, and AI/BI Genie

Build and share interactive dashboards and AI-powered analytics.

Creating visualizations: bar, line, scatter, and pivot charts
Building AI/BI Dashboards with filters and parameters
Developing and maintaining AI/BI Genie spaces (natural language analytics)
Sharing dashboards and managing access permissions

Data Modeling and Security

Model data effectively and apply security best practices.

Star schema and dimensional modeling with Databricks SQL
Managing table properties and constraints
Row-level security and column masking policies
Data storage best practices and access controls

Course Prerequisites

Pre-requisites training is free when you purchase the course from ProSupport

Basic to intermediate SQL knowledge
Familiarity with data warehousing or analytics concepts
6+ months of hands-on experience with data analysis tasks (recommended)
No formal prerequisites required — related Databricks Academy training highly recommended

Exam Information

Everything you need to know about the DAA certification exam.

Exam Component	Details
Exam Name	Databricks Certified Data Analyst Associate
Exam Code	DAA
Exam Type	Multiple Choice
Total Questions	45
Passing Score	70%
Exam Duration	90 minutes
Language	English
Exam Provider	Databricks / Kryterion (online proctored or test center)
Exam Focus	Databricks SQL, Unity Catalog, data ingestion, query optimization, dashboards, and AI/BI Genie
Exam Registration	Databricks Academy portal (academy.databricks.com)
Retake Policy	14-day waiting period before retake
Certification Validity	2 years