Snowflake interview questions

1. A.A Snowflake object that tracks credit consumption against a quota and can notify, suspend, or kill warehouses when limits are hit.
2. B.A Snowflake feature that offloads scan-heavy parts of large queries to extra serverless compute, smoothing out skewed or outlier workloads.
3. C.A Snowflake table that automatically and incrementally refreshes from a query to a declared target lag, a declarative alternative to manual pipelines.
4. D.Snowflake's continuous, serverless ingestion service that auto-loads files from a stage shortly after they land, billed per compute used.

Answer + AI explanation with Pro

1. A.Dynamic Table
2. B.Snowpipe
3. C.secure view
4. D.Iceberg Table

Answer + AI explanation with Pro

1. A.Dynamic Table — A Snowflake table feature that builds a persistent search access path to speed up highly selective point lookups on large tables.
2. B.Dynamic Table — Choosing a virtual warehouse t-shirt size (XS to 6XL) where each step roughly doubles compute and credits-per-hour, trading cost for speed.
3. C.Dynamic Table — A Snowflake table that automatically and incrementally refreshes from a query to a declared target lag, a declarative alternative to manual pipelines.
4. D.Dynamic Table — A Snowflake table type that stores data in open Apache Iceberg format in your own cloud storage while giving Snowflake-native query and governance.

Answer + AI explanation with Pro

1. A.A Snowflake table feature that builds a persistent search access path to speed up highly selective point lookups on large tables.
2. B.A Snowflake reference to a cloud storage location (S3, GCS, Azure) used as a source or target for COPY operations.
3. C.A Snowflake table that automatically and incrementally refreshes from a query to a declared target lag, a declarative alternative to manual pipelines.
4. D.A Snowflake object that records row-level change data (a CDC offset) on a table or view so tasks can consume inserts, updates, and deletes incrementally.

Answer + AI explanation with Pro

1. A.search optimization service
2. B.warehouse sizing
3. C.Stream
4. D.Cortex

Answer + AI explanation with Pro

1. A.Stream — A Snowflake object that tracks credit consumption and can suspend warehouses when a quota is reached, controlling cost.
2. B.Stream — A Snowflake object that records row-level change data (a CDC offset) on a table or view so tasks can consume inserts, updates, and deletes incrementally.
3. C.Stream — Snowflake's role-based access control where privileges are granted to roles, roles to users, and roles can be nested into a hierarchy.
4. D.Stream — The 2025 GA rewrite of Snowpipe Streaming using Rust-core SDKs and server-side schema validation, ingesting up to 10 GB/s per table with sub-10-second query latency.

Answer + AI explanation with Pro

1. A.Snowflake's developer framework for running DataFrame and Python, Java, or Scala code inside the warehouse without moving data out.
2. B.A schema-level rule that dynamically redacts or tokenizes a column's values at query time based on the querying role.
3. C.A Snowflake virtual warehouse that auto-scales out to multiple compute clusters to handle concurrency spikes, then scales back in.
4. D.The 2025 GA rewrite of Snowpipe Streaming using Rust-core SDKs and server-side schema validation, ingesting up to 10 GB/s per table with sub-10-second query latency.

Answer + AI explanation with Pro

1. A.Cortex
2. B.multi-cluster warehouse
3. C.Dynamic Table
4. D.Snowpark

Answer + AI explanation with Pro

1. A.Snowpark — A Snowflake object that tracks credit consumption and can suspend warehouses when a quota is reached, controlling cost.
2. B.Snowpark — A Snowflake virtual warehouse that auto-scales out to multiple compute clusters to handle concurrency spikes, then scales back in.
3. C.Snowpark — A Snowflake semi-structured data type that stores JSON, Avro, or XML, queried with path notation and flattened on demand.
4. D.Snowpark — Snowflake's developer framework for running DataFrame and Python, Java, or Scala code inside the warehouse without moving data out.

Answer + AI explanation with Pro

1. A.A Snowflake feature that offloads scan-heavy parts of large queries to extra serverless compute, smoothing out skewed or outlier workloads.
2. B.A Snowflake object that records row-level change data (a CDC offset) on a table or view so tasks can consume inserts, updates, and deletes incrementally.
3. C.A Snowflake table type that stores data in open Apache Iceberg format in your own cloud storage while giving Snowflake-native query and governance.
4. D.Snowflake's developer framework for running DataFrame and Python, Java, or Scala code inside the warehouse without moving data out.

