Master key concepts with interactive flashcards
What are the 3 main layers of Snowflake's architecture and what does each do?
Click to reveal answer
1. **Cloud Services Layer** — Authentication, metadata, query optimization, transaction management (runs all the time, no shutdown) 2. **Virtual Warehouse Layer** — MPP compute clusters that execute queries; auto-suspend and auto-resume 3. **Database Storage Layer** — Data stored in cloud storage (S3/Azure Blob/GCS) as compressed, encrypted micro-partitions Key: These layers are decoupled — compute and storage scale independently.
Click to show question
SnowPro Core is a Snowflake certification. These facts come from the current exam guide and are the numbers to plan around.
| Domain | Weight | What to focus on |
|---|---|---|
| Snowflake AI Data Cloud Features & Architecture | 25% | Multi-cluster shared data architecture, Separation of storage and compute, Cloud layers: Storage, Compute, Cloud Services |
| Account Access and Security | 17% | Authentication: MFA, SSO/SAML, key pair, OAuth, Role-based access control (RBAC) and privilege management, System-defined roles: ACCOUNTADMIN, SYSADMIN, SECURITYADMIN, PUBLIC |
| Data Transformations | 17% | DML: INSERT, UPDATE, DELETE, MERGE, DDL: CREATE, ALTER, DROP, CLONE, Transaction management: BEGIN, COMMIT, ROLLBACK |
| Performance Concepts |
| 15% |
| Query profile and execution details, Caching layers: metadata cache, result cache, warehouse (local disk) cache, Clustering keys and micro-partition pruning |
| Data Loading and Unloading | 15% | Internal stages: user stage (@~), table stage (@%), named internal stage, External stages: Amazon S3, Azure Blob Storage, Google Cloud Storage, COPY INTO <table> command and options |
| Data Protection and Data Sharing | 11% | Time Travel: retention period (0-90 days), AT and BEFORE syntax, Fail-Safe: 7-day period after Time Travel expiration (Enterprise+), Zero-copy cloning for tables, schemas, databases |
Yes. You can start COF-C03 practice and flashcards free without creating an account. A free account keeps your progress, and the full bank (300+ questions) unlocks with a subscription.
They cover all 6 domains of the COF-C03 exam: Snowflake AI Data Cloud Features & Architecture (25%), Account Access and Security (17%), Data Transformations (17%), Performance Concepts (15%), Data Loading and Unloading (15%), Data Protection and Data Sharing (11%). Each section is weighted in the same proportion as the real exam, so nothing high-value is buried.
The COF-C03 exam has approximately 100 questions in 115 minutes, with a passing score of 750. Use the practice questions to confirm you are consistently above that line before booking the real exam.
Study in short, spaced sessions: a card you have not seen for two days is worth more than a card you reread immediately. Filter by Snowflake AI Data Cloud Features & Architecture first, then mix domains so you practise identifying the topic before recalling the definition.
They are the recall half of preparation. Pair the cards with practice questions and at least one timed practice exam — candidates who only review cards usually recognise terms but miss scenario questions.