cert-bank

Exams

DBX-DAA Databricks Data Analyst Associate

Vendor
Databricks
Level
Associate
Questions
45
Time
90 min
Domains
9
In the bank
285

Practice 285 questionsTake a timed mock examDay-by-day study plan

Guides for this exam

The exam at a glance

LevelAssociate
Questions45
Time90 minutes (about 2 minutes per question)
Passing markNot published by the vendor

Domains and weights

DomainWeightPractice questions here
D1 · Understanding of the Databricks Data Intelligence Platform11%31
D2 · Managing Data8%23
D3 · Importing Data5%14
D4 · Executing Queries using Databricks SQL and SQL Warehouses20%58
D5 · Analyzing Queries15%43
D6 · Dashboards and Visualizations16%45
D7 · AI/BI Genie Agents (Genie Spaces)12%35
D8 · Data Modeling with Databricks SQL5%14
D9 · Securing Data8%22

D1 · Understanding of the Databricks Data Intelligence Platform 11%

Platform questions ask what a part of Databricks is and where it runs, often from the point of view of an analyst who is new to it. The split between the control plane, compute and storage usually decides. Strong options name the component that does the job; weaker ones mix up where data lives with where queries run.

What to watch for

Tasks in the official exam guide (3)
  • 1.1 Describe the core components of the Databricks Data Intelligence Platform
  • 1.2 Understand catalogs, schemas, tables, views, certified tables, metric views and lineage in Catalog Explorer
  • 1.3 Describe the role and features of Databricks Marketplace

D2 · Managing Data 8%

Data management questions describe an analyst looking for the right table or blocked from one, and ask how to find, trust or reach it. Metadata and privileges usually decide. Strong options use lineage, tags, comments and the right grant; weaker ones copy tables or guess from names.

What to watch for

Tasks in the official exam guide (3)
  • 2.1 Use Unity Catalog to discover, query and manage certified datasets
  • 2.2 Tag data assets with governed tags and view lineage, including external lineage
  • 2.3 Clean Unity Catalog table data in SQL: invalid data and missing values

D3 · Importing Data 5%

Import questions describe files or a partner's data and ask how to bring it in with the least effort. Whether the data keeps arriving and where it lives usually decide. Strong options use an incremental load or a share; weaker ones re-load everything or copy data that could be queried in place.

What to watch for

Tasks in the official exam guide (2)
  • 3.1 Explain approaches for bringing data into Databricks (S3, Delta Sharing, API intake, Auto Loader, Lakeflow Connect, Marketplace)
  • 3.2 Upload a data file with the Workspace UI

D4 · Executing Queries using Databricks SQL and SQL Warehouses 20%

Query questions show SQL in the editor or a notebook that fails, or a task to write, and ask for the quickest correct fix. Reading the error and the warehouse settings usually decides. Strong options fix the actual cause with the built-in assistant or a small edit; weaker ones restart compute or rewrite working SQL.

What to watch for

Tasks in the official exam guide (9)
  • 4.1 Use Genie Code (Databricks Assistant) in a notebook or SQL editor to write and debug queries
  • 4.2 Explain the role of a SQL warehouse in query execution
  • 4.3 Join a Delta table with a federated data source
  • 4.4 Create materialized views; choose streaming tables vs materialized views; dynamic vs materialized views
  • 4.5 Perform aggregate operations (count, approximate count distinct, mean, summary statistics)
  • 4.6 Combine tables with joins and set operations (union, union all)
  • 4.7 Sort and filter a table
  • 4.8 Create managed and external tables, including from multiple sources (CSV, Parquet, Delta)
  • 4.9 Use Delta Lake time travel to query historical versions

D5 · Analyzing Queries 15%

Analysis questions describe a slow or changed query and ask where to look to find out why. Query history and the query profile usually decide. Strong options read the profile for the slow step and act on the insight it gives; weaker ones change the warehouse size without knowing the cause.

What to watch for

