Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
SnowPro Core Certification · Snowflake
Select 2 answers.
This question asks for 2 answers, but our data marks only 1. Compare with the community discussion below for the full answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
Here's why the other options are not typically blocking: B. INSERT (Non-blocking): Inserting new data typically doesn't block other operations on the same table. Snowflake manages insertions efficiently and allows concurrent access for reads and other inserts. D. COPY (Non-blocking in most cases): The COPY command for loading data is usually non-blocking. Snowflake manages the loading process in the background and allows other operations to proceed without interruption.
Correct
Answer is BD Explanation: Only UPDATE and DELETE DML operations are blocked when a table is locked. INSERT operations are NOT blocked. UPDATE, DELETE, and MERGE statements hold locks that generally prevent them from running in parallel with other UPDATE, DELETE, and MERGE statements. Most INSERT and COPY statements write only new partitions.