Explanation:
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.
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.