SnowPro Core Certification — Question 92

Which of the following commands are not blocking operations? (Choose two.)

Answer options

• A. UPDATE
• B. INSERT
• C. MERGE
• D. COPY

Correct answer: B, D

Explanation

The correct answers, INSERT and COPY, are considered non-blocking operations as they can execute without waiting for other operations to complete. In contrast, UPDATE and MERGE typically involve locking mechanisms that can block other operations until they finish.