SnowPro Advanced: Architect — Complete Study Guide

The advanced Snowflake architecture cert. Exam format, the domains, the design and performance topics to master, and how to prepare beyond SnowPro Core.

Practice 176 free SnowPro Advanced: Architect questions

Official exam page: https://www.snowflake.com/certifications/

The SnowPro Advanced: Architect certification validates advanced knowledge of designing and deploying scalable, secure and cost-effective solutions on Snowflake. It requires the SnowPro Core certification as a prerequisite and assumes real architecture experience.

Exam at a glance

• Format: ~65 questions (multiple choice, multiple select, scenario)
• Duration: 115 minutes
• Cost: 375 USD
• Passing score: 750 out of 1000 (scaled)
• Prerequisite: active SnowPro Core certification

Confirm the current domain weights and format on the official certifications page.

Domain areas

1. Accounts and Security. Organization and account design, RBAC at scale, network policies, data encryption, secure data sharing and the Marketplace.
2. Snowflake Architecture. Designing databases and schemas, multi-account and multi-region strategies, replication and failover, data governance.
3. Data Engineering. Loading and unloading at scale, transformations, Streams and Tasks, Snowpipe, working with semi-structured data.
4. Performance Optimization. Virtual warehouse strategy, scaling up vs out, clustering keys, micro-partition pruning, query profiling and cost control.

Topics to master

• Security architecture: RBAC hierarchy design, secure views, row access policies, dynamic data masking, network policies
• Replication & DR: database replication, failover/failback, business continuity design
• Performance: clustering keys and when they help, search optimization service, materialized views, query profile interpretation
• Data sharing: secure data sharing, reader accounts, the Marketplace, data clean rooms
• Cost design: warehouse sizing and multi-cluster policies, resource monitors

A study plan

• Week 1: Security and account architecture (RBAC, masking, row access policies).
• Week 2: Replication, failover and multi-region design.
• Week 3: Performance optimization and cost control.
• Week 4: Data engineering (Streams/Tasks, Snowpipe) and full practice exams.

Exam-day tips

• Expect scenario questions that ask for the best design given cost, security and performance constraints.
• Know clustering, search optimization and materialized views — and when each is appropriate.
• Be precise on replication/failover and secure data sharing mechanics.

Practice now

Use the free SnowPro Advanced: Architect questions below, focusing on security architecture and performance optimization.