Free Practice Questions for Databricks Certified Data Engineer Associate Certification
- Exam guide version:
- August 6, 2026
- Guide checked for updates:
- 20 Nov 2026
- Question bank created:
- 15 Sep 2026
- Question bank last updated:
- 19 Nov 2026
Study with 402 exam-style practice questions designed to help you prepare for the Databricks Certified Data Engineer Associate. All questions are aligned with the latest exam guide and include detailed explanations to help you master the material.
Your progress
LessonsNew
33 documentation-grounded lessons, one per exam-guide subdomain — every claim cited to the official docs.Based on the official docs as of 17 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 Engineer Associate
- Multiple choice
Required every 2 years by taking the current live exam.
none allowed
None required; course attendance and six months of hands-on experience in Databricks are highly recommended.
Online or test center
USD 200
90 minutes
45 scored multiple-choice questions
2 years
Exam Topics & Skills Assessed
Skills measured (from the official study guide)
1: Databricks Intelligence Platform
1.1: Understand the core components of the Databricks Platform, such as its architecture, Delta Lake, and Unity Catalog
Understand the core components of the Databricks Platform, such as its architecture, Delta Lake, and Unity Catalog.
1.2: Understand Databricks Platform's compute services, including their characteristics, limitations, and cost models, and select the most suitable option for each workload use case
Understand Databricks Platform's compute services, including their characteristics, limitations, and cost models, and select the most suitable option for each workload use case.
2: Data Ingestion and Loading
2.1: Enable and detail data ingestion patterns, including batch, streaming, and incremental loading, and import data from sources such as local files, Lakeflow Connect standard connectors, and Lakeflow Connect managed connectors
Enable and detail data ingestion patterns, including batch, streaming, and incremental loading, and import data from sources such as local files, Lakeflow Connect standard connectors, and Lakeflow Connect managed connectors.
2.2: Use the COPY INTO command to incrementally load files from cloud object storage (ADLS/S3/GCS) into Unity Catalog-governed tables
Use the COPY INTO command to incrementally load files from cloud object storage (ADLS/S3/GCS) into Unity Catalog-governed tables.
2.3: Use Auto Loader with schema enforcement and schema evolution in batch modes (for example, directory listing or file notification) to land data into Unity Catalog-governed tables
Use Auto Loader with schema enforcement and schema evolution in batch modes (for example, directory listing or file notification) to land data into Unity Catalog-governed tables.
2.4: Configure Lakeflow Connect to reliably ingest data from diverse enterprise sources into Unity Catalog-governed tables
Configure Lakeflow Connect to reliably ingest data from diverse enterprise sources into Unity Catalog-governed tables.
2.5: Use JDBC/ODBC or REST clients in notebooks to land data into cloud storage or directly into Unity Catalog-governed tables, usually orchestrated and scheduled with Lakeflow Jobs
Use JDBC/ODBC or REST clients in notebooks to land data into cloud storage or directly into Unity Catalog-governed tables, usually orchestrated and scheduled with Lakeflow Jobs.
2.6: Prioritize between Auto Loader, Lakeflow Connect (standard and managed connectors), partner connectors, and other ingestion methods based on technical requirements such as data volume, ingestion frequency, data types, and governance needs with Unity Catalog
Prioritize between Auto Loader, Lakeflow Connect (standard and managed connectors), partner connectors, and other ingestion methods based on technical requirements such as data volume, ingestion frequency, data types, and governance needs with Unity Catalog.
2.7: Ingest semi-structured and unstructured data (for example, JSON and nested data) via Lakeflow Connect and other managed connectors into Unity Catalog-governed Delta tables
Ingest semi-structured and unstructured data (for example, JSON and nested data) via Lakeflow Connect and other managed connectors into Unity Catalog-governed Delta tables.
3: Data Transformation and Modeling
3.1: Implement data cleaning by reading bronze tables with PySpark/SQL, cleaning nulls, standardizing data types, and writing to new silver tables
Implement data cleaning by reading bronze tables with PySpark/SQL, cleaning nulls, standardizing data types, and writing to new silver tables.
3.2: Combine DataFrames with operations such as Inner join, left join, broadcast join, multiple keys, cross join, union, and union all
Combine DataFrames with operations such as Inner join, left join, broadcast join, multiple keys, cross join, union, and union all.
3.3: Manipulate columns, rows, and table structures by adding, dropping, splitting, renaming column names, applying filters, and exploding arrays
Manipulate columns, rows, and table structures by adding, dropping, splitting, renaming column names, applying filters, and exploding arrays.
3.4: Perform data deduplication operations and aggregate operations on DataFrames, such as count, approximate count distinct, and mean, summary
Perform data deduplication operations and aggregate operations on DataFrames, such as count, approximate count distinct, and mean, summary.
3.5: Understand the basic tuning parameters (spark.sql.shuffle.partitions, spark.default.parallelism, spark.executor/driver.memory, spark.sql.autoBroadcastJoinThreshold) and re-measure the performance
Understand the basic tuning parameters (spark.sql.shuffle.partitions, spark.default.parallelism, spark.executor/driver.memory, spark.sql.autoBroadcastJoinThreshold) and re-measure the performance.
3.6: Understand the difference between, and how to build, Gold layer objects such as materialized views, views, streaming tables, and tables for BI and analytics teams in Unity Catalog
Understand the difference between, and how to build, Gold layer objects such as materialized views, views, streaming tables, and tables for BI and analytics teams in Unity Catalog.
3.7: Apply data quality checks and validation rules to ensure reliable Silver and Gold datasets
Apply data quality checks and validation rules to ensure reliable Silver and Gold datasets.
4: Working with Lakeflow Jobs
4.1: Implement control flows (retries and conditional tasks such as branching and looping) using Lakeflow Jobs for pipeline orchestration
Implement control flows (retries and conditional tasks such as branching and looping) using Lakeflow Jobs for pipeline orchestration
4.2: Configure common tasks (notebook, SQL query, dashboard, and pipeline tasks) and their dependencies using Lakeflow Jobs and its DAG-based task graph
Configure common tasks (notebook, SQL query, dashboard, and pipeline tasks) and their dependencies using Lakeflow Jobs and its DAG-based task graph
4.3: Implement job schedules using Lakeflow Jobs with an understanding of trigger types (scheduled, file arrival, and table update)
Implement job schedules using Lakeflow Jobs with an understanding of trigger types (scheduled, file arrival, and table update)
4.4: Choose between time-based and data-driven triggers based on data availability and pipeline dependencies
Choose between time-based and data-driven triggers based on data availability and pipeline dependencies.
5: Implementing CI/CD
5.1: Manage your code development workflow within the Databricks workspace UI, including creating and switching between branches in Databricks Git folders (formerly Databricks Repos), committing and pushing changes, and creating pull requests using Databricks Git integration
Manage your code development workflow within the Databricks workspace UI, including creating and switching between branches in Databricks Git folders (formerly Databricks Repos), committing and pushing changes, and creating pull requests using Databricks Git integration.
5.2: Understand environment-specific configuration using Declarative Automation Bundle (formerly Databricks Asset Bundles) variables and overrides while promoting the same codebase across dev, test, and prod targets
Understand environment-specific configuration using Declarative Automation Bundle (formerly Databricks Asset Bundles) variables and overrides while promoting the same codebase across dev, test, and prod targets.
5.3: Deploy Declarative Automation Bundles (formerly Databricks Asset Bundles) to package, configure, and promote Lakeflow Jobs, Lakeflow Declarative Pipelines, and other workspace assets across dev, test, and prod environments
Deploy Declarative Automation Bundles (formerly Databricks Asset Bundles) to package, configure, and promote Lakeflow Jobs, Lakeflow Declarative Pipelines, and other workspace assets across dev, test, and prod environments.
5.4: Understand the Databricks CLI to validate, deploy, and manage Declarative Automation Bundles (formerly Databricks Asset Bundles) and other workspace assets in automated CI/CD workflows
Understand the Databricks CLI to validate, deploy, and manage Declarative Automation Bundles (formerly Databricks Asset Bundles) and other workspace assets in automated CI/CD workflows.
6: Troubleshooting, Monitoring, and Optimization
6.1: Identify trends in job performance using the Lakeflow Jobs run history view to compare current execution times against historical baselines
Identify trends in job performance using the Lakeflow Jobs run history view to compare current execution times against historical baselines.
6.2: Use the Lakeflow Jobs UI to monitor pipeline health by interpreting job statuses, viewing DAG-based task graphs to spot upstream blockers, and tracking pipeline run times and failure rates
Use the Lakeflow Jobs UI to monitor pipeline health by interpreting job statuses, viewing DAG-based task graphs to spot upstream blockers, and tracking pipeline run times and failure rates.
6.3: Identify common performance bottlenecks such as data skew, shuffling, and disk spilling by interpreting stage-level metrics in the Spark UI
Identify common performance bottlenecks such as data skew, shuffling, and disk spilling by interpreting stage-level metrics in the Spark UI.
6.4: Understand the features of Liquid Clustering and predictive optimization
Understand the features of Liquid Clustering and predictive optimization.
6.5: Diagnose cluster startup failures, library conflicts, and out-of-memory issues
Diagnose cluster startup failures, library conflicts, and out-of-memory issues.
7: Governance and Security
7.1: Differentiate between managed and external tables in Unity Catalog and perform basic operations (create, modify, delete, and convert between managed and external tables) on them
Differentiate between managed and external tables in Unity Catalog and perform basic operations (create, modify, delete, and convert between managed and external tables) on them.
7.2: Configure access controls using the UI and SQL by applying GRANT, REVOKE, and DENY privileges to principals (users, groups, and service principals) at appropriate levels of the security hierarchy
Configure access controls using the UI and SQL by applying GRANT, REVOKE, and DENY privileges to principals (users, groups, and service principals) at appropriate levels of the security hierarchy.
7.3: Understand column-level masking and row-level security to restrict data visibility based on user groups
Understand column-level masking and row-level security to restrict data visibility based on user groups.
7.4: Understand Unity Catalog ABAC policies to centrally control row-level filtering and column masking for sensitive data
Understand Unity Catalog ABAC policies to centrally control row-level filtering and column masking for sensitive data.
Techniques & products