DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE · Question #62
A data engineer has realized that they made a mistake when making a daily update to a table. They need to use Delta time travel to restore the table to a version that is 3 days old. However, when…
The correct answer is A. The VACUUM command was run on the table. The VACUUM command in Delta Lake is used to clean up and 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…
Question
Options
- AThe VACUUM command was run on the table
- BThe TIME TRAVEL command was run on the table
- CThe DELETE HISTORY command was run on the table
- DThe OPTIMIZE command was nun on the table
- EThe HISTORY command was run on the table
How the community answered
(23 responses)- A91% (21)
- B4% (1)
- E4% (1)
Explanation
The VACUUM command in Delta Lake is used to clean up and 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. If 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's likely because the VACUUM command was run on the table, removing the older data files as part of data cleanup.
Topics
Community Discussion
No community discussion yet for this question.