Explanation:
The VACUUM command syntax is: VACUUM table_name [RETAIN number_of_hours HOURS] [DRY RUN], where the retention period and DRY RUN are optional. The default retention period is 7 days (168 hours).
VACUUM hotel_bookings RETAIN 168 HOURS permanently deletes files deleted more than 168 hours ago.VACUUM hotel_bookings RETAIN 7 HOURS DRY RUN lists files deleted more than 7 hours ago (no effect on files).VACUUM hotel_bookings RETAIN 7 HOURS permanently deletes files deleted more than 7 hours ago.VACUUM hotel_bookings RETAIN 168 HOURS DRY RUN lists files deleted more than 168 hours ago (no effect on files).VACUUM hotel_bookings RETAIN 0 HOURS DRY RUN lists files not part of the current table version (no effect on files).VACUUM hotel_bookings defaults to 168 hours, same as Command 1.Thus, Commands 1 and 6 have the same effect, while Commands 2, 4, and 5 do not affect the data files.
Ultimate access to all questions.
No comments yet.
The compliance team is reviewing various VACUUM commands applied to the hotel_bookings Delta table. Which commands will have the same effect on the data files, and which will not alter the number of data files? Assume default settings are unchanged.
Command 1: VACUUM hotel_bookings RETAIN 168 HOURS
Command 2: VACUUM hotel_bookings RETAIN 7 HOURS DRY RUN
Command 3: VACUUM hotel_bookings RETAIN 7 HOURS
Command 4: VACUUM hotel_bookings RETAIN 168 HOURS DRY RUN
Command 5: VACUUM hotel_bookings RETAIN 0 HOURS DRY RUN
Command 6: VACUUM hotel_bookings
Command 1: VACUUM hotel_bookings RETAIN 168 HOURS
Command 2: VACUUM hotel_bookings RETAIN 7 HOURS DRY RUN
Command 3: VACUUM hotel_bookings RETAIN 7 HOURS
Command 4: VACUUM hotel_bookings RETAIN 168 HOURS DRY RUN
Command 5: VACUUM hotel_bookings RETAIN 0 HOURS DRY RUN
Command 6: VACUUM hotel_bookings
A
Commands 3 and 6 will have the same effect whereas Commands 2, 4 and 5 will have no effect on data files.
B
Commands 1 and 6 will have the same effect whereas Commands 2 and 4 will have no effect on data files.
C
Commands 1, 3 and 6 will have the same effect whereas Commands 2 and 5 will have no effect on data files.
D
Commands 1 and 6 will have the same effect whereas Commands 2, 4 and 5 will have no effect on data files.
E
Commands 3 and 6 will have the same effect whereas Commands 2 and 4 will have no effect on data files.