Amazon
Avaya
Cisco
CompTIA
CrowdStrike
EC-Council
EXIN
Fortinet
Google
ISC
ISC2
ITIL
Juniper
Microsoft
NVIDIA
Okta
Palo Alto Networks
Salesforce
SAP
ServiceNow
All Vendors
  1. Home
  2. Databricks
  3. Certified Data Engineer Associate

Databricks Certified Data Engineer Associate Exam (page: 2)
Databricks Certified Data Engineer Associate
Updated on: 21-Feb-2026

Viewing Page 2 of 29
Certified Data Engineer Associate PDF 198 Questions

Which of the following code blocks will remove the rows where the value in column age is greater than 25 from the existing Delta table my_table and save the updated table?

  1. SELECT * FROM my_table WHERE age > 25;
  2. UPDATE my_table WHERE age > 25;
  3. DELETE FROM my_table WHERE age > 25;
  4. UPDATE my_table WHERE age <= 25;
  5. DELETE FROM my_table WHERE age <= 25;

Answer(s): C



A data engineer has realized that they made a mistake when making a daily update to a table. They need to use Delta time travel to restore the table to a version that is 3 days old. However, when the data engineer attempts to time travel to the older version, they are unable to restore the data because the data files have been deleted.

Which of the following explains why the data files are no longer present?

  1. The VACUUM command was run on the table
  2. The TIME TRAVEL command was run on the table
  3. The DELETE HISTORY command was run on the table
  4. The OPTIMIZE command was nun on the table
  5. The HISTORY command was run on the table

Answer(s): A

Explanation:

The most likely reason why the data files are no longer present when the data engineer attempts to time travel to an older version of a Delta table is that the VACUUM command was run on the table. The VACUUM command removes files that are no longer in use by the Delta table, including files that are required for time travel. Therefore, if the VACUUM command is run on a Delta table, it can make it impossible to use time travel to recover older versions of the table.



Which of the following Git operations must be performed outside of Databricks Repos?

  1. Commit
  2. Pull
  3. Push
  4. Clone
  5. Merge

Answer(s): E

Explanation:

For following tasks, work in your Git provider:

Create a pull request.
Resolve merge conflicts.
Merge or delete branches.
Rebase a branch.


Reference:

https://docs.databricks.com/repos/index.html



Which of the following data lakehouse features results in improved data quality over a traditional data lake?

  1. A data lakehouse provides storage solutions for structured and unstructured data.
  2. A data lakehouse supports ACID-compliant transactions.
  3. A data lakehouse allows the use of SQL queries to examine data.
  4. A data lakehouse stores data in open formats.
  5. A data lakehouse enables machine learning and artificial Intelligence workloads.

Answer(s): B

Explanation:

ACID-compliant transactions ensure that data is consistent, reliable, and accurate. By supporting ACID transactions, a data lakehouse can provide improved data quality over a traditional data lake. This is because ACID transactions guarantee that updates to the data are either completed in their entirety or not at all, reducing the risk of data corruption or errors.



A data engineer needs to determine whether to use the built-in Databricks Notebooks versioning or version their project using Databricks Repos.

Which of the following is an advantage of using Databricks Repos over the Databricks Notebooks versioning?

  1. Databricks Repos automatically saves development progress
  2. Databricks Repos supports the use of multiple branches
  3. Databricks Repos allows users to revert to previous versions of a notebook
  4. Databricks Repos provides the ability to comment on specific changes
  5. Databricks Repos is wholly housed within the Databricks Lakehouse Platform

Answer(s): B



Viewing Page 2 of 29



Share your comments for Databricks Certified Data Engineer Associate exam with other users:

Vetri 10/3/2023 12:59:00 AM

great content and wonderful to have the answers with explanation
UNITED STATES


Ranjith 8/21/2023 3:39:00 PM

for question #118, the answer is option c. the screen shot is showing the drop down, but the answer is marked incorrectly please update . thanks for sharing such nice questions.
Anonymous


Eduardo Ramírez 12/11/2023 9:55:00 PM

the correct answer for the question 29 is d.
Anonymous


Dass 11/2/2023 7:43:00 AM

question no 22: correct answers: bc, 1 per session 1 per page 1 per component always
UNITED STATES


Reddy 12/14/2023 2:42:00 AM

these are pretty useful
Anonymous


Daisy Delgado 1/9/2023 1:05:00 PM

awesome
UNITED STATES


Atif 6/13/2023 4:09:00 AM

yes please upload
UNITED STATES


Xunil 6/12/2023 3:04:00 PM

great job whoever put this together, for the greater good! thanks!
Anonymous


Lakshmi 10/2/2023 5:26:00 AM

just started to view all questions for the exam
NETHERLANDS


rani 1/19/2024 11:52:00 AM

helpful material
Anonymous


Greg 11/16/2023 6:59:00 AM

hope for the best
UNITED STATES


hi 10/5/2023 4:00:00 AM

will post exam has finished
UNITED STATES


Vmotu 8/24/2023 11:14:00 AM

really correct and good analyze!
AZERBAIJAN


hicham 5/30/2023 8:57:00 AM

excellent thanks a lot
FRANCE


Suman C 7/7/2023 8:13:00 AM

will post once pass the cka exam
INDIA


Ram 11/3/2023 5:10:00 AM

good content
Anonymous


Nagendra Pedipina 7/13/2023 2:12:00 AM

q:32 answer has to be option c
INDIA


Tamer Barakat 12/7/2023 5:17:00 PM

nice questions
Anonymous


Daryl 8/1/2022 11:33:00 PM

i really like the support team in this website. they are fast in communication and very helpful.
UNITED KINGDOM


Curtis Nakawaki 6/29/2023 9:13:00 PM

a good contemporary exam review
UNITED STATES


x-men 5/23/2023 1:02:00 AM

q23, its an array, isnt it? starts with [ and end with ]. its an array of objects, not object.
UNITED STATES


abuti 7/21/2023 6:24:00 PM

cool very helpfull
Anonymous


Krishneel 3/17/2023 10:34:00 AM

i just passed. this exam dumps is the same one from prepaway and examcollection. it has all the real test questions.
INDIA


Regor 12/4/2023 2:01:00 PM

is this a valid prince2 practitioner dumps?
UNITED KINGDOM


asl 9/14/2023 3:59:00 PM

all are relatable questions
CANADA


Siyya 1/19/2024 8:30:00 PM

might help me to prepare for the exam
Anonymous


Ted 6/21/2023 11:11:00 PM

just paid and downlaod the 2 exams using the 50% sale discount. so far i was able to download the pdf and the test engine. all looks good.
GERMANY


Paul K 11/27/2023 2:28:00 AM

i think it should be a,c. option d goes against the principle of building anything custom unless there are no work arounds available
INDIA


ph 6/16/2023 12:41:00 AM

very legible
Anonymous


sephs2001 7/31/2023 10:42:00 PM

is this exam accurate or helpful?
Anonymous


ash 7/11/2023 3:00:00 AM

please upload dump, i have exam in 2 days
INDIA


Sneha 8/17/2023 6:29:00 PM

this is useful
CANADA


sachin 12/27/2023 2:45:00 PM

question 232 answer should be perimeter not netowrk layer. wrong answer selected
Anonymous


tomAws 7/18/2023 5:05:00 AM

nice questions
BRAZIL