Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
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
A
SELECT * FROM my_table WHERE age > 25;
B
UPDATE my_table WHERE age > 25;
C
DELETE FROM my_table WHERE age > 25;
D
UPDATE my_table WHERE age <= 25;
E
DELETE FROM my_table WHERE age <= 25;
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
Loading comments...