Free Practice Questions for Databricks Certified Data Analyst Associate Certification
- Exam guide version:
- October 8, 2026
- Guide checked for updates:
- 20 Nov 2026
- Question bank created:
- 15 Sep 2026
- Question bank last updated:
- 19 Nov 2026
Study with 390 exam-style practice questions designed to help you prepare for the Databricks Certified Data Analyst Associate. All questions are aligned with the latest exam guide and include detailed explanations to help you master the material.
Your progress
LessonsNew
39 documentation-grounded lessons, one per exam-guide subdomain — every claim cited to the official docs.Based on the official docs as of 31 Oct 2026
Start Practicing
Start a quiz
Practice with randomly mixed questions from all topics
Exam experiences
Pass and fail outcomes from candidates who prepared here — advice, scores, and prep time.
Your saved questions
Open the list of questions you bookmarked during practice for this exam.
Study notes
Private notes per question, grouped by exam domain — opens on its own page, not inline on this overview.
Quiz History
Exam Details
Key information about Databricks Certified Data Analyst Associate
- Multiple choice
None is required; related course attendance and six months of hands-on experience as a Data Analyst are highly recommended.
Online proctored or test center proctored
Recertification is required every two years to maintain your certified status. To recertify, you must take the full exam that is currently live.
90 minutes
45 scored multiple-choice questions
2 years
Exam Topics & Skills Assessed
Skills measured (from the official study guide)
1: Understanding of Databricks Data Intelligence Platform (Lakehouse Platform)
1.1: Describe the core components of the Databricks Data Intelligence Platform (Lakehouse Platform), including Mosaic AI, Lakeflow Declarative Pipelines (DeltaLive tables), Lakeflow Jobs, Data Intelligence Engine, Delta Lake, Lakebase, Unity Catalog, and Databricks SQL.
Describe the core components of the Databricks Data Intelligence Platform (Lakehouse Platform), including Mosaic AI, Lakeflow Declarative Pipelines (DeltaLive tables), Lakeflow Jobs, Data Intelligence Engine, Delta Lake, Lakebase, Unity Catalog, and Databricks SQL.
1.2: Understand catalogs, schemas, managed and external tables, access controls, views, certified tables, metric views, and lineage within the Catalog Explorer interface.
Understand catalogs, schemas, managed and external tables, access controls, views, certified tables, metric views, and lineage within the Catalog Explorer interface.
1.3: Describe the role and features of Databricks Marketplace.
Describe the role and features of Databricks Marketplace.
2: Managing Data
2.1: Use Unity Catalog to discover, query, and manage certified datasets.
Use Unity Catalog to discover, query, and manage certified datasets.
2.2: Use the Catalog Explorer to tag a data asset with governed tags and view its lineage, including external lineage.
Use the Catalog Explorer to tag a data asset with governed tags and view its lineage, including external lineage.
2.3: Perform data cleaning on Unity Catalog Tables in SQL, including removing invalid data or handling missing values.
Perform data cleaning on Unity Catalog Tables in SQL, including removing invalid data or handling missing values.
3: Importing Data
3.1: Explain the approaches for bringing data into Databricks, covering ingestion from S3, data sharing with external systems via Delta Sharing, API-driven data intake, Auto Loader, Lakeflow Connect managed connectors, and Marketplace.
Explain the approaches for bringing data into Databricks, covering ingestion from S3, data sharing with external systems via Delta Sharing, API-driven data intake, Auto Loader, Lakeflow Connect managed connectors, and Marketplace.
3.2: Use the Databricks Workspace UI to upload a data file to the platform.
Use the Databricks Workspace UI to upload a data file to the platform.
4: Executing queries using Databricks SQL and Databricks SQL Warehouses
4.1: Utilize Genie Code (Databricks Assistant) within a Notebook or SQL Editor to facilitate query writing and debugging.
Utilize Genie Code (Databricks Assistant) within a Notebook or SQL Editor to facilitate query writing and debugging.
4.2: Explain the role a SQL Warehouse plays in query execution.
Explain the role a SQL Warehouse plays in query execution.
4.3: Querying cross-system analytics by joining data from a Delta table and a federated data source.
Querying cross-system analytics by joining data from a Delta table and a federated data source.
4.4: Create a materialized view, including knowing when to use Streaming Tables and Materialized Views, and differentiate between dynamic and materialized views.
Create a materialized view, including knowing when to use Streaming Tables and Materialized Views, and differentiate between dynamic and materialized views.
4.5: Perform aggregate operations such as count, approximate count distinct, mean, and summary statistics.
Perform aggregate operations such as count, approximate count distinct, mean, and summary statistics.
4.6: Write queries to combine tables using various join operations (inner, left, right, and so on) with single or multiple keys, as well as set operations like union and union all, including the differences between the joins (inner, left, right, and so on).
Write queries to combine tables using various join operations (inner, left, right, and so on) with single or multiple keys, as well as set operations like union and union all, including the differences between the joins (inner, left, right, and so on).
4.7: Perform sorting and filtering operations on a table.
Perform sorting and filtering operations on a table.
4.8: Create managed tables and external tables, including creating tables by joining data from multiple sources (e.g., CSV, Parquet, Delta tables) to create unified datasets, including Unity Catalog.
Create managed tables and external tables, including creating tables by joining data from multiple sources (e.g., CSV, Parquet, Delta tables) to create unified datasets, including Unity Catalog.
4.9: Use Delta Lake's time travel to access and query historical data versions.
Use Delta Lake's time travel to access and query historical data versions.
5: Analyzing Queries
5.1: Understand the Features, Benefits, and Supported Workloads of Photon.
Understand the Features, Benefits, and Supported Workloads of Photon.
5.2: Identify poorly performing queries in the Databricks Intelligence platform, such as Query Insights, Query Profiler log, etc.
Identify poorly performing queries in the Databricks Intelligence platform, such as Query Insights, Query Profiler log, etc.
5.3: Utilize Delta Lake to audit and view history, validate results, and compare historical results or trends.
Utilize Delta Lake to audit and view history, validate results, and compare historical results or trends.
5.4: Utilize query history and caching to reduce development time and query latency.
Utilize query history and caching to reduce development time and query latency.
5.5: Analyze table access patterns and query workloads to determine when to leverage Predictive Optimization and Automatic Liquid Clustering to optimize table performance.
Analyze table access patterns and query workloads to determine when to leverage Predictive Optimization and Automatic Liquid Clustering to optimize table performance.
5.6: Fix a query to achieve the desired results.
Fix a query to achieve the desired results.
6: Working with Dashboards and Visualizations in Databricks
6.1: Build dashboards using AI/BI Dashboards, including multi-tabs/page layouts, multiple data sources/datasets, and widgets (visualizations, text, images).
Build dashboards using AI/BI Dashboards, including multi-tabs/page layouts, multiple data sources/datasets, and widgets (visualizations, text, images).
6.2: Create visualizations in notebooks and the SQL editor.
Create visualizations in notebooks and the SQL editor.
6.3: Work with parameters in SQL queries and dashboards, including defining, configuring, and testing parameters.
Work with parameters in SQL queries and dashboards, including defining, configuring, and testing parameters.
6.4: Configure permissions through the UI to share dashboards with workspace users/groups, external users through shareable links, and embed dashboards in external apps.
Configure permissions through the UI to share dashboards with workspace users/groups, external users through shareable links, and embed dashboards in external apps.
6.5: Schedule an automatic dashboard refresh.
Schedule an automatic dashboard refresh.
6.6: Configure an alert with a desired threshold and destination.
Configure an alert with a desired threshold and destination.
6.7: Identify the effective visualization type to communicate insights clearly.
Identify the effective visualization type to communicate insights clearly.
7: Developing, Sharing, and Maintaining AI/BI Genie Agents (Genie Spaces)
7.1: Describe the purpose, key features, and components of AI/BI Genie Agents (Genie spaces).
Describe the purpose, key features, and components of AI/BI Genie Agents (Genie spaces).
7.2: Create Genie Agents (Genie spaces) by defining reasonable sample questions and domain-specific instructions, choosing SQL warehouses, curating Unity Catalog datasets (tables, views...), and vetting queries as Trusted Assets.
Create Genie Agents (Genie spaces) by defining reasonable sample questions and domain-specific instructions, choosing SQL warehouses, curating Unity Catalog datasets (tables, views...), and vetting queries as Trusted Assets.
7.3: Assign permissions via the UI and distribute Genie Agents (Genie spaces) using embedded links, external app integrations, and channel apps.
Assign permissions via the UI and distribute Genie Agents (Genie spaces) using embedded links, external app integrations, and channel apps.
7.4: Optimize AI/BI Genie Agents (Genie spaces) by tracking user questions, response accuracy, and feedback; updating instructions and trusted assets based on stakeholder input; validating accuracy with benchmarks; refreshing Unity Catalog metadata.
Optimize AI/BI Genie Agents (Genie spaces) by tracking user questions, response accuracy, and feedback; updating instructions and trusted assets based on stakeholder input; validating accuracy with benchmarks; refreshing Unity Catalog metadata.
8: Data Modeling with Databricks SQL
8.1: Apply industry-standard data modeling techniques, such as star, snowflake, and data vault schemas, to analytical workloads.
Apply industry-standard data modeling techniques, such as star, snowflake, and data vault schemas, to analytical workloads.
8.2: Understand how industry-standard models align with the Medallion Architecture.
Understand how industry-standard models align with the Medallion Architecture.
9: Securing Data
9.1: Use Unity Catalog roles and sharing settings to ensure workspace objects are secure.
Use Unity Catalog roles and sharing settings to ensure workspace objects are secure.
9.2: Understand how the 3-level namespace (Catalog / Schema / Tables or Volumes) works in the Unity Catalog.
Understand how the 3-level namespace (Catalog / Schema / Tables or Volumes) works in the Unity Catalog.
9.3: Apply best practices for storage and management to ensure data security, including table ownership and PII protection.
Apply best practices for storage and management to ensure data security, including table ownership and PII protection.
Techniques & products