Which SQL statement correctly updates a transactions table to change a flag from 'Y' to 'N'?
Real Exam
Explanation:
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.
