COF-C03 practice question 8 of 10
True or False: Snowpipe via REST API can only reference External Stages as source.
Full set: 1,126 questionsThe statement is false. Snowpipe, including when invoked via its REST API, can load data from both internal (Snowflake-managed) stages and external stages (e.g., Amazon S3, Google Cloud Storage, Microsoft Azure). The CREATE PIPE command allows the definition of a pipe that copies data from either an internal or an external stage. The REST API is simply a mechanism to notify Snowpipe to process specific files located in the stage defined in the pipe's definition, regardless of the stage type.
A. (True) This is incorrect because Snowpipe is designed to work with both internal and external stages, providing flexibility for various data ingestion architectures.
1. Snowflake Documentation. (n.d.). REST API for Snowpipe. Retrieved from https://docs.snowflake.com/en/user-guide/data-load-snowpipe-rest. The documentation describes the insertFiles endpoint, which triggers a pipe to load files from its defined stage, without restricting the stage type.
2. Snowflake Documentation. (n.d.). CREATE PIPE. Retrieved from https://docs.snowflake.com/en/sql-reference/sql/create-pipe. The syntax and examples clearly show pipes being created on both internal (@~, @%) and external (@myextstage) stages.
Keep practicing
Take the free COF-C03 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other COF-C03 practice questions
- Question 1What is the primary purpose for configuring multiple Identity Providers, or IdPs, in Snow…
- Question 2At what level is the MIN_DATA_RETENTION_TIME_IN_DAYS parameter set?
- Question 3Which commands are restricted in owner's rights stored procedures? (Select TWO).
- Question 4Which views are included in the DATA SHARING USAGE schema? (Select TWO).
- Question 5Snowflake's access control framework combines which models for securing data? (Select TWO…
- Question 6True or False: Loading data into Snowflake requires that source data files be no larger t…
