SnowPro Core Certification — Question 950

To use the OVERWRITE option on INSERT, which privilege must be granted to the role?

Answer options

• A. TRUNCATE
• B. DELETE
• C. UPDATE
• D. SELECT

Correct answer: B

Explanation

The DELETE privilege is necessary for using the OVERWRITE option on an INSERT because it allows the replacement of existing records. The TRUNCATE privilege is not relevant here as it pertains to removing all rows from a table, while UPDATE and SELECT do not provide the needed permissions for overwriting existing data.