Microsoft Certified Azure Data Engineer Associate · Free Practice Question Easy
Question 41
What size does OPTIMIZE compact small files to?
-
A
Around 1 GB
-
B
Around 2 GB
-
C
Around 100 MB
-
D
Around 500 MB
Reveal correct answer
Correct answer: A
Explanation
The OPTIMIZE command compacts small files to around 1GB. The Spark optimization team determined this value to be a good compromise between speed and performance.
A. OPTIMIZE compacts small files to around 1 GB in size. This process helps in optimizing storage and improving performance by reducing the number of small files in the system.
B. Compacting small files to around 2 GB is not the typical size that OPTIMIZE aims for. The optimal size for compacted files is usually smaller to ensure efficient storage and performance improvements.
C. Compacting small files to around 100 MB is not the size that OPTIMIZE typically aims for. The optimal size for compacted files is usually larger to improve storage efficiency and performance.
D. OPTIMIZE usually aims to compact small files to around 1 GB in size, rather than around 500 MB. This larger size helps in reducing the overall number of files and improving storage efficiency.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
