The data engineering team is working with a Delta table named `products` that includes product details, such as the net price. Which of the following code blocks correctly applies a 50% discount to all products priced above 1000 and updates the table with the new prices?

Real Exam

SELECT price * 0.5 AS new_price FROM products WHERE price > 1000;*_

5.1%

MERGE INTO products WHERE price > 1000 WHEN MATCHED UPDATE price = price * 0.5;*

9.7%

UPDATE products SET price = price * 0.5 WHERE price > 1000;*

73.3%

MERGE INTO products WHERE price < 1000 WHEN MATCHED UPDATE price = price * 0.5;*

4.6%

UPDATE products SET price = price * 0.5 WHERE price >= 1000;*

7.2%

Databricks Certified Data Engineer - Associate