exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 116 discussion

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

True or False: Once created, a micro-partition will never be changed.

  • A. True
  • B. False
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
vhvhkkk
1 month, 1 week ago
Selected Answer: A
A. True Once a micro-partition is created in Snowflake, it cannot be modified. Micro-partitions are immutable, meaning that after data is written to them, they cannot be altered or updated directly. However, Snowflake automatically manages data storage and optimization. If data in a micro-partition needs to be updated, the system will create new micro-partitions with the updated data, and older partitions will eventually be marked for deletion during data maintenance operations like vacuuming. This immutability helps Snowflake maintain its performance and data consistency over time.
upvoted 2 times
...
Mallikharjuna452
5 months, 1 week ago
A.True
upvoted 1 times
...
[Removed]
1 year, 1 month ago
Selected Answer: A
Immutable
upvoted 2 times
...
Thaiya
1 year, 3 months ago
Selected Answer: A
micro partition can be changed but not deleted.
upvoted 1 times
...
ifmateus
1 year, 4 months ago
Selected Answer: B
How can we say a micro-partition can't be changed if using clustering keys we're literally changing how micro-partitions are organized? I think it's B, can't find these "immutable" references from the other answers anywhere. https://community.snowflake.com/s/article/understanding-micro-partitions-and-data-clustering
upvoted 1 times
rogerek077
9 months ago
In reclustering context, reorganizing doesn't mean that anything changes in existing micro-partitions' structure - instead the new micro-partitions are created with the same keys as in old micro-partitions before reclustering but reorganized to fit the clustering requirements. Check this article for a reference: https://docs.snowflake.com/en/user-guide/tables-clustering-keys#reclustering Check the diagram from a provided example. New micro-partitions are called "new" for a reason, also the new numbering (micro-partition 5, 6, 7, 8) should give you a clue.
upvoted 2 times
...
...
Mayuri917233
1 year, 7 months ago
Selected Answer: A
A is correct
upvoted 1 times
...
jurges
1 year, 12 months ago
Selected Answer: A
The immutability of micro partition it means that there could be changes in relation to the status of the data in micro partition, so it could be updated or deleted but this is kept as information. But the data itself cannot be changed.Even if update with the clustering key it will add new micropartitions with the changes
upvoted 2 times
...
kjdfsafc87456
2 years, 4 months ago
Selected Answer: A
The answer is correct as How did they do this? Let’s break down how Snowflake stores data: in Snowflake, all data is stored in micro-partitions, which are contiguous units of storage that are immutable. Immutability means that once a micro-partition is written, it will never be changed
upvoted 2 times
...
lhstudylh
2 years, 9 months ago
Selected Answer: A
While True, it is important to note new micro-partitions are created when new data is uploaded or data is transformed. Additional old micro-paritions are stored for time-travel support purposes
upvoted 4 times
...
Sid460545
2 years, 10 months ago
Correct, it can never be changed. They are immutable.
upvoted 1 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