SOL-C01 · Question #131
SOL-C01 Question #131: Real Exam Question with Answer & Explanation
The correct answer is D: Using the 'COPY INTO' command with multiple parallel streams and a properly sized warehouse. The 'COPY INTO' command with a properly sized warehouse and parallel streams provides the fastest loading performance for large files. Snowpipe (option C) is also efficient, but 'COPY INTO' offers more control over the loading process. The web interface (option A) is unsuitable f
Question
You need to load a large CSV file (1 TB) into a Snowflake table. Which of the following methods would generally provide the fastest loading performance?
Options
- AUsing the Snowflake web interface to upload the file.
- BUsing a Python script with the Snowflake Connector to insert rows individually.
- CUsing Snowpipe with a properly sized warehouse and a file format object optimized for CSV files.
- DUsing the 'COPY INTO' command with multiple parallel streams and a properly sized warehouse
- Eare significantly slower due to network overhead and lack of parallelism.
Explanation
The 'COPY INTO' command with a properly sized warehouse and parallel streams provides the fastest loading performance for large files. Snowpipe (option C) is also efficient, but 'COPY INTO' offers more control over the loading process. The web interface (option A) is unsuitable for large files. Python scripts with individual inserts (option B) and direct 'INSERT INTO' statements (option
Topics
Community Discussion
No community discussion yet for this question.