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?

Real Exam

OPTIMIZE TABLE orders WHEN order_date >= ‘2022-01-01‘_

9.9%

OPTIMIZE orders WHERE order_date >= ‘2022-01-01‘_

43.2%

OPTIMIZE TABLE orders WHERE order_date >= ‘2022-01-01‘_

27.0%

OPTIMIZE orders FILTER BY order_date >= ‘2022-01-01‘_

7.7%

OPTIMIZE TABLE orders USING order_date >= ‘2022-01-01‘_

12.2%

Databricks Certified Data Engineer - Associate