Exam SnowPro Core topic 1 question 90 discussion

No, an active warehouse is not required to run a COPY INTO statement in Snowflake. The COPY INTO command can be executed without an active warehouse when: Loading data from external stages (like Amazon S3, Google Cloud Storage, or Microsoft Azure) Using the AUTO_COMPRESS option

COPY INTO: ● Copies data from staged files to a table ● All files loaded in a single operation must use the same stage and file format ● Can auto-detect compression mode, date and time formats ● Requires an active virtual warehouse

A.True,while loading the data,an active warehouse is required

False: An active warehouse is not always required to run a COPY INTO statement in Snowflake. Here's why: The COPY INTO statement is used to load data from external locations (stages) into Snowflake tables. While virtual warehouses provide the compute resources for processing queries within Snowflake, the COPY INTO operation itself is a data movement process.

COPY INTO table basically rights data into Micro Partition. To access the micro partition it requires a active warehouse to pass thru right. To access the storage it should pass thru the warehouse. it should be active. even if its suspended, upon receiving a Query the warehouse will resume and come into active to execute the query.

A is correct

https://docs.snowflake.com/en/user-guide/getting-started-tutorial-copy-into

Should be false B: False. A COPY INTO statement in Snowflake does not require an active warehouse to run. The statement is used to load data into a Snowflake table from a file stored in a cloud-based object storage such as Amazon S3, Microsoft Azure Blob Storage, or Google Cloud Storage. An active warehouse is only required to perform computationally-intensive tasks such as data processing, querying, and data transformation.

A is correct

Execute COPY INTO <table> to load your staged data into the target table. Note that this command requires an active, running warehouse, which you created as a prerequisite for this tutorial. If you don’t have access to a warehouse, you will need to create one now.

Answer is A. Execute COPY INTO <table> to load your staged data into the target table. Note that this command requires an active, running warehouse. https://docs.snowflake.com/en/user-guide/getting-started-tutorial-copy-into.html

Answer is B

I think it is false

Correct answer Link below states that you need an active, running warehouse to before COPY INTO functions https://docs.snowflake.com/en/user-guide/getting-started-tutorial-copy-into.html