Answer-first summary for fast verification
Answer: VACUUM sales RETAIN 168 HOURS
The correct answer is 'VACUUM sales RETAIN 168 HOURS' because the retention value for the VACUUM command is specified in hours. This ensures that only the versions of the 'sales' table that are not older than 7 days (168 hours) are retained, aligning with the task's requirements. For more details, refer to the documentation on vacuuming a Delta table.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
As a data engineer, you're tasked with maintaining only the recent versions of the 'sales' Delta table, specifically those not older than the last 7 days. You've noticed the directory for this table contains numerous data files from historical versions. Which query should you execute to remove files from the 'sales' table that are older than one week?
A
VACUUM sales RETAIN 7 DAYS
B
VACUUM sales RETAIN 604800 SECONDS
C
VACUUM sales RETAIN 168 HOURS
D
VACUUM sales RETAIN 10080 MINUTES
E
VACUUM sales RETAIN 1 WEEK
No comments yet.