
Answer-first summary for fast verification
Answer: Parallel processing
The correct answer is C (Parallel processing) because the COPY INTO statement automatically splits table data into multiple output files to leverage Snowflake's parallel processing capabilities. This allows different nodes in the cluster to process files simultaneously, improving performance. The community discussion confirms this with 100% consensus on answer C, and detailed comments explain how parallel processing enables simultaneous file processing across cluster nodes. Other options are incorrect: A (Query acceleration) is for accelerating queries, not file operations; B (Query plan caching) caches query execution plans; D (Time Travel) enables data recovery to previous states.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.