Answer-first summary for fast verification
Answer: The result set will be automatically compressed and the data will be downloaded as individual files.
The correct answer is B because Snowsight automatically handles large result sets by compressing the data and splitting it into multiple files. This is confirmed by the community discussion where multiple users with upvotes (3 each) selected B, explaining that Snowflake applies compression and divides data into multiple files (typically 16 MB chunks). Option A is incorrect because Snowsight does not download results as a single uncompressed file for large datasets. Option C is wrong as there is no 50 MB file size limit that causes failures. Option D is incorrect because Snowsight handles the download automatically without requiring query modifications.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A user runs a SELECT query in Snowsight that returns a 1 GB result set and then clicks to download the results.
What happens?
A
The result set will be successfully downloaded from Snowsight.
B
The result set will be automatically compressed and the data will be downloaded as individual files.
C
The download will fail because the result set needs to be broken up into files no greater than 50 MB before downloading.
D
The download will result in an error because the filters of the SELECT query need to be changed so that Snowsight returns a smaller result set.
No comments yet.