SnowPro® Advanced Data Analyst

Duration: Hours



    Training Mode: Online


    The SnowPro Advanced: Data Analyst Certification Exam will test advanced knowledge and skills used to apply comprehensive data analysis principles using Snowflake and its components.


    The SnowPro® Advanced: Data Analyst Certification Exam will test advanced knowledge and skills used to apply comprehensive data analysis principles using Snowflake and its components. This certification will test the ability to:

    • Prepare and load data
    • Perform simple data transformations for data analysis
    • Build and troubleshoot advanced SQL queries in Snowflake
    • Use Snowflake built-in functions and create User-Defined Functions (UDFs)
    • Perform descriptive and diagnostic data analyses
    • Perform data forecasting
    • Prepare and present data to meet business requirements


    1+ year of Snowflake data cloud analytics experience, including practical, hands-on use of the Snowflake Data Cloud. The candidate must hold the SnowPro Core certification in good standing, and should have fluency with advanced SQL.Knowledge of an additional computer language is recommended but not required.

    Target Audience:

    • Snowflake Data Analysts
    • ELT Developers
    • BI Specialists


    Exam Version: DAA-C01
    Total Number of Questions: 65
    Question Types: Multiple Select, Multiple Choice
    Time Limits: 115 minutes
    Language: English
    Registration fee: $375 USD
    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.
    Prerequisites: SnowPro Core Certified
    Delivery Options:

    1. Online Proctoring
    2. Onsite Testing Centers



    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
    1.0 Data Ingestion and Data Preparation15-20%
    2.0 Data Transformation and Data Modeling20-25%
    3.0 Data Analysis30-35%
    4.0 Data Presentation and Data Visualization25-30%


    Outlined below are the Domains & Objectives measured on the exam. To view subtopics, download the exam study guide.






    Domain 1.0: Data Ingestion and Data Preparation

    1.1 Use a collection system to retrieve data.
    1.2 Perform data discovery to identify what is needed from the available datasets.
    1.3 Enrich data by identifying and accessing relevant data from the Snowflake Marketplace.
    1.4 Outline and use best practice considerations relating to data integrity structures.
    1.5 Implement data processing solutions.
    1.6 Given a scenario, prepare data and load into Snowflake.
    1.7 Given a scenario, use Snowflake functions.

    Domain 2.0: Data Transformation and Data Modeling

    2.1 Prepare different data types into a consumable format.
    2.2 Given a dataset, clean the data.
    2.3 Given a dataset or scenario, work with and query the data.
    2.4 Use data modeling to manipulate the data to meet BI requirements.
    2.5 Optimize query performance.

    Domain 3.0: Data Analysis

    3.1 Use SQL extensibility features.
    3.2 Perform a descriptive analysis.
    3.3 Perform a diagnostic analysis.
    3.4 Perform forecasting.

    Domain 4.0: Data Presentation and Data Visualization

    4.1 Given a use case, create reports and dashboards to meet business requirements.
    4.2 Given a use case, maintain reports and dashboards to meet business requirements.
    4.3 Given a use case, incorporate visualizations for dashboards and reports.


    There are no reviews yet.

    Be the first to review “SnowPro® Advanced Data Analyst”

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