Exam SOL-C01 Topic 1 Question 32 Discussion

Actual exam question for Snowflake's SOL-C01 exam
Question #: 32
Topic #: 1

A data team is designing a data pipeline that loads data from S3 into Snowflake. The raw data in S3 is compressed using gzip and stored in multiple files. They want to use a Snowflake virtual warehouse to perform the data loading. Which of the following COPY INTO command options would be MOST appropriate to optimize the data loading process?

A. Specify 'ON_ERROR = CONTINUE in the COPY INTO command to skip any files with errors. B. Use the 'VALIDATION_MODE = RETURN ERRORS parameter to identify any issues within the load and address them later. C. Utilize 'MATCH BY COLUMN NAME = CASE INSENSITIVE so that the command is robust to case differences. D. Specify 'FILE FORMAT = (TYPE = CSV COMPRESSION = GZIP)' in the COPY INTO command to instruct Snowflake to automatically decompress the gzip files. Also, split the large warehouse for loading and transforming data. E. Set the 'MAX FILE_SIZE parameter to a smaller value to force Snowflake to process files in smaller chunks.

Suggested Answer: D Vote an answer

ERROR = CONTINUE (A) skips errors but doesn't address decompression. 'VALIDATION MODE' (B) is helpful for debugging but doesn't directly optimize the loading process. (C) can ease development but has nothing to do with compression. Specifying = (TYPE = CSV COMPRESSION = GZIP)' (D) allows Snowflake to handle gzip decompression automatically.
'MAX FILE_SIZE (E) can be useful in certain scenarios but is not related to compressed files directly. Splitting the warehouse is not a COPY INTO option, but rather a high-level architecture decision.

by Dale at Jul 05, 2026, 11:53 PM

Limited Time Offer

15%

Off

Get Premium SOL-C01 Questions as Interactive Self Test Engine or PDF

Comments

0 Happy Clients

0 Shares

0 Demo Downloads

10 Years in Business