SOL-C01 Question #117: Real Exam Question with Answer & Explanation

Question

A Snowflake administrator needs to load data from multiple compressed (gzip) CSV files located in an external stage into a Snowflake table. Which *COPY INTO' command options can improve the loading performance and minimize resource consumption? Choose all that apply.

Options

• ASpecifying = CASE_INSENSITIVE to handle potential case differences in column names.
• BUsing a larger virtual warehouse size during the load operation.
• CUtilizing to split large files before loading.
• DSetting ERROR = 'SKIP FILE" to ignore files with errors, thus preventing load interruption.
• EEnsuring the files are automatically compressed with GZIP and Snowflake automatically

Explanation

Option B, using a larger virtual warehouse size, can significantly improve performance by allocating more resources to the load operation. Option E is correct as Snowflake automatically decompresses GZIP files during load without needing a specific parameter. A does not improve loading performance. C is incorrect because *MAX FILE SIZE is not a valid parameter for 'COPY INTO' command. D, setting 'ON_ERROR = 'SKIP_FILE" , helps to prevent interruption, but it doesn't specifically improve loading performance.

No community discussion yet for this question.