cert-bank

Exams

DBX-DEA Databricks Data Engineer Associate

Vendor
Databricks
Level
Associate
Questions
45
Time
90 min
Domains
7
In the bank
285

Practice 285 questionsTake a timed mock examDay-by-day study plan

Guides for this exam

The exam at a glance

LevelAssociate
Questions45
Time90 minutes (about 2 minutes per question)
Passing markNot published by the vendor

Domains and weights

DomainWeightPractice questions here
D1 · Databricks Intelligence Platform6%17
D2 · Data Ingestion and Loading21%59
D3 · Data Transformation and Modeling22%63
D4 · Working with Lakeflow Jobs16%46
D5 · Implementing CI/CD10%28
D6 · Troubleshooting, Monitoring, and Optimization10%29
D7 · Governance and Security15%43

D1 · Databricks Intelligence Platform 6%

Platform questions check how a Databricks workspace is put together and what it costs to run. Scenarios cover idle clusters, scheduled ETL on shared compute, failed writes and default table formats. The deciding facts are architectural: which plane runs which service, when a Delta write becomes visible, and which compute type fits interactive versus scheduled work.

What to watch for

Tasks in the official exam guide (2)
  • 1.1 Understand the core components of the Databricks Platform (architecture, Delta Lake, Unity Catalog)
  • 1.2 Select compute services for each workload (characteristics, limitations, cost models)

D2 · Data Ingestion and Loading 21%

Ingestion items describe a source (files in cloud storage, a SaaS tool, a database) and an expectation about scale, cost, language or deployment. You choose among COPY INTO, Auto Loader modes, streaming tables and Lakeflow Connect connectors. Most wrong options would load the data, but not in the way Databricks recommends for that volume, team or support need.

What to watch for

Tasks in the official exam guide (7)
  • 2.1 Apply ingestion patterns (batch, streaming, incremental) and import from files and Lakeflow Connect
  • 2.2 Load files incrementally with COPY INTO
  • 2.3 Use Auto Loader with schema enforcement and evolution
  • 2.4 Configure Lakeflow Connect to ingest enterprise sources
  • 2.5 Land data with JDBC/ODBC or REST clients orchestrated by Lakeflow Jobs
  • 2.6 Prioritize between ingestion methods by requirements
  • 2.7 Ingest semi-structured and unstructured data

D3 · Data Transformation and Modeling 22%

Transformation questions are hands-on: a config setting that seems ignored, a join with a duplicate column, bad rows that must be kept, a dashboard that recomputes a heavy query. You choose the function, setting or table object that gives the required result. Small differences between similar options (describe and summary, a view and a materialized view) decide most items.

What to watch for

Tasks in the official exam guide (7)
  • 3.1 Clean bronze data into silver tables
  • 3.2 Combine DataFrames (joins and unions)
  • 3.3 Manipulate columns, rows and table structures
  • 3.4 Deduplicate and aggregate data
  • 3.5 Understand basic Spark tuning parameters
  • 3.6 Build gold layer objects (materialized views, views, streaming tables, tables)
  • 3.7 Apply data quality checks and validation rules

D4 · Working with Lakeflow Jobs 16%

Job questions describe when data arrives and how tasks depend on each other, then ask for the trigger, schedule or behavior that follows. Typical cases include batches of files, an external API with nothing to watch, repeated failures in a continuous job and branching task graphs. Read the timing details closely; a trigger that fires too early or too often is the usual wrong pick.

What to watch for

Tasks in the official exam guide (4)
  • 4.1 Implement control flows (retries, conditional tasks) in Lakeflow Jobs
  • 4.2 Configure tasks and dependencies in Lakeflow Jobs
  • 4.3 Implement job schedules and trigger types
  • 4.4 Choose between time-based and data-driven triggers

D5 · Implementing CI/CD 10%

CI/CD questions center on Declarative Automation Bundles, the Databricks CLI and Git folders. A pipeline or team setup is described, and you predict the outcome (which variable value wins, why extra copies appear) or choose the safe option or workflow. Precedence rules and deployment identity explain most surprises, while shared folders and direct commits to protected branches are the usual traps.

What to watch for

Tasks in the official exam guide (4)
  • 5.1 Manage the development workflow with Databricks Git folders
  • 5.2 Use bundle variables and overrides for environment-specific configuration
  • 5.3 Deploy Declarative Automation Bundles across environments
  • 5.4 Use the Databricks CLI to validate, deploy and manage bundles

D6 · Troubleshooting, Monitoring, and Optimization 10%

Troubleshooting scenarios give a symptom (a cluster that will not start, a stage far slower than the rest, a run that never raises an alert) and ask for the cause or the right source of evidence. Good answers read the specific log, metric or system table that explains it. Options that add workers or keep manual maintenance usually miss the cause.

What to watch for

Tasks in the official exam guide (5)
  • 6.1 Identify job performance trends in run history
  • 6.2 Monitor pipeline health in the Lakeflow Jobs UI
  • 6.3 Identify bottlenecks (skew, shuffle, spill) in the Spark UI
  • 6.4 Understand Liquid Clustering and predictive optimization
  • 6.5 Diagnose cluster startup failures, library conflicts and out-of-memory issues

D7 · Governance and Security 15%

Governance questions concern Unity Catalog: which table type to create, which privileges a principal needs, and how masks, row filters and tags behave. Stems are often precise, with a GRANT statement or a function call in each option. The right one gives exactly the access required and relies on account-level identity, while broad grants and workspace-local checks are the common traps.

What to watch for

Tasks in the official exam guide (4)
  • 7.1 Differentiate managed and external tables in Unity Catalog
  • 7.2 Configure access controls with GRANT, REVOKE and DENY
  • 7.3 Understand column masking and row-level security
  • 7.4 Understand Unity Catalog ABAC policies

A study order that works

The 20-day study plan for DBX-DEA takes the domains in this order. Each day has a short reading, key terms and a quiz from the bank.

  1. Day 1: D1 · Databricks Intelligence Platform
  2. Days 2–5: D2 · Data Ingestion and Loading
  3. Days 6–9: D3 · Data Transformation and Modeling
  4. Days 10–11: D4 · Working with Lakeflow Jobs
  5. Days 12–13: D5 · Implementing CI/CD
  6. Days 14–16: D6 · Troubleshooting, Monitoring, and Optimization
  7. Days 17–19: D7 · Governance and Security
  8. Day 20: Final Review: Exam Format, Weights and Commonly Confused Pairs

Recent changes to these questions

About these questions

Every question is original, written from the public exam guide and checked against the vendor's own documentation. None comes from a real exam. Each one has an explanation of why the answer is right and why the other options are wrong. How the questions are written.