Ultimate access to all questions.
You are tasked with optimizing a Delta table for the Databricks SQL service that contains data from a retail store. The table includes columns like transaction_id, product_id, customer_id, and timestamp. 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.