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


The SnowPro™ Advanced: Architect will validate advanced knowledge and skills 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 data 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 Data 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 Architect
  • Database Architects
  • System Architect
  • Senior Consultants



SnowPro Badge

Number of Questions: 65

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. 

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

Time Limit: 115 minutes

Languages: English

Registration fee: $375 USD 

Passing Score: 750 + on Scaled Scoring from 0 - 1000

Delivery Options: 

  1. Online Proctoring - Webassesor 
  2. Onsite Kryterion Testing Centers

Prerequisites: SnowPro Core Certified


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. 



Percentage Range on Exam Questions

1.0 Accounts and Security

25 - 30%

2.0 Snowflake Architecture

20 - 25% 

3.0 Data Engineering

15 - 20%

4.0 Performance Optimization

20 - 25%



 1.0 Account and Security

1.1 Design a Snowflake account and database strategy, based on business requirements.

  • Create and configure Snowflake parameters based on a central account and any additional accounts.
  • List the benefits and limitations of one Snowflake account as compared to multiple Snowflake accounts.

1.2 Design an architecture that meets data security, privacy, compliance, and governance requirements.

  • Configure Role Based Access Control (RBAC) hierarchy
  • System roles and associated best practices
  • Data Access
  • Data Security
  • Compliance

1.3 Outline Snowflake security principles and identify use cases where they should be applied.

  • Encryption 
  • Network security
  • User, Role, Grants, Provisioning
  • Authentication


2.0 Snowflake Architecture 

2.1 Outline the benefits and limitations of various data models in a Snowflake environment. 

  • Data models

2.2 Design data sharing solutions, based on different use cases.

  • Use Cases
    • Sharing within the same organization/same Snowflake account
    • Sharing within a cloud region
    • Sharing across cloud regions
    • Sharing between different Snowflake accounts 
    • Sharing to a non-Snowflake customer
    • Sharing Across platforms 
  • Data Marketplace
  • Data Exchange
  • Data Sharing Methods


 2.3 Create architecture solutions that support Development Lifecycles as well as workload requirements.

  • Data Lake and Environments
  • Workloads
  • Development lifecycle support

2.4 Given a scenario, outline how objects exist within the Snowflake Object hierarchy and how the hierarchy impacts an architecture. 

  • Roles
  • Warehouses
  • Object hierarchy
  • Database

2.5 Determine the appropriate data recovery solution in Snowflake and how data can be restored

  • Backup/Recovery
  • Disaster Recovery

3.0 Data Engineering

3.1 Determine the appropriate data loading or data unloading solution to meet business needs.

  • Data sources
  • Ingestion of the data
  • Architecture Changes 
  • Data unloading

3.2 Outline key tools in Snowflake’s ecosystem and how they interact with Snowflake. 

  • Connectors
    • Kafka
    • Spark
    • Python
  • Drivers
    • JDBC
    • ODBC
  • API endpoints
  • SnowSQL

3.3 Determine the appropriate data transformation solution to meet business needs.

  • Materialized Views, Views and Secure Views
  • Staging layers and tables
  • Querying semi-structured data
  • Data processing
  • Stored Procedures
  • Streams and Tasks
  • Functions
    • External Functions
    • User-Defined Functions

4.0 Performance Optimization  

4.1 Outline performance tools, best practices, and appropriate scenarios where they should be applied.

  • Query profiling
  • Virtual Warehouse configuration
  • Clustering
  • Search Optimization
  • Caching
  • Query rewrite
  • Query Acceleration 


4.2 Troubleshoot performance issues with existing architectures.

  • JOIN explosions
  • Warehouse selection (scalomg up as compared to scaling out)
  • Best practices and optimization techniques
  • Duplication of data
  • Monitoring and Alerting



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.