Explanation:

The correct answer is C because:

DELETE statement: The DELETE statement is used to remove rows from a table based on a condition.
Condition: The requirement is to remove rows where age > 25, so the WHERE clause should be WHERE age > 25.
Other options analysis:
- A: SELECT statement only retrieves data, doesn't modify the table.
- B: UPDATE statement modifies existing rows, doesn't delete them.
- D: UPDATE statement with wrong condition (would update rows where age <= 25).
- E: DELETE statement with wrong condition (would delete rows where age <= 25, opposite of what's needed).

In Delta Lake, DELETE operations are fully supported and provide ACID transactions, making option C the correct choice for removing rows where age > 25.

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

SELECT * FROM my_table WHERE age > 25;

5.4%

UPDATE my_table WHERE age > 25;

6.8%

DELETE FROM my_table WHERE age > 25;

70.3%

UPDATE my_table WHERE age <= 25;

13.5%

DELETE FROM my_table WHERE age <= 25;

4.1%

Databricks Certified Data Engineer - Associate

Get started today

Get started today

Comments (0)

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?

Comments (0)