Original questions, written to the 2026 exam guide
Why these and not a dump
These are practice questions, not leaked exam content. Each one teaches the concept the real exam tests, with an explanation you can check against the Databricks docs. Why dumps fail →
Executing queries using Databricks SQL and Databricks SQL Warehouses
- A data analyst joins a `customers` table with an `orders` table on customer_id. Some customers have never placed an order. The analyst…
- A data engineer needs a Delta table to support time travel queries going back 60 days. The default VACUUM retention is 7 days. Which…
- A data analyst opens a table result in a Databricks notebook and wants to automatically see summary statistics for all column types —…
- A data team designs a Databricks SQL pipeline with two use cases: (1) near-real-time ingestion of continuously arriving IoT sensor records…
- A data analyst attempts to run SELECT * FROM orders TIMESTAMP AS OF '2025-10-01' in January 2026, targeting a version from roughly 90 days…
- A data engineering team connects their Snowflake environment to Unity Catalog using Lakehouse Federation. They want all query execution for…
- A security team needs a view in Databricks SQL that applies row-level filtering based on the current querying user's identity and group…
- A data analyst running a query in a Databricks SQL Editor receives a syntax error. She wants Databricks Assistant to automatically identify…
- A data analyst needs to understand why a complex SQL query joining five tables is not returning expected results. She wants a step-by-step…
Working with Dashboards and Visualizations in Databricks
- A Databricks account user who has NOT been added to the workspace is granted CAN EDIT permission on a published dashboard through the…
- A dashboard author publishes a dashboard and wants viewers who do NOT have direct access to the underlying Unity Catalog tables to still…
- A data analyst needs to configure an AI/BI dashboard to refresh automatically every morning at 6:00 AM in their local time zone. Which…
- After running a SQL query in the Databricks SQL editor, a data analyst wants to create a bar chart from the result set. What is the correct…
- A data analyst wants to show what percentage of total quarterly revenue each of the five product categories contributed. The goal is to…
- A data analyst is monitoring daily active users across a 12-month period and wants to display the overall trend, including seasonal spikes…
- A data analyst wants to build an AI/BI dashboard that includes a free-form explanatory paragraph alongside a chart visualization. Which…
Analyzing Queries
- A data analyst wants to review all queries run against a specific SQL warehouse by all users over the past 7 days, including failed…
- A data analyst wants to compare the row counts in a Delta table as they existed one week ago against the counts today to detect unexpected…
- A data analyst clicks on a query in Query History and notices that the Query Profile panel shows 'Query profile is not available' for that…
- A data analyst manages a 50 TB Delta table that is currently partitioned by ingestion_date. Analysts frequently filter on customer_region…
- A data analyst writes the following query to find customers who have made at least one purchase in 2025: SELECT customer_id FROM orders…
- A data engineering team wants to speed up large-scale SQL aggregations and Delta table MERGE operations without changing any code. They are…
- A data analyst in a Databricks SQL Editor frequently reruns the same complex query during iterative development. She notices that after the…
Developing, Sharing, and Maintaining AI/BI Genie spaces
- A data analyst wants to add a complex SQL function to a Genie space so that Genie can invoke it as a verified trusted asset when answering…
- A Genie space author has added several example SQL queries to the space's instruction context. Under what precise condition does Genie…
- A Genie space author wants to run a structured test to measure whether Genie correctly answers a predefined set of business questions. The…
- A technical architect asks how Genie generates SQL responses differently from a conventional single large language model (LLM) chatbot…
- After a Genie space has been deployed, business users mark several responses as incorrect using the 'Fix it' feedback option. The author…
Managing Data
- A data analyst at a retail company wants to confidently use only high-quality, authoritative datasets for their quarterly revenue report…
- A data governance team is tagging tables in Unity Catalog to support a new data classification initiative. A data steward needs to add a…
- A data engineer wrote a notebook six months ago that reads from `gold.finance.revenue_summary` and writes to…
- A data analyst is tasked with cleaning a Unity Catalog Delta table called `bronze.sales.transactions`. The table has the following data…
Securing Data
- A metastore admin grants the SELECT privilege on a catalog to a group of data analysts. According to Unity Catalog's inheritance model…
- A data governance administrator needs to delegate the ability to grant and revoke privileges on a Unity Catalog schema to a senior analyst…
- A security team requires that all users outside the `hr_analysts` group see NULL instead of the actual Social Security Number values in the…
- A data engineering lead wants to grant a team group read access to all tables in a schema — including tables that will be created in the…
Understanding of Databricks Data Intelligence Platform
- A solutions architect is designing a new data platform on Databricks. She has three distinct requirements: (1) ingest streaming events from…
- A financial services company wants to enrich its internal customer transaction data with third-party macroeconomic indicators and pre-built…
- A data engineer creates a managed Delta table named `analytics.sales.transactions` in Unity Catalog by running `CREATE TABLE…
- A data engineering team is evaluating the Databricks Data Intelligence Platform for the first time. A team member lists several platform…
- A data analyst at a logistics company is exploring Databricks Marketplace to acquire a public geospatial reference dataset and a Databricks…
Score it like the real exam
The same 45 questions, timed, with a section-by-section breakdown at the end. Free, no credit card.
Start the free Data Analyst practice test →