Q: 3
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?
Options
Discussion
Seen this style in other practice sets, it's C for Delta tables.
C
Kinda think B makes sense too since UPDATE could set a status or flag to mark those rows, basically a soft delete. Unless the question strictly wants physical removal, I'd expect UPDATE works in some orgs. Someone else interpret it differently?
C , Delta supports DELETE for this case. SELECT and UPDATE won't actually remove any rows, only DELETE does the job when you want to drop records matching a condition. Unless I'm missing something subtle?
Be respectful. No spam.
