Databricks Certified Data Engineer - Professional
Comments
Loading comments...
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
```_
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.