Raj Cloud Technologies
Back to blog
SNOWFLAKE · INTERVIEW

Snowflake — Interview Questions

A 200+ question bank covering Snowflake architecture, micro-partitions, Time Travel, caching, masking, streams, tasks, dynamic tables, data sharing and dbt-on-Snowflake — the depth panels probe in 2026.

27 May 2026· 45 min read·by Nataraj Virupaksham (Raj)
Note
Combined Sets 01, 02, 03 and 05 of the Snowflake interview-questions series originally published on blogs.rajcloudtech.com. ~240 questions across architecture, performance, caching, masking, streams, tasks, dynamic tables, ingestion, file formats and dbt-on-Snowflake.

Set 01 — Architecture, releases, stages, Snowpipe

Set 02 — Scaling, tables, caches, Time Travel, Fail-safe

Set 03 — Micro-partitions, access methods, warehouse layer

Set 05 — Architecture, Time Travel, cloning, ingestion, security, streams, tasks, dynamic tables, dbt

Note
Set 05 is the deepest of the series — 200 questions across architecture, performance, caching, masking, streams, tasks, dynamic tables, file formats, ingestion and dbt-on-Snowflake.

Architecture & fundamentals

Caching deep dive

Tables, Time Travel, cloning

Data ingestion, stages, file formats

Dynamic data masking & row-level security

Streams & change data capture

Tasks & orchestration

UDFs & stored procedures

Micro-partitions & clustering

External tables, dynamic tables, views

Data sharing

Row access policies

Semi-structured data & JSON

dbt on Snowflake

Related posts

Interview Questions

AWS Cloud — Interview Questions (Set 01)

AWS interview questions across EC2, S3, VPC, IAM, Lambda, Auto Scaling, ELB, CloudFront and more — with the exact answers panels score on.

27 May 2026·AWS DE
Interview Questions

Informatica IICS / IDMC (CDI) — Interview Questions

Cloud Data Integration (CDI) interview questions panels ask for IDMC migration roles — with framework-style answers.

27 May 2026·IICS / IDMC
Materials

Data Warehouse — Study Materials

Foundational reference for data warehousing — BI components, operational vs analytical data, dimensional modelling, star vs snowflake schemas, SCD types, ETL architecture, and design approaches.

18 Nov 2023