Database / Snowflake Interview Questions
What is the Snowflake Cloud Services layer and what components does it manage?
The Cloud Services layer is Snowflake's always-on intelligence layer. It runs within Snowflake's managed infrastructure — not on customer-provisioned resources — and coordinates everything before and after a Virtual Warehouse executes a query. It is billed only when its daily consumption exceeds 10% of compute credits; in most workloads this threshold is never crossed.
The six primary components it manages:
- Query Parser and Optimizer — parses SQL, resolves names, builds the execution plan, and selects which micro-partitions to scan via partition pruning.
- Metadata Service — stores min/max column values, null counts, row counts, and distinct value estimates per micro-partition for every table. Enables partition pruning and zero-credit COUNT(*) answers.
- Authentication and Authorization — handles logins (password, key-pair, OAuth, SAML/SSO) and all RBAC privilege checks before a query touches any data.
- Transaction Manager — enforces ACID semantics, manages multi-statement transactions, and maintains snapshot isolation for concurrent readers and writers.
- Infrastructure Manager — provisions and monitors Virtual Warehouse compute nodes; drives auto-suspend and auto-resume events.
- Security Service — manages the hierarchical AES-256 key model, handles Tri-Secret Secure key requests, and enforces column and row security policies at query runtime.
More Related questions...