Home / DE Associate practice test / Databricks Intelligence Platform / Question

Databricks Data Engineer Associate · free practice question

A regulatory audit requires the team to reproduce exactly what a Delta table looked like at a specific timestamp two weeks ago, and to roll the table back if a…

Exam-style question on Databricks Intelligence Platform from the free DE Associate practice test, with the answer and a full explanation below.

Updated November 10, 2026

Databricks Intelligence Platform

A regulatory audit requires the team to reproduce exactly what a Delta table looked like at a specific timestamp two weeks ago, and to roll the table back if a bad write is discovered. Which Delta Lake capability provides this?

  1. AAuto Loader, which retains the historical versions of the files it has ingested, letting an earlier table state be replayed from the raw source data and restored on demand for the audit.
  2. BTime travel, which queries or restores an earlier table version by timestamp or version number from the history recorded in the Delta transaction log, for audit reproduction and rollback.
  3. CPhoton, the vectorized query engine, which keeps prior table states cached in memory, letting a bad write be rolled back to an earlier table version at the moment it is discovered.
  4. DPartition pruning, which reconstructs a past table state from partition-boundary metadata and file statistics, letting you reproduce the table and roll it back to an earlier point in time.
  5. EExternal backups, which are needed here as Delta Lake keeps the current table state alone; reproducing a two-week-old state or undoing a bad write means restoring a copy captured at that time.
Answer & explanation

Correct answer: B

WHY B: Delta Lake time travel uses the transaction log to query (VERSION AS OF / TIMESTAMP AS OF) or RESTORE a table to a prior state, which is exactly what audit reproduction and rollback need.

WHY NOT A: Auto Loader ingests files incrementally; it is not a table-versioning feature and does not keep or replay earlier table states.

WHY NOT C: Photon is a query engine, not a versioning or rollback mechanism, and it does not cache prior table states.

WHY NOT D: Partition pruning is a read optimization that skips irrelevant files; it is unrelated to historical versions.

WHY NOT E: Delta retains version history, subject to the retention settings, so external backups are not required to reach recent versions.

Take the full DE Associate practice test free →

Would you pass today?

This question is one of 45 in the free, timed Databricks Data Engineer Associate practice test. Take it and get a section-by-section score.

Start the free test →