SnowPro Core Certification — Question 349

How does a Snowflake user execute an anonymous block of code?

Answer options

• A. The user must run the CALL command to execute the block.
• B. The statements that define the block must also execute the block.
• C. The SUBMIT command must run immediately after the block is defined
• D. The block must be saved to a worksheet and executed using a connector.

Correct answer: B

Explanation

The correct answer is B because in Snowflake, the execution of an anonymous block is dependent on the statements within it. Option A is incorrect as the CALL command is not used for anonymous blocks, C is wrong because SUBMIT is not a relevant command for this context, and D is incorrect since blocks do not need to be saved or run through a connector.