SnowPro® Advanced Architect

Duration: Hours



    Training Mode: Online


    The SnowPro Advanced: Architect Certification will test advanced knowledge and skills used to to apply comprehensive architect solutions using Snowflake.


    The SnowPro® Advanced: Architect Certification will test advanced knowledge and skills used to apply comprehensive architect solutions using Snowflake. This certification will test the ability to:

    • Design an end-to-end data flow from source to consumption using the Snowflake’s Platform.
    • Design and deploy a data architecture that meets business, security, and compliance requirements.
    • Select appropriate Snowflake and third-party tools to optimize architecture performance.
    • Design and deploy a shared data set using the Snowflake Marketplace and Data Exchange.


    2+ years of practical experience with Snowflake as an Architect in a production environment. In these two years, successful candidates would have achieved hands-on expertise with SQL and SQL analytics, experience building out a complex ETL/ELT pipeline, experience implementing security and compliance requirements, and working with different data modeling techniques. Having coding experience outside of SQL and DevOps/DataOps design experience is a plus.

    Target Audience:

    • •Solution Architects
    • •Database Architects
    • •System Architects


    Exam Version: ARA-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 Accounts and Security25-30%
    2.0 Snowflake Architecture25-30%
    3.0 Data Engineering20-25%
    4.0 Performance Optimization20-25%


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

    Domain 1.0: Accounts and Security

    1.1 Design a Snowflake account and database strategy, based on business requirements.
    1.2 Design an architecture that meets data security, privacy, compliance, and governance requirements.
    1.3 Outline Snowflake security principles and identify use cases where they should be applied.

    Domain 2.0: Snowflake Architecture

    2.1 Outline the benefits and limitations of various data models in a Snowflake environment.
    2.2 Design data sharing solutions, based on different use cases.
    2.3 Create architecture solutions that support Development Lifecycles as well as workload requirements.
    2.4 Given a scenario, outline how objects exist within the Snowflake Object hierarchy and how the hierarchy impacts architecture.
    2.5 Determine the appropriate data recovery solution in Snowflake and how data can be restored.

    Domain 3.0: Data Engineering

    3.1 Determine the appropriate data loading or data unloading solution to meet business needs.
    3.2 Outline key tools in Snowflake’s ecosystem and how they interact with Snowflake.
    3.3 Determine the appropriate data transformation solution to meet business needs.

    Domain 4.0: Performance Optimization

    4.1 Outline performance tools, best practices, and appropriate scenarios where they should be applied.
    4.2 Troubleshoot performance issues with existing architectures.



    There are no reviews yet.

    Be the first to review “SnowPro® Advanced Architect”

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