75 real Snowflake questions from the Data Engineering bank, as asked in Indian campus drives and tech interviews. Every question has a verified answer and an AI-tutor explanation on placd — free to start.
1. What is Dynamic Table?
Mid
A.A Snowflake object that tracks credit consumption against a quota and can notify, suspend, or kill warehouses when limits are hit.
B.A Snowflake feature that offloads scan-heavy parts of large queries to extra serverless compute, smoothing out skewed or outlier workloads.
C.A Snowflake table that automatically and incrementally refreshes from a query to a declared target lag, a declarative alternative to manual pipelines.
D.Snowflake's continuous, serverless ingestion service that auto-loads files from a stage shortly after they land, billed per compute used.
2. Which term means: "A Snowflake table that automatically and incrementally refreshes from a query to a declared target lag, a declarative alternative to manual pipelines."?
A.Dynamic Table — A Snowflake table feature that builds a persistent search access path to speed up highly selective point lookups on large tables.
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.
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.
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.
A.A Snowflake table feature that builds a persistent search access path to speed up highly selective point lookups on large tables.
B.A Snowflake reference to a cloud storage location (S3, GCS, Azure) used as a source or target for COPY operations.
C.A Snowflake table that automatically and incrementally refreshes from a query to a declared target lag, a declarative alternative to manual pipelines.
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.
5. Which term means: "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."?
A.Stream — A Snowflake object that tracks credit consumption and can suspend warehouses when a quota is reached, controlling cost.
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.
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.
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.
A.Snowflake's developer framework for running DataFrame and Python, Java, or Scala code inside the warehouse without moving data out.
B.A schema-level rule that dynamically redacts or tokenizes a column's values at query time based on the querying role.
C.A Snowflake virtual warehouse that auto-scales out to multiple compute clusters to handle concurrency spikes, then scales back in.
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.
8. Which term means: "Snowflake's developer framework for running DataFrame and Python, Java, or Scala code inside the warehouse without moving data out."?
A.A Snowflake feature that offloads scan-heavy parts of large queries to extra serverless compute, smoothing out skewed or outlier workloads.
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.
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.
D.Snowflake's developer framework for running DataFrame and Python, Java, or Scala code inside the warehouse without moving data out.
11. Which term means: "A Snowflake table type that stores data in open Apache Iceberg format in your own cloud storage while giving Snowflake-native query and governance."?
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.
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.
C.Iceberg Table — A Snowflake virtual warehouse that auto-scales out to multiple compute clusters to handle concurrency spikes, then scales back in.
D.Iceberg Table — A Snowflake feature that offloads parts of scan-heavy queries to serverless compute to speed up unpredictable, large scans.
A.A Snowflake virtual warehouse that auto-scales out to multiple compute clusters to handle concurrency spikes, then scales back in.
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.
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.
D.Snowflake's governance and catalog layer that applies tags, lineage, and policies across native and Iceberg tables, including externally written ones.
14. Which term means: "A Snowflake virtual warehouse that auto-scales out to multiple compute clusters to handle concurrency spikes, then scales back in."?
A.multi-cluster warehouse — A Snowflake virtual warehouse that auto-scales out to multiple compute clusters to handle concurrency spikes, then scales back in.
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.
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.
D.multi-cluster warehouse — A Snowflake semi-structured data type that stores JSON, Avro, or XML, queried with path notation and flattened on demand.
17. Which term means: "A Snowflake feature that builds a persistent search access path to speed up highly selective point-lookup and equality queries on large tables."?
A.search optimization service — A background service that incrementally re-clusters a table on its clustering key as data changes, without a manual rebuild.
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.
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.
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.
A.Cortex — A Snowflake object that tracks credit consumption and can suspend warehouses when a quota is reached, controlling cost.
B.Cortex — A Snowflake table feature that builds a persistent search access path to speed up highly selective point lookups on large tables.
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.
D.Cortex — Snowflake's managed AI layer offering LLM functions, vector search, and ML directly in SQL over governed data.
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.
B.Snowflake's governance and catalog layer that applies tags, lineage, and policies across native and Iceberg tables, including externally written ones.
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.
D.A Snowflake table that automatically and incrementally refreshes from a query to a declared target lag, a declarative alternative to manual pipelines.
23. Which term means: "Snowflake's governance and catalog layer that applies tags, lineage, and policies across native and Iceberg tables, including externally written ones."?
A.Horizon Catalog — A Snowflake feature that offloads parts of scan-heavy queries to serverless compute to speed up unpredictable, large scans.
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.
C.Horizon Catalog — Snowflake's governance and catalog layer that applies tags, lineage, and policies across native and Iceberg tables, including externally written ones.
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.
A.A Snowflake object that tracks credit consumption and can suspend warehouses when a quota is reached, controlling cost.
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.
C.A Snowflake database that points directly at an external Iceberg REST catalog for live, zero-copy interoperability with other engines.
D.A Snowflake semi-structured data type that stores JSON, Avro, or XML, queried with path notation and flattened on demand.
26. Which term means: "A Snowflake database that points directly at an external Iceberg REST catalog for live, zero-copy interoperability with other engines."?
A.catalog-linked database — A Snowflake semi-structured data type that stores JSON, Avro, or XML, queried with path notation and flattened on demand.
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.
C.catalog-linked database — A Snowflake database that points directly at an external Iceberg REST catalog for live, zero-copy interoperability with other engines.
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.
A.VARIANT — A Snowflake reference to a cloud storage location (S3, GCS, Azure) used as a source or target for COPY operations.
B.VARIANT — A Snowflake semi-structured data type that stores JSON, Avro, or XML, queried with path notation and flattened on demand.
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.
D.VARIANT — A Snowflake feature that offloads scan-heavy parts of large queries to extra serverless compute, smoothing out skewed or outlier workloads.
Showing 30 of 75 Snowflake questions — the full set, with answers, explanations and an AI tutor on every question, is inside.
Free to start
Answers, AI explanations, and a scored voice mock interview
Sign up free to check your answers with explanations, ask the AI tutor anything on any question, and take one full AI mock interview — scored like a real panel.