
Answer-first summary for fast verification
Answer: Cluster a table., Enable the search optimization service.
The question asks for two actions to optimize query performance in Snowflake. Option B (Cluster a table) is correct because clustering physically reorders data based on specified columns, improving query performance for filters on those columns. Option C (Enable the search optimization service) is correct as it creates search indexes to accelerate point lookup queries. Option A (Create a view) does not inherently improve performance as views are logical constructs. Option D (Enable Time Travel) is for data recovery, not performance. Option E (Index a table) is incorrect because Snowflake does not use traditional indexes; it uses micro-partitions and clustering keys instead. The community discussion unanimously supports BC with 100% consensus and upvoted explanations.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.