Course contents

SnowPro Core COF-C03 Study GuidePart 1: ArchitectureSnowflake Editions

Snowflake Editions

Snowflake Editions

Definition

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

Snowflake editions as a staircase, left to right. Each edition includes everything in the editions to its left. Standard: 1 day of Time Travel, 7-day Fail-safe, secure data sharing. Enterprise adds multi-cluster warehouses, up to 90 days of Time Travel, masking and row access policies, materialized views, Search Optimization and Query Acceleration. Business Critical adds Tri-Secret Secure, private connectivity, failover and failback, and compliance support such as HIPAA and PCI DSS. Virtual Private Snowflake adds a dedicated, isolated Snowflake environment.EDITION 1Standardincludes:· 1-day Time Travel· 7-day Fail-safe· Secure data sharingEDITION 2Enterpriseadds:· Multi-cluster warehouses· Time Travel to 90 days· Masking + row access· Materialized views· Search OptimizationEDITION 3Business Criticaladds:· Tri-Secret Secure· Private connectivity· Failover / failback· HIPAA, PCI DSSEDITION 4VPSadds:· Dedicated environment· Own metadata storeeach step includes everything to its left, and costs more per credit
  1. EDITION 1Standardincludes:· 1-day Time Travel· 7-day Fail-safe· Secure data sharing
  2. EDITION 2Enterpriseadds:· Multi-cluster warehouses· Time Travel to 90 days· Masking + row access· Materialized views· Search Optimization
  3. EDITION 3Business Criticaladds:· Tri-Secret Secure· Private connectivity· Failover / failback· HIPAA, PCI DSS
  4. EDITION 4VPSadds:· Dedicated environment· Own metadata store

each step includes everything above it, and costs more per credit

Figure 1.8 Editions are a staircase: each step includes everything to its left. Find the lowest step that holds the feature a scenario needs, and that's the minimum edition.
Standardthe floor

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.

Enterprisescale + governance

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.

Business Criticalregulated data

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.

Virtual Private Snowflaketotal isolation

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

CapabilityStandardEnterpriseBusiness CriticalVPS
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/failback for disaster recovery✗✗✓✓
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.

Exam traps
  • "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.
Memory aid

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.

Key takeaways
  • 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.