SnowPro® Core Certification

Duration: Hours



    Training Mode: Online


    SnowPro® Core Certification Overview:

    The SnowPro Core Certification demonstrates an individual’s knowledge to apply specific core expertise implementing and migrating to Snowflake. A SnowPro Core Certified individual has a thorough understanding of the Snowflake’s Platform, and has the knowledge necessary to design, develop, and manage secure, scalable Snowflake solutions to drive business objectives.

    The SnowPro® Core Certification is designed for individuals who would like to demonstrate their knowledge of the Snowflake Data Cloud.

    The candidate has a thorough knowledge of:

    1. Data Loading and Transformation in Snowflake.
    2. Virtual Warehouse Performance and Concurrency
    3. DDL and DML Queries
    4. Using Semi-Structured and Unstructured Data
    5. Cloning and Time Travel
    6. Data Sharing
    7. Snowflake Account Structure and Management

    SnowPro® Core Candidate:

    6 months + of practical experience with Snowflake.

    Exam Format:

    1. Exam Version: COF-C02
    2. Total Number of Questions: 100
    3. Question Types: Multiple Select, Multiple Choice
    4. Time Limit: 115 minutes
    5. Languages: English & Japanese
    6. Registration fee: $175 USD
    7. Passing Score: 750 + Scaled Scoring from 0 – 1000

    Unscored Content:

    Exams may include unscored items to gather statistical information for future use. These items are not identified on the form and do not impact your score, and additional time is factored into account for this content.


    No prerequisites

    Delivery Options:

    1. Online Proctoring
    2. Onsite Testing Centers

    Exam Domain Breakdown:

    This exam guide includes test domains, weightings, and objectives. It is not a comprehensive listing of all the content that will be presented on this examination. The table below lists the main content domains and their weightings.

    DomainDomain Weightings on Exams
    Snowflake Data Cloud Features & Architecture25%
    Account Access and Security20%
    Performance Concepts15%
    Data Loading and Unloading10%
    Data Transformations20%
    Data Protection and Data Sharing10%


    To view exam domain, objectives and sub objectives, download the SnowPro Core Exam Study Guide.

    – Outline key features of the Snowflake Data Cloud.

    1. Elastic Storage
    2. Elastic Compute
    3. Snowflake’s three distinct layers
    4. Cloud partner categories
    5. Overview of Snowflake editions

    – Outline key Snowflake tools and user interfaces.

    1. Snowsight
    2. SnowSQL
    3. Snowflake connectors
    4. Snowflake drivers
    5. Snowpark
    6. SnowCD

    – Outline Snowflake’s catalog and objects.

    Snowflake Data Cloud Features And Architectures

    1. Databases
    2. Stages
    3. Schema types
    4. Table types
    5. View types
    6. Data types
    7. User-Defined Functions (UDFs)
    8. User Defined Table Functions (UDTFs)
    9. Stored Procedures
    • Streams
    • Tasks
    • Pipes
    • Shares
    • Sequences

    – Outline Snowflake storage concepts.

    1. Micro-partitions
    2. Data clustering
    3. Data Storage Monitoring

    – Outline security principles.

    1. Network security and policies
    2. Multi-Factor Authentication (MFA)
    3. Federated authentication
    4. Key pair authentication
    5. Single Sign-On (SSO)

    – Define the entities and roles that are used in Snowflake.

    Overview of access control

    – Access control frameworks

    – Access control privileges

    1. Outline how privileges can be granted and revoked
    2. Explain role hierarchy and privilege inheritance

    Account Access and Security

    – Outline data governance capabilities in Snowflake.

    1. Accounts
    2. Organizations
    3. Secure views
    4. Secure functions
    5. Information schemas
    6. Access history

    – Tracking read/write operations

    1. Overview of row/column-level security
    2. Object tags

    – Explain the use of the Query Profile.

    1. Explain plans
    2. Data spilling
    3. Use of the data cache
    4. Micro-partition pruning
    5. Query history

    – Explain virtual warehouse configurations.

    1. Types of warehouses
    2. Multi-clustering warehouses

    – Scaling policies

    – Scaling modes

    1. Warehouse sizing
    2. Warehouse settings and access

    – Outline virtual warehouse performance tools.

    Performance Concepts

    1. Monitoring warehouse loads
    2. Scaling up compared to scaling out
    3. Resource monitors
    4. Query acceleration service

    – Optimize query performance.

    1. Describe the use of materialized views
    2. Use of specific SELECT commands
    3. Clustering
    4. Search optimization service
    5. Persisted query results
    6. Understanding the impact of different types of caching

    – Metadata cache

    – Result cache

    – Warehouse cache

    – Define concepts and best practices that should be considered when loading data.

    1. Stages and stage types
    2. File size and formats
    3. Folder structures
    4. Ad hoc/bulk loading
    5. Snowpipe

    – Outline different commands used to load data and when they should be used.

    5. COPY INTO
    7. PUT

    Data Loading and Unloading

    – Define concepts and best practices that should be considered when unloading data

    File size and formats

    – Overview of compression methods

    1. Empty strings and NULL values
    2. Unloading to a single file
    3. Unloading relational tables

    – Outline the different commands used to unload data and when they should be used.

    1. GET
    2. LIST
    3. COPY INTO

    – Explain how to work with standard data.

    1. Data Transformations
    2. Estimation functions
    3. Sampling

    – SAMPLE command

    – /TABLESAMPLE command

    – Sampling methods



    Supported function types

    – System functions

    – Table functions

    – External functions

    – User-Defined Functions (UDFs)

    1. Stored procedures
    2. Streams
    3. Tasks

    Data Transformations

    – Explain how to work with semi-structured data.

    1. Supported data formats, data types, and sizes
    2. VARIANT column
    3. Flattening the nested structure

    – FLATTEN command

    – LATERAL FLATTEN command

    Semi-structured data functions

    – ARRAY/OBJECT creation and manipulation

    – Extracting values

    – Type predicates

    – Explain how to work with unstructured data.

    1. Define and use directory tables
    2. SQL file functions

    – Types of URLs available to access files

    Outline the purpose of User-Defined Functions (UDFs) for data analysis

    – Outline Continuous Data Protection with Snowflake.

    1. Time Travel
    2. Fail-safe
    3. Data Encryption
    4. Cloning
    5. Replication

    Data Protection and Data Sharing

    – Outline Snowflake data sharing capabilities.

    1. Account types
    2. Snowflake Marketplace
    3. Data exchange
    4. Access control options

    – DDL commands to create and manage shares

    – Privileges required for working with shares

    Secure Data Sharing (for example, Direct Share, Listing)

    For more information on SnowPro® Core Certification; please visit here.

    Contact Locus IT support team for further training details.


    There are no reviews yet.

    Be the first to review “SnowPro® Core Certification”

    Your email address will not be published. Required fields are marked *