Exam Certified Data Engineer Associate All QuestionsBrowse all questions from this exam
Go to Exam
Question 6

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?

    Correct Answer: C

    To remove rows from an existing Delta table where the value in a specific column meets a condition, you need to use the DELETE statement. In this case, using 'DELETE FROM my_table WHERE age > 25;' will delete all rows where the age is greater than 25, thereby updating the table with only the rows where the age value is 25 or less.

Discussion
bettermakemeOption: C

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/

XiltroXOption: C

C is the correct answer

DavidRouOption: C

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

prasiosoOption: C

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.

kniveszOption: C

C es correcto

mascarenhaslucasOption: C

The answer is C!

SvenganceOption: A

there is not delete history option just the vacuum with its parameters of time retention.

ItmmaOption: C

C is correct

SerGreyOption: C

C. DELETE FROM my_table WHERE age > 25;

VijayKulaOption: C

Answer is C

KalavathiPOption: C

C is correct

ArindamNathOption: C

C is correct

vctrhugoOption: C

C. DELETE FROM my_table WHERE age > 25;

nb1000Option: C

C is correct

Varma_SaraswathulaOption: C

C - is correct answer

surrabhi_4Option: C

option c