A data engineer has realized that the data files associated with a Delta table are incredibly small. They want to compact the small files to form larger files to improve performance.
Which of the following keywords can be used to compact the small files?
The correct keyword to compact small files in a Delta table is OPTIMIZE. By using the OPTIMIZE command, you can combine smaller data files into larger ones, which improves query performance and efficiency in accessing the Delta table.
OPTIMIZE can be used to club small files into 1 and improve performance.
Ans B : optimize is used to compact small files which in turn improves perf
OPTIMIZE is the correct answer. Compacting small files using the OPTIMIZE command improves table performance such as by combining multiple small files into larger ones.
OPTIMIZE would help in this scenario
Its B https://docs.databricks.com/en/delta/optimize.html
B is correct