CertSafari

    Snowflake SnowPro Core Certification (COF-C03) Lessons

    19 lessons, one per exam-guide subdomain, in the order the guide teaches them. Every claim is cited to the official documentation.

    Domain 1: Snowflake AI Data Cloud Features and Architecture

    6 lessons · 31% of the exam

    1. 1.1Snowflake Architecture: Storage, Compute and Cloud Services Layers

      Subdomain 1.1: Describe and use the Snowflake architecture

      2 pages · 16 min read

    2. 1.2Snowsight: the Snowflake web interface

      Subdomain 1.2: Use Snowflake Interfaces and tools

      2 pages · 20 min read

    3. 1.3Snowflake Object Hierarchy: Organization, Account, Database and Schema Objects

      Subdomain 1.3: Differentiate Snowflake object hierarchy and types

      2 pages · 21 min read

    4. 1.4Snowflake Warehouse Types, Sizing and Auto-Suspend

      Subdomain 1.4: Configure virtual warehouses

      2 pages · 22 min read

    5. 1.5Snowflake Micro-partitions, Pruning and Clustering Keys

      Subdomain 1.5: Explain Snowflake storage concepts

      3 pages · 28 min read

    6. 1.6Snowpark, Notebooks, Streamlit and Snowflake ML

      Subdomain 1.6: Explain AI/ML and application development features

      2 pages · 20 min read

    Domain 2: Account Management and Data Governance

    3 lessons · 20% of the exam

    1. 2.1Snowflake Access Control: DAC, RBAC, and Roles

      Subdomain 2.1: Explain Snowflake security model and principles

      2 pages · 24 min read

    2. 2.2Snowflake Data Masking, Row Access Policies, Tags and Privacy Policies

      Subdomain 2.2: Define data governance features and how they are used

      2 pages · 25 min read

    3. 2.3Snowflake Resource Monitors: Credit Quotas, Schedules and Actions

      Subdomain 2.3: Explain monitoring and cost management

      2 pages · 18 min read

    Domain 3: Data Loading, Unloading, and Connectivity

    3 lessons · 18% of the exam

    1. 3.1Snowflake Stages and File Formats: Internal, External, Encryption, Directory Tables

      Subdomain 3.1: Perform data loading and unloading

      2 pages · 23 min read

    2. 3.2Snowpipe and Snowpipe Streaming: Continuous Loading into Snowflake

      Subdomain 3.2: Perform automated data ingestion

      2 pages · 24 min read

    3. 3.3Snowflake Drivers and Connectors: JDBC, ODBC, Python, Kafka and Spark

      Subdomain 3.3: Identify the different Snowflake Connectors and integrations

      2 pages · 21 min read

    Domain 4: Performance Optimization, Querying, and Transformation

    4 lessons · 21% of the exam

    1. 4.1Query Profile and Query Insights: Spillage, Pruning and Exploding Joins

      Subdomain 4.1: Evaluate query performance

      2 pages · 22 min read

    2. 4.2Query Acceleration and Search Optimization in Snowflake

      Subdomain 4.2: Optimize query performance

      2 pages · 20 min read

    3. 4.3Snowflake query result cache: reuse rules, invalidation and RESULT_SCAN

      Subdomain 4.3: Use Snowflake caching

      2 pages · 23 min read

    4. 4.4Transforming Structured, Semi-Structured and Unstructured Data in Snowflake

      Subdomain 4.4: Perform data transformation techniques

      2 pages · 25 min read

    Domain 5: Data Collaboration

    3 lessons · 10% of the exam

    1. 5.1Snowflake Time Travel, Fail-safe and Zero-Copy Cloning

      Subdomain 5.1: Explain data collaboration and protection

      2 pages · 18 min read

    2. 5.2Snowflake Secure Data Sharing: Providers, Consumers and Reader Accounts

      Subdomain 5.2: Explain Snowflake's data sharing capabilities

      2 pages · 20 min read

    3. 5.3Snowflake Marketplace and Listings: Private, Public, Free, Trial and Paid

      Subdomain 5.3: Share data using the Snowflake Marketplace and listings

      2 pages · 19 min read

    Practice Snowflake SnowPro Core Certification (COF-C03) in quiz mode