Answer-first summary for fast verification
Answer: The deleted data files were older than the default retention threshold, while the remaining files are newer and cannot be deleted.
The VACUUM command on a Delta table removes unused data files that are older than a specified retention period. Files newer than this threshold remain untouched. This behavior is documented in the Databricks SQL manual at [https://docs.databricks.com/sql/language-manual/delta-vacuum.html](https://docs.databricks.com/sql/language-manual/delta-vacuum.html).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A data engineer observed that some unused data files in a Delta table's directory were not deleted after executing the VACUUM command, despite others being removed. What could be the reason for this partial deletion?
A
The deleted data files were larger than the default size threshold, while the remaining files are smaller and cannot be deleted.
B
The deleted data files were newer than the default retention threshold, while the remaining files are older and cannot be deleted.
C
The deleted data files were older than the default retention threshold, while the remaining files are newer and cannot be deleted.
D
The deleted data files were smaller than the default size threshold, while the remaining files are larger and cannot be deleted.
E
More information is needed to determine the correct answer.
No comments yet.