
Answer-first summary for fast verification
Answer: OPTIMIZE
The correct keyword to use for compacting small files in a Delta table to form larger files is 'OPTIMIZE'. This command helps improve performance by merging small files into larger ones, making data access and processing more efficient.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
As a data engineer working with Delta Lake in Databricks, you may encounter a situation where the data files associated with a Delta table are exceedingly small. This can negatively affect performance due to the high overhead of handling numerous small files. To address this issue and enhance performance, you need to compact these small files into larger ones. Which keyword can be used to achieve this compaction? The options are: A. OPTIMIZE B. VACUUM C. COMPACTION D. REPARTITION.
A
OPTIMIZE
B
VACUUM
C
COMPACTION
D
REPARTITION
No comments yet.