Databricks Certified Data Engineer Associate — Question 60

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 keyword can be used to compact the small files?

Answer options

• A. OPTIMIZE
• B. VACUUM
• C. COMPACTION
• D. REPARTITION

Correct answer: A

Explanation

The correct answer is OPTIMIZE, as this command is specifically designed to compact small files in a Delta table into larger ones, which enhances query performance. VACUUM is used for removing old data files, COMPACTION is not a command in this context, and REPARTITION changes the number of partitions but does not directly compact files.