Answer-first summary for fast verification
Answer: VACUUM
Executing the `VACUUM` command on a Delta table removes unused data files that are older than a specified retention period. This action prevents the ability to time travel back to versions older than the retention threshold. For more details, refer to [Databricks documentation](https://docs.databricks.com/sql/language-manual/delta-vacuum.html).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A data engineer attempts to use Delta time travel to revert a table to a previous version but encounters an error indicating the data files are missing. Which command, when executed on the table, would result in the deletion of these data files?
A
OPTIMIZE
B
DEEP CLONE
C
VACUUM
D
ZORDER BY
E
DELETE
No comments yet.