Answer-first summary for fast verification
Answer: UPDATE transactions SET active_flag = 'N' WHERE active_flag = 'Y'
The correct answer is **UPDATE transactions SET active_flag = 'N' WHERE active_flag = 'Y'**. Delta Lake supports UPDATE statements on the delta table, ensuring all changes are ACID compliant.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Which SQL statement correctly updates a transactions table to change a flag from 'Y' to 'N'?
A
MERGE transactions SET active_flag = 'N' WHERE active_flag = 'Y'
B
UPDATE transactions SET active_flag = 'N' WHERE active_flag = 'Y'
C
MODIFY transactions SET active_flag = 'N' WHERE active_flag = 'Y'
D
REPLACE transactions SET active_flag = 'N' WHERE active_flag = 'Y'