Snowflake Updated COF-C03 Exam Questions and Answers by alexandros

The correct answer is A. GZIP .

When unloading data from Snowflake to staged files using COPY INTO < location > , the default compression for CSV output is GZIP unless a different compression option is specified.

Why A is correct:

For CSV unloads, Snowflake compresses output files using GZIP by default.

Example:

COPY INTO @my_stage/output/

FROM my_table

FILE_FORMAT = (TYPE = CSV);

If no compression is specified, the unloaded CSV files are compressed with GZIP by default.

Why the other options are incorrect:

B. AUTO is commonly used when loading data so Snowflake can automatically detect compression. It is not the default unload compression for CSV.

C. NONE disables compression, but it is not the default.

D. DEFLATE is a supported compression type, but it is not the default for CSV unload.

Official Snowflake documentation reference:

Snowflake documentation for CSV file format options explains that the default COMPRESSION value for unloading CSV data is GZIP.

The parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS sets the limit for a query to wait in the queue in order to get its chance of running on the warehouse. The query will quit after reaching this limit. By default, the value of this parameter is 0 which mean the queries will wait indefinitely in the waiting queue

https://community.snowflake.com/s/article/Warehouse-Concurrency-and-Statement-Timeout-Parameters#:~:text=The%20parameter%20STATEMENT_QUEUED_TIMEOUT_IN_SECONDS%20sets%20the,indefinitely%20in%20the%20waiting%20queue.

When a virtual warehouse in Snowflake is resized, specifically when it is increased in size, the additional compute resources become immediately available to all running and queued queries. Thismeans that the performance of these queries can improve due to the increased resources. Conversely, when the size of a warehouseis reduced, the compute resources are not removed until they are no longer being used by any current operations1.