Data Analyst Associate: practice questions
SQL edge cases decide this exam: nulls in aggregates, window frames, and the rules that make two reasonable-looking queries return different numbers.
Data Analyst Associate set
12 questions, drawn fresh from the bank. Every code question was executed on Spark before it shipped, and each answer links to the documentation it rests on.
No account needed to practise. Sign in to keep your best score per set, see progress on your account page, and turn wrong answers into a reading list.
A sample question, with the answer
A column has values 10, NULL, and 20. What do COUNT(*) and COUNT(col) return?
- a3 and 3
- b3 and 2correct
- c2 and 2
- d3 and NULL
Why: COUNT(*) counts rows; COUNT(col) counts non-null values of that column. Mixing the two inside one report is a classic source of numbers that almost match.
Exam facts
Facts reflect the official materials at our last review; exams change, so verify against the official page before booking.
Prep with the AI assistant you already use
Databricks’ recommended prep flow now includes an official AI Prep Guide of copy-paste prompts. Here is ours, tuned to this exam. Paste it into any assistant, or ask the Brickster Assistant, which answers with citations from this archive.
I am preparing for the Databricks Certified Data Analyst Associate exam. Quiz me with 10 original multiple-choice questions in the style of that exam, one at a time, across these areas: dbsql, data-quality, spark. Never reuse real exam content. Do not show the answer until I respond. After each answer, explain why, and ground the explanation in docs.databricks.com. Keep score. At the end, list my weakest areas and what to read for each.
Go deeper on the weak spots
Each topic below has a live page with an AI synthesis of recent activity and the items behind it. Wrong answers in the set above link to these too.
Frequently asked
How many questions is the Data Analyst Associate exam?
45 scored questions in 90 minutes, per the official exam guide (October 2025 version). It costs $200 and the credential is valid for two years. Databricks recommends six or more months of hands-on experience and does not publish the passing score.
Are these real exam questions?
No. Every question is original, written from public documentation, and SQL questions were executed before publication so the key matches what the engine returns.
brickster.ai is an independent community project, not affiliated with, endorsed by, or sponsored by Databricks, Inc. Nothing here is drawn from real exam content, and no practice result predicts a certification outcome.