You are tasked with optimizing a frequently queried table 'SALES DATA' that experiences many updates. Which of the following Snowflake table features can significantly improve query performance in thi

Question

Options

• AUsing a Transient table instead of a Permanent table.
• BCreating a View on top of the table.
• CClustering the table on the most frequently filtered columns.
• DUsing a Temporary table instead of a Permanent table.
• EPartitioning the table on the date column.

• A
  4% (1)
• B
  4% (1)
• C
  83% (20)
• E
  8% (2)

Explanation

Clustering a table on the most frequently filtered columns (C) allows Snowflake's micro-partition pruning to skip large portions of data during scans, dramatically reducing I/O - especially valuable for a high-update table where data layout can become disorganized over time. Transient tables (A) and Temporary tables (D) differ only in data retention/fail-safe behavior, not query performance. A View (B) is simply a saved query definition and adds no physical optimization. Partitioning (E) is not a native Snowflake concept - Snowflake automatically manages micro-partitions, and "partitioning on a date column" describes a feature from traditional databases like Hive or PostgreSQL, not Snowflake.

Memory tip: In Snowflake, think "cluster = prune." When you cluster on filtered columns, Snowflake prunes micro-partitions it doesn't need to scan - the more selective your cluster key, the faster your queries.

No community discussion yet for this question.