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?
Answer is C. Just finished exam-got 100% [Databricks Associate Exam Practice Exams] All questions came from
Databricks Certified Data Engineer Associate
https://www.udemy.com/share/10aEFa3@9M_uT6vrKbnl68tOK96kfy-YWitjwzLTlVCrzPs-0hGUu8fyX8V4Tn_x_y65bwLm/
C is the correct answer as the SELECT statement allows to query a table, the UPDATE statement allows to modify values in columns. If you want to remove rows that don't match a specific condition you must use DELETE
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.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
sunil01
2 months, 2 weeks agodevbila
2 months, 3 weeks ago80370eb
10 months, 2 weeks agomascarenhaslucas
1 year agoSvengance
1 year, 2 months agobettermakeme
1 year, 2 months agoItmma
1 year, 3 months agoSerGrey
1 year, 5 months agoVijayKula
1 year, 8 months agoDavidRou
1 year, 8 months agoKalavathiP
1 year, 8 months agoArindamNath
1 year, 9 months agovctrhugo
1 year, 9 months agonb1000
1 year, 11 months agoprasioso
2 years, 1 month agoVarma_Saraswathula
2 years, 2 months agoknivesz
2 years, 2 months ago