Databricks Certified Data Engineer - Associate

Get started today

Ultimate access to all questions.

Explanation:

C is correct. Use DELETE FROM to delete existing records from the table. UPDATE is used to modify existing records. SELECT only creates a view, it does not alter the table records.

Detailed Explanation:

DELETE FROM my_table WHERE age > 25; - This is the correct SQL statement to remove rows from a Delta table where the age column value is greater than 25. The DELETE statement permanently removes records that match the WHERE condition.
UPDATE statements (options B and D) are used to modify existing column values, not to remove entire rows.
SELECT statement (option A) only queries data and creates a result set or view, but doesn't modify the underlying table.
DELETE FROM my_table WHERE age <= 25; (option E) would remove rows where age is 25 or less, which is the opposite of what's requested.

Explanation:

C is correct. Use DELETE FROM to delete existing records from the table. UPDATE is used to modify existing records. SELECT only creates a view, it does not alter the table records.

Detailed Explanation:

DELETE FROM my_table WHERE age > 25; - This is the correct SQL statement to remove rows from a Delta table where the age column value is greater than 25. The DELETE statement permanently removes records that match the WHERE condition.
UPDATE statements (options B and D) are used to modify existing column values, not to remove entire rows.
SELECT statement (option A) only queries data and creates a result set or view, but doesn't modify the underlying table.
DELETE FROM my_table WHERE age <= 25; (option E) would remove rows where age is 25 or less, which is the opposite of what's requested.

Comments (0)

No comments yet.

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?

Real Exam

Community

KKeng

Last updated: January 13, 2026 at 09:15

SELECT * FROM my_table WHERE age > 25;

2.2%

UPDATE my_table WHERE age > 25;

3.3%

DELETE FROM my_table WHERE age > 25;

87.8%

UPDATE my_table WHERE age <= 25;

1.1%

DELETE FROM my_table WHERE age <= 25;

5.6%