The data engineering team has a Delta table called `employees` that contains the employees' personal information, including their gross salaries. Which of the following code blocks will ensure the table only retains employees with a salary greater than 3000?

Real Exam

SELECT CASE WHEN salary <= 3000 THEN DELETE ELSE UPDATE END FROM employees;

5.8%

DELETE FROM employees WHERE salary <= 3000;

72.9%

UPDATE employees WHERE salary > 3000 WHEN MATCHED SELECT;

5.3%

DELETE FROM employees WHERE salary > 3000;

11.1%

UPDATE employees WHERE salary <= 3000 WHEN MATCHED DELETE;

4.8%

Databricks Certified Data Engineer - Associate