SnowPro Core Certification — Question 1275

A user executed a SELECT query in Snowsight which returned a 1 GB result set. The user then downloads the files.

What will occur?

Answer options

• 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.

Correct answer: B

Explanation

The correct answer is B because Snowsight automatically compresses large result sets and splits them into manageable files for download. Option A is incorrect as a 1 GB result set cannot be downloaded as is. Option C is wrong because the system handles large files automatically, and option D is incorrect since the issue is not about the filters but rather the size of the result set.