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?
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.