Answer-first summary for fast verification
Answer: UPDATE products SET price = price * 0.5 WHERE price > 1000;
The correct answer uses the `UPDATE` statement to modify existing records in the `products` table where the price is strictly greater than 1000. The syntax for updating records in a Delta table is straightforward: `UPDATE table_name SET column_name = expr WHERE condition`. This approach directly applies the 50% discount to the qualifying products. For more details, refer to the [Databricks documentation on Delta UPDATE](https://docs.databricks.com/sql/language-manual/delta-update.html).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
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?
A
SELECT price * 0.5 AS new_price FROM products WHERE price > 1000;
B
MERGE INTO products WHERE price > 1000 WHEN MATCHED UPDATE price = price * 0.5;
C
UPDATE products SET price = price * 0.5 WHERE price > 1000;
D
MERGE INTO products WHERE price < 1000 WHEN MATCHED UPDATE price = price * 0.5;
E
UPDATE products SET price = price * 0.5 WHERE price >= 1000;
No comments yet.