
Answer-first summary for fast verification
Answer: Clustering
The correct answer is A (Clustering) because Snowflake uses automatic clustering to organize data in micro-partitions, which improves query performance by reducing the amount of data scanned. This is the primary performance optimization technique in Snowflake's architecture. Option B (Indexing) is incorrect because Snowflake does not use traditional database indexes - it relies on its micro-partition architecture instead. Option C (Fragmenting) is not a recognized Snowflake performance technique. Option D (Using INDEX_HINTS) is also incorrect since Snowflake doesn't support index hints due to the absence of traditional indexes.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.