If a table’s micro-partitions change due to clustering or consolidation, what happens to persisted query results?

• A. They are not affected.
• B. They are invalidated.
• C. They are archived but still usable.
• D. They are automatically rewritten without invalidation.

Answer: (B)

Persisted query results rely on the exact data being the same as when the result was created. In Snowflake, micro-partitions are the storage units that get reorganized during clustering or consolidation. When those partitions change, the underlying data snapshot those results depend on can be altered, so the previously persisted results would no longer represent the current data. To maintain correctness, those persisted results are invalidated, and a fresh run will produce new results based on the updated partitioning.