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

Databricks Certified Data Engineer Associate Exam
Certified Data Engineer Associate (Page 3 )

Updated On: 19-Jan-2026
Page 3 of 36
PDF with 198 Questions

Which of the following describes the storage organization of a Delta table?

  1. Delta tables are stored in a single file that contains data, history, metadata, and other attributes.
  2. Delta tables store their data in a single file and all metadata in a collection of files in a separate location.
  3. Delta tables are stored in a collection of files that contain data, history, metadata, and other attributes.
  4. Delta tables are stored in a collection of files that contain only the data stored within the table.
  5. Delta tables are stored in a single file that contains only the data stored within the table.

Answer(s): C



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



Viewing page 3 of 36
Viewing questions 9 - 12 out of 198 questions



Post your Comments and Discuss Databricks Certified Data Engineer Associate exam prep with other Community members:

Join the Certified Data Engineer Associate Discussion