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?
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;
Answer: C
Latest Databricks Certified Data Engineer Associate Practice Questions with 87 Q&As
Updated Study Material | Instant Download | Detailed Answers and Explanations
Subscribe
Login
0 Comments