ExamTopics Logo
Mail Us[email protected]
Menu
Snowflake Discussions
exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam
Go to Exam

Exam SnowPro Core topic 1 question 38 discussion

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

Which statements are true of micro-partitions? (Choose two.)

  • A. They are approximately 16MB in size
  • B. They are stored compressed only if COMPRESS=TRUE on Table
  • C. They are immutable
  • D. They are only encrypted in the Enterprise edition and above
Show Suggested Answer Hide Answer
Suggested Answer: AC 🗳️
by moon2351 at Jan. 2, 2022, 10 p.m.

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
Submit Cancel
EmiB
Highly Voted 2 years, 3 months ago
Selected Answer: AC
- micro-partitions are small in size (50 to 500 MB, before compression) - 16 MB must comes from old version/question - COMPRESSION = NONE is the right
upvoted 7 times
TheHuman_
1 year, 1 month ago
Your answer was a little unclear to me. Uncompressed the data of a micro partition would be around 50-500 MB, while compressed it is around 16 MB. Second answer is that these micro partitions are immutable
upvoted 2 times
...
...
Mallikharjuna452
Most Recent 11 months ago
A and C are Correct.after loading into the table the data would be compressed.
upvoted 1 times
...
_yyukta
1 year, 3 months ago
Selected Answer: AC
A and C are correct
upvoted 1 times
...
Mayuri917233
2 years, 1 month ago
Selected Answer: AC
AC are correct
upvoted 1 times
...
alanhuangjob
2 years, 2 months ago
I believe A and C are correct.
upvoted 1 times
...
SV1122
2 years, 5 months ago
Selected Answer: AC
The size of 50-500MB is for uncompressed data and micropartition itself holds around 16MB(after compression). https://stackoverflow.com/questions/67945427/clarification-on-the-snowflake-micro-partition-size
upvoted 3 times
...
Tapasgup007
2 years, 6 months ago
Selected Answer: AC
AC are correct
upvoted 1 times
...
Rajokkiyam
3 years, 4 months ago
AC correct
upvoted 2 times
...
Sundarr
3 years, 4 months ago
A and C. They are approximately 16MB in size and also immutable.
upvoted 1 times
...
arpit_dataguy
3 years, 4 months ago
Selected Answer: AC
16 MB compressed
upvoted 2 times
...
moon2351
3 years, 5 months ago
Selected Answer: AC
Answer is correct
upvoted 3 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