Ultimate access to all questions.
A data engineering team is optimizing performance and notices a query on the orders
Delta table, which contains a large amount of data, is running too slowly due to many small files. They aim to trigger compaction for the year 2022 data only using the OPTIMIZE
command. Which command should they use?