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.
Invest now in Acorns!!! 🚀
Join Acorns and get your $5 bonus!
Acorns is a micro-investing app that automatically invests your "spare change" from daily purchases into diversified, expert-built portfolios of ETFs. It is designed for beginners, allowing you to start investing with as little as $5. The service automates saving and investing. Disclosure: I may receive a referral bonus.
Invest now!!! Get Free equity stock (US, UK only)!
Use Robinhood app to invest in stocks. It is safe and secure. Use the Referral link to claim your free stock when you sign up!.
The Robinhood app makes it easy to trade stocks, crypto and more.
Webull! Receive free stock by signing up using the link: Webull signup.
More Related questions...
