
Ultimate access to all questions.
You are tasked with optimizing a Delta table for the Databricks SQL service that contains data from a logistics company. The table includes columns like shipment_id, driver_id, delivery_date, and status. Explain how you would use Delta Lake features such as OPTIMIZE, VACUUM, and the configuration of auto-compaction to ensure the table is optimized for both read and write operations._
A
Run OPTIMIZE command with z-ordering on shipment_id, set auto-compaction to true, and use VACUUM with a retention interval of 7 days._
B
Run OPTIMIZE command with z-ordering on driver_id, disable auto-compaction, and use VACUUM with a retention interval of 1 day._
C
Run OPTIMIZE command with z-ordering on delivery_date, set auto-compaction to true, and use VACUUM with a retention interval of 30 days._
D
Run OPTIMIZE command with z-ordering on status, disable auto-compaction, and do not use VACUUM.