12 practice questions for Snowflake technical interviews
codingHardVerified
Pipeline Throughput Optimizer
Category: Array coding problem# Question A message-processing pipeline consists of n services that must all be traversed in sequence. The pipeline's effective throughput is...Input: Array Output: Integer
codingHardVerified
[OA] Bounded Transition Subsequence
Category: Array coding problemYou are compressing a color run sequence. Given an array of color IDs and an integer k representing the maximum number of allowed color changes,...Input: Array Output: Integer
codingMediumVerified
[OA] Complete Vowel Substrings
Category: String coding problemGiven a string s, count the number of contiguous substrings that: 1. Consist entirely of vowel characters ('a', 'e', 'i', 'o', 'u') 2....Input: String Output: Integer
codingMediumVerified
[OA] Work Schedule Generator
Category: Graph coding problemA factory uses a shift planning system to schedule worker hours across a 7-day week. Each day is represented as a single character in a pattern...Input: Graph (nodes and edges) Output: Array
codingMediumVerified
API Throttle Manager
Category: Sliding window coding problemDesign an APIThrottleManager for an API gateway that enforces multiple rate-limiting policies simultaneously. Each policy defines a sliding window...Input: Integer(s) Output: Integer
codingMediumVerified
Color Chain Winner
Category: Grid/matrix coding problemYou are implementing a color chain game. Two players take turns placing tokens on a grid. Each cell contains "red", "blue", or "" (empty). A...Input: 2D grid Output: Computed result
codingHardVerified
Inherited Access Rights
Category: String coding problemYou are building an access control system for a company with n departments (numbered 0 to n-1). Departments can inherit access rights from...Input: List Output: Computed result
codingMediumVerified
Longest Prefix Router
Category: String coding problemYou are building a network packet forwarder. Given a routing table and a list of incoming packet source addresses, determine the correct gateway for...Input: List Output: Computed result
codingMediumVerified
Product Sales Ranker
Category: String coding problemDesign a ProductSalesRanker class for an e-commerce platform that tracks cumulative product sales and returns the top-ranked products on demand....Input: List Output: Computed result
codingMediumVerified
Resizable LRU Cache
Category: Trie-based coding problemDesign a ResizableLRUCache for a web server that caches integer key-value responses. The cache has a fixed capacity at creation time but can be...Input: Integer(s) Output: Computed result
codingMediumVerified
Tagged Value Store
Category: Trie-based coding problemDesign a TaggedValueStore for a configuration system that stores string keys mapped to integer values. The store supports standard CRUD operations...Input: List Output: Array
codingHardVerified
Three Frequency Assignment
Category: Graph coding problemYou are assigning radio frequencies to a set of communication towers. To avoid interference, no two towers that directly interfere with each other...Input: Graph (nodes and edges) Output: Computed result
No AI generated questions yet for Snowflake.
Start practicing Snowflake questions
Sign up for free to access walkthroughs, AI-generated questions, and more.