
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