Master key concepts with interactive flashcards
How do you handle duplicate records in Delta Lake?
Click to reveal answer
Multiple approaches: 1) **INSERT with NOT EXISTS**: `INSERT INTO target SELECT * FROM source WHERE NOT EXISTS (SELECT 1 FROM target WHERE ...)` 2) **MERGE with WHEN NOT MATCHED**: Only inserts new records 3) **Window functions**: `ROW_NUMBER() OVER (PARTITION BY key ORDER BY timestamp DESC) = 1` 4) **dropDuplicates()** in PySpark
Click to show question
Databricks Data Engineer Associate is a Databricks certification. These facts come from the current exam guide and are the numbers to plan around.
| Domain | Weight | What to focus on |
|---|---|---|
| ELT with Spark SQL and Python | 29% | Extracting data from external sources, Loading data into Delta Lake tables, Using Spark SQL for data transformation |
| Databricks Lakehouse Platform | 24% | Data lakehouse concepts and architecture, Databricks workspace and notebooks, Databricks clusters and compute resources |
| Incremental Data Processing | 22% | Delta Live Tables pipelines, Structured Streaming fundamentals, Auto Loader for incremental file ingestion |
| Production Pipelines | 16% |
| Databricks Jobs for pipeline orchestration, Task dependencies and scheduling, Multi-task workflows |
| Data Governance | 9% | Unity Catalog security model, Table and column-level access control, Dynamic view functions for row/column filtering |
Yes. You can start Databricks-DE-Associate practice and flashcards free without creating an account. A free account keeps your progress, and the full bank (300+ questions) unlocks with a subscription.
They cover all 5 domains of the Databricks-DE-Associate exam: ELT with Spark SQL and Python (29%), Databricks Lakehouse Platform (24%), Incremental Data Processing (22%), Production Pipelines (16%), Data Governance (9%). Each section is weighted in the same proportion as the real exam, so nothing high-value is buried.
The Databricks-DE-Associate exam has approximately 60 questions in 90 minutes, with a passing score of 70%. Use the practice questions to confirm you are consistently above that line before booking the real exam.
Study in short, spaced sessions: a card you have not seen for two days is worth more than a card you reread immediately. Filter by ELT with Spark SQL and Python first, then mix domains so you practise identifying the topic before recalling the definition.
They are the recall half of preparation. Pair the cards with practice questions and at least one timed practice exam — candidates who only review cards usually recognise terms but miss scenario questions.