Which of the following is true of Snowpipe via REST API? (Choose two.)
Which of the following is true of Snowpipe via REST API? (Choose two.)
Snowpipe via REST API allows Snowflake to automatically manage the compute resources required to execute the Pipe's COPY INTO commands, ensuring that the process is efficient and seamless. Additionally, Snowpipe keeps track of which files have already been loaded, preventing duplicate data loads. These features simplify and automate the data loading process considerably.
Answer is C & D. Not B as: https://docs.snowflake.com/en/sql-reference/sql/create-pipe.html#usage-notes All COPY INTO <table> copy options are supported except for the following: FILES = ( 'file_name1' [ , 'file_name2', ... ] ) ON_ERROR = ABORT_STATEMENT SIZE_LIMIT = num PURGE = TRUE | FALSE (i.e. automatic purging while loading) FORCE = TRUE | FALSE
Correct answer:CD since pipe is using serverless functionality
The correct options for what is true of Snowpipe via REST API are: 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
Here's why the other options are not accurate: A. You can only use it on Internal Stages: You can use Snowpipe via REST API with both Internal Stages (located within Snowflake storage) and External Stages (referencing data in external cloud storage providers like S3 or Azure Blob Storage). B. All COPY INTO options are available during pipe creation: Not all COPY INTO options are available through the Snowpipe REST API for pipe creation. While the core functionality is supported, some advanced options might be limited through the API compared to directly using the COPY INTO command within Snowflake.
C & D: Snowpipe uses Snowflake-provided compute resources: https://docs.snowflake.com/user-guide/data-load-snowpipe-intro#calling-snowpipe-rest-endpoints
BD are correct
CD are correct answer
CD are correct answer
Snowpipe copy into has certain restrictions.
C and D are correct
Correct Answer is CD
Answer is C & D.
Ans should be C & D
CD are correct
C&D is right
CD are correct
Answer C D