Answer + AI explanation with Pro

1. A.Dynamic Table
2. B.Iceberg Table
3. C.masking policy
4. D.query acceleration service

Answer + AI explanation with Pro

1. A.Iceberg Table — A multi-cluster warehouse setting (Standard or Economy) controlling how eagerly Snowflake spins extra clusters up for concurrency and down to save credits.
2. B.Iceberg Table — A Snowflake table type that stores data in open Apache Iceberg format in your own cloud storage while giving Snowflake-native query and governance.
3. C.Iceberg Table — A Snowflake virtual warehouse that auto-scales out to multiple compute clusters to handle concurrency spikes, then scales back in.
4. D.Iceberg Table — A Snowflake feature that offloads parts of scan-heavy queries to serverless compute to speed up unpredictable, large scans.

Answer + AI explanation with Pro

1. A.A Snowflake virtual warehouse that auto-scales out to multiple compute clusters to handle concurrency spikes, then scales back in.
2. B.Choosing a virtual warehouse t-shirt size (XS to 6XL) where each step roughly doubles compute and credits-per-hour, trading cost for speed.
3. C.The 2025 GA rewrite of Snowpipe Streaming using Rust-core SDKs and server-side schema validation, ingesting up to 10 GB/s per table with sub-10-second query latency.
4. D.Snowflake's governance and catalog layer that applies tags, lineage, and policies across native and Iceberg tables, including externally written ones.

Answer + AI explanation with Pro

1. A.Horizon Catalog
2. B.masking policy
3. C.scaling policy
4. D.multi-cluster warehouse

Answer + AI explanation with Pro

1. A.multi-cluster warehouse — A Snowflake virtual warehouse that auto-scales out to multiple compute clusters to handle concurrency spikes, then scales back in.
2. B.multi-cluster warehouse — Choosing a virtual warehouse t-shirt size (XS to 6XL) where each step roughly doubles compute and credits-per-hour, trading cost for speed.
3. C.multi-cluster warehouse — A column expression defining how a large Snowflake table's micro-partitions are organized so pruning skips more data for selective queries.
4. D.multi-cluster warehouse — A Snowflake semi-structured data type that stores JSON, Avro, or XML, queried with path notation and flattened on demand.

Answer + AI explanation with Pro

1. A.A Snowflake feature that offloads scan-heavy parts of large queries to extra serverless compute, smoothing out skewed or outlier workloads.
2. B.A Snowflake view that hides its definition and disables optimizations that could leak underlying data, used for row- and column-level sharing.
3. C.A Snowflake feature that builds a persistent search access path to speed up highly selective point-lookup and equality queries on large tables.
4. D.A column expression defining how a large Snowflake table's micro-partitions are organized so pruning skips more data for selective queries.

Answer + AI explanation with Pro

1. A.Snowpipe Streaming high-performance architecture
2. B.search optimization service
3. C.multi-cluster warehouse
4. D.clustering key

Answer + AI explanation with Pro

1. A.search optimization service — A background service that incrementally re-clusters a table on its clustering key as data changes, without a manual rebuild.
2. B.search optimization service — A Snowflake feature that builds a persistent search access path to speed up highly selective point-lookup and equality queries on large tables.
3. C.search optimization service — A Snowflake feature that offloads scan-heavy parts of large queries to extra serverless compute, smoothing out skewed or outlier workloads.
4. D.search optimization service — A schema-level rule that dynamically redacts or tokenizes a column's values at query time based on the querying role.

Answer + AI explanation with Pro

1. A.A column expression defining how a large Snowflake table's micro-partitions are organized so pruning skips more data for selective queries.
2. B.A schema-level rule that dynamically redacts or tokenizes a column's values at query time based on the querying role.
3. C.Snowflake's managed AI layer offering LLM functions, vector search, and ML directly in SQL over governed data.
4. D.A Snowflake virtual warehouse that auto-scales out to multiple compute clusters to handle concurrency spikes, then scales back in.

Answer + AI explanation with Pro

1. A.RBAC
2. B.Snowpipe
3. C.Cortex
4. D.resource monitor

Answer + AI explanation with Pro

