Which of the following code blocks will remove the rows where the value in column age is greater than 25 from the existing Delta table my_table and save the updated table?

Question

Options

• ASELECT * FROM my_table WHERE age > 25;
• BUPDATE my_table WHERE age > 25;
• CDELETE FROM my_table WHERE age > 25;
• DUPDATE my_table WHERE age <= 25;
• EDELETE FROM my_table WHERE age <= 25;

• B
  5% (2)
• C
  93% (41)
• D
  2% (1)

Explanation

DELETE FROM my_table WHERE age > 25; removes all rows from the Delta table where the age column value exceeds 25, and Delta Lake automatically persists this change (it is transactional). Option A is a SELECT - it only reads data and does not modify the table. Options B and D use UPDATE syntax, which changes column values rather than removing rows. Option E uses DELETE with the wrong condition (age <= 25), which would remove rows where age is 25 or less - the opposite of the requirement.

No community discussion yet for this question.