Assume there is a table consisting of five micro-partitions with values ranging from A to Z.
Which diagram indicates a well-clustered table?
Assume there is a table consisting of five micro-partitions with values ranging from A to Z.
Which diagram indicates a well-clustered table?
A well-clustered table has values in sequential order without overlaps in micro-partitions. The first diagram illustrates such a table, with each micro-partition containing distinct, sequential ranges of values from A to Z, with no overlap.
https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html
Was on exam 2nd July 2023
Was on exam Dec 31st 2022
A Is correct,It dont have overlapping
A is correct
no overlapping is a well clustered.
It is A when only going off these 4 images. However in real scenarios, these things should be kept in mind: * The clustering depth for a table is not an absolute or precise measure of whether the table is well-clustered. Ultimately, query performance is the best indicator of how well-clustered a table is: ->If queries on a table are performing as needed or expected, the table is likely well-clustered. -> If query performance degrades over time, the table is likely no longer well-clustered and may benefit from clustering. https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions The images are exactly from that link, which also states "The diagram is not intended to represent an actual table. In an actual table, with data contained in a large numbers of micro-partitions, reaching a constant state across all micro-partitions is neither likely nor required to improve query performance."
Correct