exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 598 discussion

Actual exam question from Snowflake's SnowPro Core
Question #: 598
Topic #: 1
[All SnowPro Core Questions]

How is table data compressed in Snowflake?

  • A. Each column is compressed as it is stored in a micro-partition.
  • B. Each micro-partition is compressed as it is written into cloud storage using GZIP.
  • C. The micro-partitions are stored in compressed cloud storage and the cloud storage handles compression.
  • D. The text data in a micro-partition is compressed with GZIP but other types are not compressed.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Renvis
Highly Voted 9 months ago
Answer is A
upvoted 8 times
...
learner2023
Most Recent 7 months ago
Selected Answer: A
https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions
upvoted 3 times
...
sidyndiaye
7 months, 1 week ago
shoul be A. Snowflake automatically determines the most efficient compression algorithm for the columns in each micro-partition. https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions#what-are-micro-partitions
upvoted 2 times
...
okurok
7 months, 3 weeks ago
Selected Answer: C
https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions#what-are-micro-partitions
upvoted 1 times
...
bibisa
8 months, 2 weeks ago
Selected Answer: A
COLUMNAR FORMAT When data is loaded into Snowflake, Snowflake reorganizes that data into its internal optimized, compressed, columnar format. Snowflake stores this optimized data in cloud storage. Snowflake manages all aspects of how this data is stored — the organization, file size, structure, compression, metadata, statistics, and other aspects of data storage are handled by Snowflake. The data objects stored by Snowflake are not directly visible nor accessible by customers; they are only accessible through SQL query operations run using Snowflake.
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago