Ultimate access to all questions.
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