Databricks Certified Data Analyst Associate practice examsIn development
Databricks Certified Data Analyst Associate
SQL and dashboards on the lakehouse: warehouse behaviour on lake storage through the Delta log, sizing a SQL warehouse for speed against scaling it for concurrency, the analytical SQL that actually appears — window functions, common table expressions and the HAVING distinction — managed against external tables and time travel, then visualisation and dashboard design, parameters against filters, alerts, Unity Catalog grants with row filters, and the statistical honesty an analyst is held to.
What you get
Papers are cut from the bank and weighted like the real exam, and no question appears in two of them. Every wrong answer comes back on later days until you have it right.
What the exam covers
| The lakehouse, SQL warehouses and querying | Not published |
| Dashboards, alerts, governance and analytical practice | Not published |
Two sample questions
1. Which explains a query that scans far more data than expected?
- The warehouse is too large
- Caching is enabled
- Statistics are current
- The filter does not align with the table's partitioning or clustering — correct
Why: When the filter does not align with how the data is laid out, no pruning occurs and the full table is scanned.
2. Which is a benefit of using a serverless SQL warehouse?
- Cost is always lower
- Compute starts quickly without managing infrastructure — correct
- Configuration is impossible
- Queries run slower
Why: A serverless warehouse starts quickly and removes infrastructure management, though cost depends on usage.
The real Databricks Certified Data Analyst Associate exam
| Length | 90 minutes |
|---|---|
| Questions | 45 |
| Pass mark | Scaled score; Databricks does not publish the percentage |
| Price | Purchased per attempt through the Databricks certification portal |
| Recommended before you sit it | None enforced. Working SQL knowledge is assumed. |
| Valid for | 2 years |
Exam facts as published by Databricks; always check the vendor’s page before you book.
Study Databricks Certified Data Analyst Associate with Chiron
Chiron is invitation-only while we are in beta, and nothing is for sale yet: invited accounts use every paper, drill and course note for free.