Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
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
0
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...