Snowflake Editions
Snowflake sells four editions, each a strict superset of the previous: Standard, Enterprise, Business Critical, and Virtual Private Snowflake (VPS). The edition determines which features exist in the account and the credit price. The exam tests feature-to-edition mapping relentlessly.
The edition ladder
- EDITION 1Standardincludes:· 1-day Time Travel· 7-day Fail-safe· Secure data sharing
- EDITION 2Enterpriseadds:· Multi-cluster warehouses· Time Travel to 90 days· Masking + row access· Materialized views· Search Optimization
- EDITION 3Business Criticaladds:· Tri-Secret Secure· Private connectivity· Failover / failback· HIPAA, PCI DSS
- EDITION 4VPSadds:· Dedicated environment· Own metadata store
each step includes everything above it, and costs more per credit
Everything a working warehouse needs: full SQL, 1-day Time Travel, 7-day Fail-safe, encryption everywhere, secure data sharing. Most trial accounts and small teams start here and outgrow it the moment they need multi-cluster warehouses or governance policies.
The edition almost every production account with real BI traffic ends up on. Unlocks multi-cluster warehouses (concurrency), materialized views, Search Optimization, Query Acceleration (performance), 90-day Time Travel, and column masking + row access policies (governance). If a scenario mentions scaling to hundreds of concurrent users or masking a column for an analyst role, the floor is here.
Everything Enterprise has, plus what regulated industries need to pass an audit: Tri-Secret Secure (a customer-held key woven into Snowflake's own key), private connectivity (AWS PrivateLink, Azure Private Link, GCP PSC, no traffic over the public internet), and database failover/failback for disaster recovery. HIPAA, PCI-DSS, and FedRAMP-class workloads live here.
A completely separate Snowflake environment, dedicated metadata store, no shared components with any other account, even other Business Critical ones. Still cloud SaaS, still fully managed by Snowflake: "virtual private" describes isolation from other tenants, not a move to on-premises hardware.
The full feature matrix
| Capability | Standard | Enterprise | Business Critical | VPS |
|---|---|---|---|---|
| Complete SQL warehouse, Time Travel 1 day | ✓ | ✓ | ✓ | ✓ |
| Fail-safe (7 days), encryption everywhere, secure data sharing | ✓ | ✓ | ✓ | ✓ |
| Time Travel up to 90 days | ✗ | ✓ | ✓ | ✓ |
| Multi-cluster warehouses | ✗ | ✓ | ✓ | ✓ |
| Materialized views, Search Optimization Service, Query Acceleration | ✗ | ✓ | ✓ | ✓ |
| Column-level security (dynamic masking, external tokenization) & row access policies | ✗ | ✓ | ✓ | ✓ |
| Periodic rekeying (re-encrypts data under keys retired over a year ago) | ✗ | ✓ | ✓ | ✓ |
| Tri-Secret Secure (customer-managed key in the composite master key) | ✗ | ✗ | ✓ | ✓ |
| Private connectivity (AWS PrivateLink, Azure Private Link, GCP PSC) | ✗ | ✗ | ✓ | ✓ |
| HIPAA / PCI-DSS / FedRAMP-class compliance support | ✗ | ✗ | ✓ | ✓ |
| Database failover/ | ✗ | ✗ | ✓ | ✓ |
| Dedicated, fully isolated Snowflake environment | ✗ | ✗ | ✗ | ✓ |
Three clarifications. First, replication of databases is available broadly across editions, but failover and failback (promoting the replica) start at Business Critical. Second, VPS is still Snowflake-managed SaaS in the cloud; "virtual private" means a completely isolated environment with a dedicated metadata store, not on-premises hosting. Third, key rotation and rekeying differ. In every edition, Snowflake retires its keys once they're 30 days old, and a retired key only decrypts the data it already protects. Periodic rekeying, Enterprise and up and turned on by ACCOUNTADMIN, re-encrypts data whose retired key is more than a year old.
Editions also price differently
The same credit costs more as you climb: roughly a 1x / 1.5x / 2x ladder from Standard to Enterprise to Business Critical on the published on-demand price list, with exact figures varying by cloud and region. Upgrading an edition therefore raises the price of every warehouse-second you already burn, which is why real accounts justify Business Critical with a compliance requirement rather than a feature wish. The exam doesn't test the multipliers, but knowing the credit price rises per edition explains why "just upgrade" is never the free answer a distractor implies.
- "Which edition first offers multi-cluster warehouses / materialized views / masking / row access policies?" → Enterprise, every time.
- "Which feature of Business Critical addresses strict data regulations?" → Tri-Secret Secure. Distractors will offer "Customer-Managed Keys" (a component, not the feature name), "Snowflake VPC" (not a real thing; private connectivity uses the cloud provider's private link), or invented features like "fail-open Time Travel."
- Time Travel: Standard allows 0 or 1 day, and 1 is the default. Enterprise and higher allow 0 to 90 days on permanent objects. Fail-safe is always 7 days and never configurable, on any edition.
S-E-B-V: "Start, Expand, Bunker, Vault." Standard to start. Enterprise to expand (scale features: multi-cluster, 90-day Time Travel, materialized views, governance policies). Business Critical is the bunker (regulated data: Tri-Secret, private links, failover). VPS is the vault (your own isolated Snowflake). If a question smells of compliance or disaster recovery, the floor is Business Critical; if it smells of scaling or governance policies, the floor is Enterprise.
- Enterprise unlocks scale + governance: multi-cluster, 90-day Time Travel, materialized views, masking, row access policies, search optimization.
- Business Critical unlocks compliance + DR: Tri-Secret Secure, private connectivity, failover/failback.
- VPS = maximum isolation, still cloud SaaS, never on-prem.

