Explanation:
The correct answer is OPTIMIZE table_name. This command consolidates small parquet files into larger ones, improving performance. The file size is automatically adjusted based on the table's size, though manual adjustments are possible for specific workloads. For more details, refer to Databricks documentation on file management.
Ultimate access to all questions.
You're troubleshooting a performance issue and discover a table has an excessive number of small files. Which command would you use to resolve this issue?
A
COMPACT table_name
B
VACUUM table_name
C
MERGE table_name
D
SHRINK table_name
E
OPTIMIZE table_name
No comments yet.