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?
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?
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.
C is the correct answer
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 es correcto
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.
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
option c
C - is correct answer
C is correct
C. DELETE FROM my_table WHERE age > 25;
C is correct
C is correct
Answer is C
C. DELETE FROM my_table WHERE age > 25;
C is correct
there is not delete history option just the vacuum with its parameters of time retention.
The answer is C!