Tasks in the official exam guide (6)
  • 5.1 Understand Photon features, benefits and supported workloads
  • 5.2 Identify poorly performing queries with Query Insights and the query profile
  • 5.3 Use Delta Lake history to audit, validate results and compare historical results
  • 5.4 Use query history and caching to reduce development time and latency
  • 5.5 Use Predictive Optimization and automatic Liquid Clustering based on table access patterns
  • 5.6 Fix a query to achieve the desired result

D6 · Dashboards and Visualizations 16%

Dashboard questions describe AI/BI dashboards, their viewers and their speed, and ask which setting or design meets the need. Permissions and caching usually decide. Strong options use the sharing mode and refresh setting built for the case; weaker ones duplicate dashboards or give viewers more access than they need.

What to watch for

Tasks in the official exam guide (7)
  • 6.1 Build AI/BI dashboards: pages, datasets and widgets
  • 6.2 Create visualizations in notebooks and the SQL editor
  • 6.3 Work with parameters in SQL queries and dashboards
  • 6.4 Share dashboards: permissions, shareable links and embedding
  • 6.5 Schedule an automatic dashboard refresh
  • 6.6 Configure an alert with a threshold and destination
  • 6.7 Choose the effective visualization type

D7 · AI/BI Genie Agents (Genie Spaces) 12%

Genie questions ask what a Genie Agent (Genie space) is for and how to make its answers reliable. Curated data and instructions usually decide. Strong options give it the right tables, example questions and trusted SQL; weaker ones expect good answers from raw tables with no context.

What to watch for

Tasks in the official exam guide (4)
  • 7.1 Describe the purpose, features and components of AI/BI Genie Agents (Genie spaces)
  • 7.2 Create Genie spaces: sample questions, instructions, warehouses, curated datasets, trusted assets
  • 7.3 Assign permissions and distribute Genie spaces (embedded links, integrations, channel apps)
  • 7.4 Optimize Genie spaces: monitoring, feedback, benchmarks, metadata refresh

D8 · Data Modeling with Databricks SQL 5%

Modeling questions describe fact and dimension tables and ask which model or change fits the reporting need. Join depth and how users query usually decide. Strong options keep a simple star schema for analysis; weaker ones split dimensions into chains of tables that slow every query.

What to watch for

Tasks in the official exam guide (2)
  • 8.1 Apply star, snowflake and data vault models to analytical workloads
  • 8.2 Align industry-standard models with the Medallion Architecture

D9 · Securing Data 8%

Security questions describe an analyst or partner who needs access to a function, table or share, and ask for the smallest grant. Unity Catalog's privilege chain usually decides. Strong options grant the needed privilege at the right level, or share data instead of copying it; weaker ones transfer ownership or open whole catalogs.

What to watch for

Tasks in the official exam guide (3)
  • 9.1 Use Unity Catalog roles and sharing settings to secure objects
  • 9.2 Understand the Unity Catalog three-level namespace
  • 9.3 Apply storage and management best practices: table ownership and PII protection

A study order that works

The 17-day study plan for DBX-DAA takes the domains in this order. Each day has a short reading, key terms and a quiz from the bank.

  1. Day 1: D1 · Understanding of the Databricks Data Intelligence Platform
  2. Day 2: D2 · Managing Data
  3. Day 3: D3 · Importing Data
  4. Days 4–7: D4 · Executing Queries using Databricks SQL and SQL Warehouses
  5. Days 8–9: D5 · Analyzing Queries
  6. Days 10–12: D6 · Dashboards and Visualizations
  7. Days 13–14: D7 · AI/BI Genie Agents (Genie Spaces)
  8. Day 15: D8 · Data Modeling with Databricks SQL
  9. Day 16: D9 · Securing Data
  10. Day 17: Final Review: Decision Cheat-Sheet Across the Nine Domains

Recent changes to these questions

About these questions

Every question is original, written from the public exam guide and checked against the vendor's own documentation. None comes from a real exam. Each one has an explanation of why the answer is right and why the other options are wrong. How the questions are written.