COF-C02 practice question 23 of 35
True or False: Snowpipe via REST API can only reference External Stages as source.
Full set: 778 questionsThe statement is false. The Snowpipe REST API, specifically the insertFiles endpoint, can be used to trigger data loads from files located in both internal (i.e., Snowflake) stages and external stages (e.g., Amazon S3, Google Cloud Storage, Microsoft Azure Blob Storage). The API call requires specifying the path to the data files, and these files can reside in any type of stage that the pipe is configured to monitor.
The statement "True" is incorrect because it presents a false limitation. The Snowpipe REST API is not restricted to only external stages. The official Snowflake documentation explicitly confirms its capability to ingest files from internal stages as well, providing flexibility in data loading workflows.
1. Snowflake Documentation: Calling the Snowpipe REST Endpoints to Load Data.
Section: POST /v1/data/pipes/{pipeName}/insertFiles
Reference: In the description of the JSON request body for this endpoint
the files parameter is defined as: "A list of files to ingest. The files must already be staged in the internal (i.e. Snowflake) or external stage for the table." This directly confirms that both internal and external stages are supported sources.
Keep practicing
Take the free COF-C02 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other COF-C02 practice questions
- Question 1What does Snowflake recommend regarding database object ownership? (Select TWO).
- Question 2What kind of value does a User-Defined Function (UDF) return? (Select TWO).
- Question 3How do Snowflake data providers share data that resides in different databases?
- Question 4What are supported file formats for unloading data from Snowflake? (Choose three.)
- Question 5A marketing co-worker has requested the ability to change a warehouse size on their mediu…
- Question 6What service is provided as an integrated Snowflake feature to enhance Multi-Factor Authe…
