Which of the following SQL statements can be used to update a transactions table, to set a flag on the table from Y to N

Which of the following SQL statements can be used to update a transactions table, to set a flag on the table from Y to N
A . MODIFY transactions SET active_flag = ‘N’ WHERE active_flag = ‘Y’
B. MERGE transactions SET active_flag = ‘N’ WHERE active_flag = ‘Y’
C. UPDATE transactions SET active_flag = ‘N’ WHERE active_flag = ‘Y’
D. REPLACE transactions SET active_flag = ‘N’ WHERE active_flag = ‘Y’

View Answer

Answer: D

Explanation:

The answer is

UPDATE transactions SET active_flag = ‘N’ WHERE active_flag = ‘Y’

Delta Lake supports UPDATE statements on the delta table, all of the changes as part of the update are ACID compliant.