SnowPro Advanced: Architect Exam Guide

INTRODUCING SNOWFLAKE TRAINING FUNDS ➤  Learn more HERE. To purchase, contact us.  COVID-19 UPDATES ➤   Instructor-led classes will be delivered via virtual classroom only.

SnowPro Advanced: Architect Exam Guide


A SnowPro™ Advanced: Architect has demonstrated specific knowledge and skills related to the design, development and implementation of Snowflake solutions. This certification validates a candidate’s application of Snowflake best practices, advanced tuning, and real world deployment scenarios by successfully passing the SnowPro™ Advanced: Architect certification exam.



The SnowPro™ Advanced: Architect is designed for individuals who would like to demonstrate their knowledge and skills in Snowflake's unique architecture as a Cloud Data Platform specifically with Data Movement, Performance, Security, Agile Development and Data Sharing design considerations.

The candidate should be able to: 

  • Develop a methodology for performance tuning
  • Design a comprehensive program for ensuring user, network & data security
  • Evaluate Snowflakes advanced architectural concepts
  • Employ strategies and best practices for agile development
  • Discuss Snowflakes various ingestion methods 

Target Audience: 

  • Solution Architects 
  • Database Architects

We recommend individuals have at least 2 + years of hands-on Snowflake Practitioner experience in an Architect role prior to attempting this exam. 



SnowPro Badge

Number of Questions: 60

Question Types: Multiple Select, Multiple Choice, True/False

Time Limite: 90 minutes

Languages: English 

Prerequisites: SnowPro Core Certified

Passing Score: 70% + 

Delivery Options: Proctored exams delivered onsite at Kryterion Testing Centers or via Webassessor's online proctored environment. 

Click here for information on scheduling your exam. 




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 weighting ranges. 



Estimated Percentage Range 

Account and Security

5 - 10%

Connectors & Drivers

3 - 5%

Data Movement

20 - 25%

Data Sharing

8 - 10%

Performance and Tuning 

15  -20%

Snowflake Overview & Architecture

25 - 30%

Storage and Protection

5 - 10%



 1.0 Account and Security

1.1 Account

  • Understanding account parameter and the impact of settings

1.2 Security 

  • Explain the access control framework
  • Required privileges for tasks, shares, statements to research Role Based Access Control structures
  • Role Hierarchy and Privilege Inheritance


2.0 Connectors & Drivers

2.1 Connectors 

  • Kafka 
    • Basic configuration and access privileges for the kafka connector 

2.2 Drives

  • Identifying the various client drivers available to connect to Snowflake 


3.0 Data Movement 

3.1 Data Loading & Data Unloading

  • List best practices and the impact of different scenarios 
    • Formats
    • File number 
    • File size
    • Warehouse sizes

3.2 Continuous Data Loads Using Snowpipe

  • Outline how Snowpipe is different from Bulk Data loading
  • SQL syntax to create a pipe

3.3 Streams & Tasks

  • Working with Streams and Tasks
    • Limitations
    • Rest API endpoints
    • Billing
  • SQL Syntax to create and clone a Stream and Task

4.0 Data Sharing  

4.1 Data sharing

  • Capabilities of data sharing


  • Create and configure shares
  • Privileges required to work with shares

4.3 Secure views


5.0 Performance and Tuning 

5.1 Clustering

  • Outline clustering best practices and appropriate usage
    • Evaluate overlap and depth 
    • Data types
    • Cardinality
    • Policies
    • Auto-clustering

5.2 Materialized Views

  • Outline the benefits of Materialized view, the corresponding properties, downsides, and limitations
  • Identify use-cases when to use a Materialized view
  • Explain the use-case for Materialized views with External Tables

5.3 Query Profiles & Tuning

  • Retrieve and interpret query profiles, identify bottlenecks, and outline recommendations
  • Given a scenario, determine methods to cut down query processing time.
  • Outline caching

5.4 Warehouse

  • Identify performance guidelines and best practices for using warehouses in Snowflake to process queries
  • Using Warehouses to optimize query performance



6.0 Snowflake Overview and Architecture 

6.1 Snowflake Architecture

  • Outline key components of Snowflake’s architecture 
    • Layers
    • Caches
  • Differentiate Snowflake and other paradigms
    • Shared disk 
    • Shared nothing
  • Snowflake’s securable object hierarchy

6.2 SQL Syntax

  • Querying metadata
    • Stage
    • Cluster information
    • Timestamps
    • Identifiers
    • Data types


7.0 Storage and Protection 

7.1 Time Travel

  • Define Time Travel feature 
    • Data retention periods
    • Differences between Snowflake Editions
    • Querying historical data
    • Impact of cloning and restoring objects
    • Underlying Storage concepts
  • Snowflake’s Continuous Data Protection Lifecycle

7.2 Data Replication and Failover

  • Explain Replication and outline features 
    • Cross cloud
    • Cross region
    • Objects that are replicated
  • How it can be used for Business Continuity

7.3 Clones

  • Working with clones
  • Creating new tables 
  • Compare command usage
    • Create table like
    • Create table as select
    • Clone
    • Copy grants

7.4 Semi-Structured Data




We recommend individuals have at least 2 + years of hands-on Snowflake Practitioner experience in an Architect role prior to attempting this exam. The exam will assess skills through scenario based questions and real world examples. As preparation for this exam, we recommend a combination of hands-on experience, instructor-led training and the utilization of self-study assets.


Instructor-Led Course recommended for this exam: 

Free Self Study recommended for this exam: 



Ready to register? Click here for information on scheduling your exam.