Exam SnowPro Core topic 1 question 1256 discussion

Actual exam question from Snowflake's SnowPro Core

Question #: 1256
Topic #: 1

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

What will occur?

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.

Show Suggested Answer

Suggested Answer: B 🗳️

by 37ceea2 at Jan. 20, 2025, 4:34 p.m.

Comments

Submit Cancel

wcn

3 weeks, 4 days ago

Selected Answer: A

Snowsight enables users to download the full result of their queries as an uncompressed CSV file. Snowsight addresses a key limitation of the deprecated Classic Web Interface: query result download limits. While the Classic Web Interface only allowed users to download the first 100 MB of a query result as a CSV,

upvoted 1 times

...

MatthieuDN

6 months, 3 weeks ago

Selected Answer: B

B - Snowflake apply compression and splits data into multiple files

upvoted 3 times

...

37ceea2

6 months, 4 weeks ago

Selected Answer: B

First of all, 1 GB is not good. It is by default divided in 16 MB files, and compressed, I suppose.

upvoted 3 times

...