DDA
Databricks Data Analyst (DDA) practice exams
215 questions in 5 timed practice tests. Each test has about 45 questions and a 90-minute limit. The pass mark is 70%. Results are split across the 9 exam domains.
Exam at a glance
| Practice tests | 5 |
|---|---|
| Questions in total | 215 |
| Questions per test | About 45 |
| Time limit per test | 90 minutes |
| Pass mark | 70% |
| Question types | Single answer and multiple answer (20 multiple-answer questions) |
| Level | Associate |
| Category | Data & Analytics |
These are the settings of our practice tests. Check the official Databricks exam page for the current exam format before you book.
Domains and weights
| Domain | Weight | Weight bar | Questions in our bank |
|---|---|---|---|
| Understanding of Databricks Data + AI Platform | 11% | 24 | |
| Managing Data | 8% | 17 | |
| Importing Data | 5% | 10 | |
| Executing Queries Using Databricks SQL and SQL Warehouses | 20% | 43 | |
| Analyzing Queries | 15% | 33 | |
| Creating Dashboards and Visualizations | 16% | 34 | |
| Developing, Sharing, and Maintaining AI/BI Genie Spaces | 12% | 26 | |
| Data Modeling with Databricks SQL | 5% | 11 | |
| Securing Data | 8% | 17 |
Sample questions
Question 1 of 3
Which component of the Databricks platform provides centralized access control, auditing, lineage and data discovery across all workspaces attached to the same metastore?
- A Photon
- B Delta Lake
- C Databricks Marketplace
- D Unity Catalog (correct answer)
Question 2 of 3
An analyst runs VACUUM with the default retention on a Delta table, then tries to query a version from three weeks ago with VERSION AS OF and gets an error. What explains this?
- A VACUUM compacted small files into larger ones, so the old version's file names no longer match the log
- B VACUUM removed the data files that the old version referenced because they were older than the retention threshold (correct answer)
- C VACUUM rewrote the transaction log into a single checkpoint file, so all earlier version numbers were renumbered
- D VACUUM converted the table to an external table, and external tables do not support time travel queries
Question 3 of 3
New CSV files land daily in a Unity Catalog volume. An analyst wants a SQL statement that loads only files not loaded before into an existing Delta table, so rerunning it does not create duplicates. Which statement fits?
- A MERGE INTO the table from a temporary view of the path
- B INSERT INTO ... SELECT * FROM read_files on the path
- C CREATE OR REPLACE TABLE ... AS SELECT from the path
- D COPY INTO with the volume path and FILEFORMAT = CSV (correct answer)
See all 10 free DDA questions with answers Read them or quiz yourself.
What your score report looks like
Example attempt, DDA practice test 3
74%
Passed
Pass mark 70%
| Domain | Weight | Your score | % |
|---|---|---|---|
| Understanding of Databricks Data + AI Platform | 11% | 88 | |
| Managing Data | 8% | 81 | |
| Importing Data | 5% | 76 | |
| Executing Queries Using Databricks SQL and SQL Warehouses | 20% | 58 | |
| Analyzing Queries | 15% | 84 | |
| Creating Dashboards and Visualizations | 16% | 72 |
Study next: Executing Queries Using Databricks SQL and SQL Warehouses. It is below the pass mark and carries 20% of the exam.
Study plans
Two weeks
- Day 1: take practice test 1 in exam mode to get a baseline.
- Days 2 to 5: domain mode on Executing Queries Using Databricks SQL and SQL Warehouses and Creating Dashboards and Visualizations, the two most heavily weighted domains.
- Day 6: practice test 2 in exam mode, then the mistakes quiz.
- Days 7 to 12: practice tests 3 to 5, one every other day, each followed by its mistakes quiz.
- Days 13 and 14: final mode. Book the exam when your readiness stays above the pass mark.
Four weeks
- Week 1: one practice test in practice mode, reading every explanation. Note your two lowest domains.
- Week 2: domain mode on those two domains, then a second practice test in exam mode.
- Week 3: practice tests 3 and 4 in exam mode, with the mistakes and flagged quizzes after each.
- Week 4: practice test 5 and final mode until your readiness holds above the pass mark.
Questions about the DDA practice exams
- Are these real DDA exam questions?
- No. We write every question ourselves and map it to the published DDA exam objectives. We do not use leaked or recalled questions.
- Do the time limit and pass mark match the official exam?
- They match the settings of our practice tests. Exam providers change their format from time to time, so check the official exam page before you book.
- Can I try it before I pay?
- Yes. The free mini exam has 15 questions with full explanations and needs no account.
- How long do I keep access?
- A single-exam purchase gives you 12 months of access. All-Access includes this exam for as long as your subscription runs.
- What happens after I finish a test?
- You get a score, a pass or fail against the pass mark, a score per domain and every answer with its explanation.
Related exams
| Exam | Vendor | Level | Questions | Minutes | Price |
|---|---|---|---|---|---|
| DCDEPDatabricks Certified Data Engineer Pro | Databricks | Professional | 300 | 120 | $14.99 |
| DMLPDatabricks Machine Learning Professional | Databricks | Professional | 300 | 120 | $14.99 |
| DASDDatabricks Apache Spark Developer | Databricks | Associate | 225 | 90 | $12.99 |
| DCEADatabricks Context Engineer Associate | Databricks | Associate | 225 | 90 | $12.99 |
| DP-900Azure Data Fundamentals DP-900 | Microsoft | Foundational | 225 | 45 | $9.99 |
| SPLK-1001Splunk Core Certified User (SPLK-1001) | Splunk | Foundational | 300 | 60 | $9.99 |