1. A.Cortex — A Snowflake object that tracks credit consumption and can suspend warehouses when a quota is reached, controlling cost.
2. B.Cortex — A Snowflake table feature that builds a persistent search access path to speed up highly selective point lookups on large tables.
3. C.Cortex — A Snowflake object that records row-level change data (a CDC offset) on a table or view so tasks can consume inserts, updates, and deletes incrementally.
4. D.Cortex — Snowflake's managed AI layer offering LLM functions, vector search, and ML directly in SQL over governed data.

Answer + AI explanation with Pro

1. A.The 2025 GA rewrite of Snowpipe Streaming using Rust-core SDKs and server-side schema validation, ingesting up to 10 GB/s per table with sub-10-second query latency.
2. B.Snowflake's governance and catalog layer that applies tags, lineage, and policies across native and Iceberg tables, including externally written ones.
3. C.A Snowflake object that records row-level change data (a CDC offset) on a table or view so tasks can consume inserts, updates, and deletes incrementally.
4. D.A Snowflake table that automatically and incrementally refreshes from a query to a declared target lag, a declarative alternative to manual pipelines.

Answer + AI explanation with Pro

1. A.search optimization service
2. B.Cortex
3. C.scaling policy
4. D.Horizon Catalog

Answer + AI explanation with Pro

1. A.Horizon Catalog — A Snowflake feature that offloads parts of scan-heavy queries to serverless compute to speed up unpredictable, large scans.
2. B.Horizon Catalog — A Snowflake table type that stores data in open Apache Iceberg format in your own cloud storage while giving Snowflake-native query and governance.
3. C.Horizon Catalog — Snowflake's governance and catalog layer that applies tags, lineage, and policies across native and Iceberg tables, including externally written ones.
4. D.Horizon Catalog — A Snowflake view that hides its definition and disables optimizations that could leak underlying data, used for row- and column-level sharing.

Answer + AI explanation with Pro

1. A.A Snowflake object that tracks credit consumption and can suspend warehouses when a quota is reached, controlling cost.
2. B.The 2025 GA rewrite of Snowpipe Streaming using Rust-core SDKs and server-side schema validation, ingesting up to 10 GB/s per table with sub-10-second query latency.
3. C.A Snowflake database that points directly at an external Iceberg REST catalog for live, zero-copy interoperability with other engines.
4. D.A Snowflake semi-structured data type that stores JSON, Avro, or XML, queried with path notation and flattened on demand.

Answer + AI explanation with Pro

1. A.Snowpipe
2. B.Dynamic Table
3. C.resource monitor
4. D.catalog-linked database

Answer + AI explanation with Pro

1. A.catalog-linked database — A Snowflake semi-structured data type that stores JSON, Avro, or XML, queried with path notation and flattened on demand.
2. B.catalog-linked database — Choosing a virtual warehouse t-shirt size (XS to 6XL) where each step roughly doubles compute and credits-per-hour, trading cost for speed.
3. C.catalog-linked database — A Snowflake database that points directly at an external Iceberg REST catalog for live, zero-copy interoperability with other engines.
4. D.catalog-linked database — Snowflake's continuous, serverless ingestion service that auto-loads files from a stage shortly after they land, billed per compute used.

Answer + AI explanation with Pro

1. A.A background service that incrementally re-clusters a table on its clustering key as data changes, without a manual rebuild.
2. B.A column expression defining how a large Snowflake table's micro-partitions are organized so pruning skips more data for selective queries.
3. C.A Snowflake feature that offloads scan-heavy parts of large queries to extra serverless compute, smoothing out skewed or outlier workloads.
4. D.A Snowflake semi-structured data type that stores JSON, Avro, or XML, queried with path notation and flattened on demand.

Answer + AI explanation with Pro

1. A.VARIANT
2. B.scaling policy
3. C.resource monitor
4. D.automatic clustering

Answer + AI explanation with Pro

1. A.VARIANT — A Snowflake reference to a cloud storage location (S3, GCS, Azure) used as a source or target for COPY operations.
2. B.VARIANT — A Snowflake semi-structured data type that stores JSON, Avro, or XML, queried with path notation and flattened on demand.
3. C.VARIANT — A Snowflake object that records row-level change data (a CDC offset) on a table or view so tasks can consume inserts, updates, and deletes incrementally.
4. D.VARIANT — A Snowflake feature that offloads scan-heavy parts of large queries to extra serverless compute, smoothing out skewed or outlier workloads.

Answer + AI explanation with Pro