Databricks Certified Data Analyst Associate Questions and Answers
200 questions organized by topic with detailed explanations
Databricks
DAA
200 questions
9 topics
Updated May 2026Understanding of Databricks Data Intelligence Platform
22 questions8 easy10 medium4 hard~11% of exam
A data analyst wants to understand the full hierarchy used to organize data assets in Unity Catalog. Which correctly rep...A company has multiple Databricks workspaces in the same region and wants to control which workspaces can access a speci...What is the primary storage format used by managed tables in Unity Catalog?
Managing Data
16 questions4 easy8 medium4 hard~8% of exam
An analyst wants to query data in a Unity Catalog table and also review its column descriptions and table-level comments...A data analyst is working with a Unity Catalog managed table and wants to revert a destructive `DELETE` operation that w...In Unity Catalog, what is the difference between a managed table and an external table regarding data lifecycle?
Importing Data
10 questions4 easy2 medium4 hard~5% of exam
A data analyst wants to import a CSV file from their local machine into a Databricks SQL table without writing any code....A data engineering team uses Auto Loader to ingest JSON files from an S3 bucket into a Delta table. After several days o...A company receives live data updates from a partner organization that uses a different cloud platform. The partner wants...
Executing queries using Databricks SQL and Databricks SQL Warehouses
40 questions10 easy20 medium10 hard~20% of exam
An analyst writes a query that joins an orders table with a customers table and wants to include all orders regardless o...An analyst needs to create a view in Databricks SQL that aggregates sales data by region. Other analysts on the team sho...An analyst needs to assign a sequential rank to each sale within each sales region, ordered by sale amount descending, w...
Analyzing Queries
30 questions7 easy15 medium8 hard~15% of exam
Which Databricks SQL command shows a Delta table's full transaction history, including the version number, timestamp, an...Which Databricks SQL feature provides a visual representation of how a query is executed, showing operations like scans,...An analyst needs to enforce Liquid clustering on an existing unpartitioned Delta table named `transactions` using the `t...
Creating Dashboards and Visualizations in Databricks
32 questions10 easy13 medium9 hard~16% of exam
Which visualization type in Databricks AI/BI dashboards is most appropriate for showing a trend of monthly sales totals ...In Databricks AI/BI dashboards, what is the primary purpose of a dataset?An analyst is building an AI/BI dashboard and wants to create a custom metric that calculates profit margin as (revenue ...
Developing, Sharing, and Maintaining AI/BI Genie spaces
24 questions5 easy12 medium7 hard~12% of exam
When a user submits a question in a Genie Space, what does Genie generate to answer the question?A Genie Space author adds several example SQL queries to the knowledge store. A business user asks a question and the ex...A domain expert is setting up a Genie Space and wants to teach Genie how to correctly join two tables that have a non-ob...
Data Modeling with Databricks SQL
10 questions3 easy4 medium3 hard~5% of exam
An analyst is designing a data model in Databricks SQL and wants to create a reusable query layer that executes the unde...In Databricks SQL, what is the key difference between a standard view and a materialized view?A data analyst is building a reporting layer in Databricks SQL. The business requires a table that always reflects the l...
Securing Data
16 questions3 easy10 medium3 hard~8% of exam
A company stores customer PII data in a Unity Catalog table. The data governance team requires that only users in the `c...A Databricks data analyst wants to confirm which privileges have been granted on a specific table in Unity Catalog. Whic...A data analyst needs to enforce that users in a specific group can only see rows in a sales table where the region colum...
All Questions
| # | Question | Topic | Difficulty |
|---|---|---|---|
| 1 | Which Databricks SQL command shows a Delta table's full transaction history, including the version n... | Analyzing Queries | easy |
| 2 | An analyst writes a query that joins an orders table with a customers table and wants to include all... | Executing queries using Databricks SQL and Databricks SQL Warehouses | medium |
| 3 | When a user submits a question in a Genie Space, what does Genie generate to answer the question? | Developing, Sharing, and Maintaining AI/BI Genie spaces | easy |
| 4 | Which Databricks SQL feature provides a visual representation of how a query is executed, showing op... | Analyzing Queries | easy |
| 5 | An analyst needs to create a view in Databricks SQL that aggregates sales data by region. Other anal... | Executing queries using Databricks SQL and Databricks SQL Warehouses | medium |
Sign in to see all 200 questions
Create a free account to browse all questions — completely free during our launch phase.
Ready to test your knowledge?
Take a full Databricks Certified Data Analyst Associate practice test with timed exam simulation.
Start Practice Test