Ultimate access to all questions.
You are tasked with optimizing a Delta table for the Databricks SQL service. Describe the steps you would take to ensure the table is optimized for both read and write operations. Consider the use of Delta Lake features such as OPTIMIZE, VACUUM, and the configuration of auto-compaction.