Exam SnowPro Core topic 1 question 69 discussion

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

C and D are correct

Correct Answer is CD

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

Answer is C & D.

Ans should be C & D

CD are correct answer

CD are correct

C&D is right

CD are correct

CD are correct answer

Snowpipe copy into has certain restrictions.

Answer C D