Answer: DELETE

The correct answer is B (DELETE) because the INSERT statement with the OVERWRITE option requires the DELETE privilege to remove existing rows from the target table before inserting new data. This is explicitly stated in Snowflake documentation and confirmed by the community discussion, where all participants (100%) selected B, with upvoted comments explaining that OVERWRITE deletes existing records, necessitating DELETE privilege. Options A (TRUNCATE), C (UPDATE), and D (SELECT) are incorrect as they are not required for the OVERWRITE functionality; TRUNCATE is a separate operation, UPDATE modifies existing rows, and SELECT is for querying data.

Author: LeetQuiz Editorial Team