Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
A data engineer identified an error during a routine daily update to a Delta table. To correct this, they intend to use Delta Lake's time travel feature to revert the table to its state from three days ago. Unfortunately, the data engineer encounters an issue: the time travel attempt fails because the data files necessary for the restoration have been deleted. Which of the following explains why the data files are no longer available?
Exam-Like
A
The VACUUM command was run on the table
B
The TIME TRAVEL command was run on the table
C
The DELETE HISTORY command was run on the table
D
The OPTIMIZE command was run on the table
E
The HISTORY command was run on the table
Explanation:
The VACUUM command in Delta Lake is used to remove unnecessary data files that are no longer needed for time travel or query purposes. When you run VACUUM with certain retention settings, it can delete older data files, which might include versions of data that are older than the specified retention period. Since the data engineer is unable to restore the table to a version that is 3 days old because the data files have been deleted, it is likely that the VACUUM command was run on the table, removing the older data files.
Comments
Loading comments...