Answer: INSERT, COPY

Based on Snowflake documentation and the community discussion consensus (100% agreement on BD with 18 upvotes for the most detailed explanation), INSERT and COPY operations are typically non-blocking. This is because INSERT and COPY statements usually write only new partitions, allowing them to run in parallel with other operations. In contrast, UPDATE, DELETE, and MERGE operations acquire locks that prevent parallel execution with other DML operations. The community discussion clearly establishes that UPDATE and MERGE are blocking operations, while INSERT and COPY are not, making B (INSERT) and D (COPY) the correct non-blocking operations.

Author: LeetQuiz Editorial Team