Answer-first summary for fast verification
Answer: Run OPTIMIZE command with z-ordering, set auto-compaction to true, and use VACUUM with a retention interval of 7 days.
Using the OPTIMIZE command with z-ordering helps in clustering data more efficiently, which is beneficial for read operations. Enabling auto-compaction ensures that small files are periodically merged, improving write performance. Using VACUUM with a reasonable retention interval (7 days) helps in cleaning up unused files without risking data loss.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
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.
A
Run OPTIMIZE command with z-ordering, set auto-compaction to true, and use VACUUM with a retention interval of 7 days.
B
Run OPTIMIZE command without z-ordering, disable auto-compaction, and use VACUUM with a retention interval of 1 day.
C
Run OPTIMIZE command with z-ordering, disable auto-compaction, and do not use VACUUM.
D
Run OPTIMIZE command without z-ordering, set auto-compaction to true, and use VACUUM with a retention interval of 30 days.