
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?