
Explanation:
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.
Ultimate access to all questions.
No comments yet.