Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core 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 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
EmiB
Highly Voted 1 year, 8 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 6 times
TheHuman_
6 months, 2 weeks 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 1 times
...
...
Mallikharjuna452
Most Recent 4 months ago
A and C are Correct.after loading into the table the data would be compressed.
upvoted 1 times
...
_yyukta
9 months ago
Selected Answer: AC
A and C are correct
upvoted 1 times
...
Mayuri917233
1 year, 6 months ago
Selected Answer: AC
AC are correct
upvoted 1 times
...
alanhuangjob
1 year, 7 months ago
I believe A and C are correct.
upvoted 1 times
...
SV1122
1 year, 10 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
1 year, 11 months ago
Selected Answer: AC
AC are correct
upvoted 1 times
...
Rajokkiyam
2 years, 9 months ago
AC correct
upvoted 2 times
...
Sundarr
2 years, 9 months ago
A and C. They are approximately 16MB in size and also immutable.
upvoted 1 times
...
arpit_dataguy
2 years, 9 months ago
Selected Answer: AC
16 MB compressed
upvoted 2 times
...
moon2351
2 years, 10 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
Loading ...