SnowPro Core Certification — Question 48

Which of the following is true of Snowpipe via REST API? (Choose two.)

Answer options

• A. You can only use it on Internal Stages
• B. All COPY INTO options are available during pipe creation
• C. Snowflake automatically manages the compute required to execute the Pipe's COPY INTO commands
• D. Snowpipe keeps track of which files it has loaded

Correct answer: C, D

Explanation

The correct answers, C and D, highlight that Snowflake automates resource management for executing COPY INTO commands and keeps a record of loaded files. Options A and B are incorrect because Snowpipe can work with both Internal and External Stages, and not all COPY INTO options are accessible during pipe creation.