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.
80370eb
3 months, 2 weeks agomascarenhaslucas
5 months, 2 weeks agoSvengance
7 months, 1 week agobettermakeme
8 months agoItmma
8 months, 1 week agoSerGrey
11 months, 1 week agoVijayKula
1 year, 1 month agoDavidRou
1 year, 1 month agoKalavathiP
1 year, 2 months agoArindamNath
1 year, 2 months agovctrhugo
1 year, 2 months agonb1000
1 year, 4 months agoprasioso
1 year, 6 months agoVarma_Saraswathula
1 year, 7 months agoknivesz
1 year, 7 months agosurrabhi_4
1 year, 7 months agoXiltroX
1 year, 7 months ago