# Certified-Data-Engineer-Associate — Question 427

**Type:** multiple_choice
**Topics:** topic_1

## Question

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?

## Correct Answer

_See scenario._

## Explanation

The OPTIMIZE command is used to compact small files into larger ones, which helps improve the performance of Delta Lake tables. It consolidates small files into fewer larger files to reduce the overhead associated with having many small files. This process is often referred to as "compaction" but the specific keyword in Databricks Delta Lake is OPTIMIZE.

**Reference:** examtopics_top_comment

---
Source: https://hiexam.net/q/databricks/Certified-Data-Engineer-Associate/427  
Practice (tracked): https://hiexam.net/study/Certified-Data-Engineer-Associate/practice