Databricks Data Analyst Associate: Complete Guide to SQL & Dashboards

The Databricks Certified Data Analyst Associate (DAA) is the certification that measures practical skills in writing queries, building dashboards, and analyzing data with Databricks SQL. It centers on SQL knowledge, and no Python or Spark coding is required. In late 2025, AI/BI Genie was added to the exam scope, making it a 9-domain exam.

Exam Overview

9-Domain Weighting Table

The SQL Query domain carries the largest weight at 16%. Most questions ask you to interpret the results of SQL execution, so you must understand JOINs, window functions, and CTEs. Databricks SQL follows at 14%, testing your knowledge of SQL warehouse configuration and management.

Databricks SQL Warehouse Configuration

SQL Warehouse is the compute resource for Databricks SQL, and it comes in three types.

Warehouse Settings Tested on the Exam

• Cluster size: Selectable from 2X-Small to 4X-Large. Size affects parallel query execution capacity; larger sizes increase cost
• Auto Stop: Setting that auto-stops the warehouse after a period of idle time. Default is 10 minutes. Directly tied to cost management
• Scaling: Set minimum and maximum cluster counts so the warehouse auto-scales based on concurrent queries. Each cluster handles up to 10 parallel queries

Dashboard Creation and Sharing

Dashboard Creation Workflow

• Write a SQL query and configure the results as a visualization (chart)
• Arrange multiple visualizations on the dashboard canvas
• Add filter widgets so users can dynamically narrow down the data
• Set an automatic refresh schedule to keep data fresh

Sharing and Access Control

• "Can Run" permission: Can view the dashboard and operate filters. Cannot view the underlying SQL queries or data sources
• "Can Edit" permission: Can modify the dashboard layout, edit queries, and add visualizations
• If the user you share with does not have SELECT permission on the underlying tables, the dashboard's "Credentials" setting lets you choose whether queries run with the owner's permissions or the viewer's own permissions

AI/BI Genie

AI/BI Genie is a natural-language interface for querying data. Ask a question like "What were the top 5 products by sales last month?" and Genie auto-generates the appropriate SQL and returns the results.

• Genie Space: The space where you configure which tables Genie can reference and which SQL warehouse it uses. Administrators control which tables are exposed to Genie
• Access permissions: Queries executed via Genie still follow Unity Catalog permissions. Genie cannot return data from tables on which the user lacks SELECT permission
• Certified Answer: Question-and-answer pairs pre-approved by an administrator. Lets you pre-define accurate SQL for frequent questions like "quarterly sales"
• Limitations: Generation accuracy is limited for complex multi-table JOINs, subqueries, and window functions. Understanding the verification workflow for generated SQL is useful exam prep

SQL Query Optimization

• Result Cache: Returns cached results when the same query is re-executed. Enabled at the SQL warehouse level. The cache is automatically invalidated when the underlying data is updated
• OPTIMIZE: Compacts small files to improve query performance. OPTIMIZE my_table ZORDER BY (column1) specifies the filter column
• ANALYZE TABLE: Collects table statistics to improve the Catalyst optimizer's plan selection accuracy. ANALYZE TABLE my_table COMPUTE STATISTICS FOR ALL COLUMNS
• Query Profile: A tool that visualizes the query execution plan and identifies bottlenecks (full scans, spills, skew). Accessible from the "Query Profile" tab in the Databricks SQL query editor

Alert Configuration

• Sends a notification when a SQL query's results meet a specified condition. Used for business rules like "sales dropped below threshold" or "error count exceeded 100"
• Trigger condition: Set a threshold against a numeric column using comparison operators like >, <, or =
• Notification destinations: Three options: email, Slack, and Webhook (PagerDuty etc.). Multiple destinations can be configured simultaneously
• Evaluation frequency: Schedule the alert evaluation interval. Each time the query runs on schedule, the condition is evaluated, and a notification fires if the condition is met

Using Query History

• A feature that records and lets you search every query that has been executed. Query text, executor, execution time, rows scanned, and cost information are all recorded
• Performance analysis: Identify long-running queries and use Query Profile to pinpoint optimization opportunities
• Cost management: Visualize query execution counts and costs per user and per warehouse to optimize resource allocation
• Auditing: Use as an audit trail of who accessed which data and when, supporting compliance requirements

DAA vs. DEA Comparison Table

Check Your Understanding with a Question

Frequently Asked Questions