Snowflake

SnowPro Advanced: Administrator Complete Guide — Operations & Security

2026-03-26
Updated: 2026-10-13
NicheeLab Editorial Team
Table of contents
  1. Exam Overview
  2. Exam Domains and Weights
  3. Key Security Management Topics
  4. Resource Monitoring
  5. Cost Management
  6. Data Governance
  7. Study Strategy
  8. Check Your Understanding
  9. Frequently Asked Questions

The SnowPro Advanced: Administrator Certification validates advanced knowledge of Snowflake account operations, security design, and cost optimization. It comprehensively tests features administrators use every day: network policies, RBAC, MFA/SSO, Resource Monitor, and ACCOUNT_USAGE views. This article walks through the exam overview, domains, and key study points for each topic.

Exam Overview

ItemDetails
Exam codeADA-C02
Questions65 (multiple choice, multiple select, and interactive)
Duration115 minutes
Passing score750 / 1000
Exam fee$375 USD
PrerequisiteActive SnowPro Core certification
DeliveryPearson VUE (test center or online)
Validity2 years
Recommended experience2+ years of hands-on Snowflake administration
LanguageEnglish only

Exam Domains and Weights

These are the six domains listed on the official exam page and in the Study Guide (ADA-C02, last updated December 1, 2025).

DomainWeightKey Topics
1.0 Snowflake Security, RBAC, and User Administration31%Administrative roles (ORGADMIN/ACCOUNTADMIN), DAC/RBAC/UBAC, custom roles, database roles and future grants, SSO/SAML, OAuth, MFA and key-pair authentication, network rules/policies and private connectivity, SCIM
2.0 Account Management & Data Governance18%Organization and account management, Tri-Secret Secure and encryption key rotation, masking policies, external tokenization and row access policies, tagging and data classification, ACCESS_HISTORY, Trust Center and Horizon Catalog
3.0 Data and Object Management15%Warehouse configuration (auto-suspend, multi-cluster), tables and views (external and Iceberg tables), cloning, storage integrations, tasks, Snowsight dashboards
4.0 Performance Monitoring & Tuning20%Query Profile, caching, spilling and pruning; search optimization, query acceleration and materialized views; DML locking; resource monitors; event tables (logging and tracing); cost management with ACCOUNT_USAGE and ORGANIZATION_USAGE
5.0 Data Sharing and Snowflake Marketplace7%Creating and managing shares, secure views and secure UDFs, reader accounts, cross-region and cross-cloud sharing, Data Clean Rooms, Marketplace listings
6.0 Disaster Recovery, Backup & Data Replication9%Database and account replication, replication groups and failover groups, failover/failback, client redirect, Time Travel and Fail-safe

Key Security Management Topics

RBAC (Role-Based Access Control)

Snowflake's access control combines RBAC (Role-Based Access Control) with DAC (Discretionary Access Control). The most important exam topics are role hierarchy design and how GRANT statements behave.

Default RoleKey PrivilegesManages
ACCOUNTADMINAll privileges (SYSADMIN + SECURITYADMIN)Entire account; creates Resource Monitors
SECURITYADMINMANAGE GRANTS privilegeRoles, users, and privilege management
SYSADMINCREATE DATABASE/WAREHOUSEDatabases, schemas, and warehouses
USERADMINCREATE USER/ROLECreating users and roles
PUBLICBasic access privilegesAutomatically granted to every user

Best practice is to place custom roles under SYSADMIN. If a custom role is not in SYSADMIN's hierarchy, system administrators (SYSADMIN) cannot manage the objects it owns. Only roles granted the MANAGE GRANTS privilege (by default, only SECURITYADMIN) can view those objects and modify their access grants.

Network Policies

  • Composed of ALLOWED_IP_LIST (allowlist) and BLOCKED_IP_LIST (blocklist)
  • Can be applied at the account level or user level (user level takes precedence)
  • Use BLOCKED_IP_LIST to exclude specific IPs from within ALLOWED_IP_LIST
  • If a misconfigured network policy locks you out, you must contact Snowflake Support

MFA and SSO/SAML Integration

  • MFA methods are passkeys, authenticator apps (TOTP), and Duo; Snowflake is rolling out changes to require MFA for all password sign-ins
  • Enabling MFA for every user holding the ACCOUNTADMIN role is strongly recommended
  • SSO/SAML can integrate with IdPs such as Azure AD, Okta, and PingFederate
  • SCIM automates user and role provisioning from the IdP

Resource Monitoring

Resource Monitor

SettingDescription
CREDIT_QUOTAMaximum credit consumption within the monitoring period
FREQUENCYDAILY / WEEKLY / MONTHLY / YEARLY / NEVER
START_TIMESTAMPWhen monitoring begins
TRIGGERS (NOTIFY)Notify account administrators when the threshold is reached
TRIGGERS (SUSPEND)Suspend the warehouse after running queries finish when the threshold is reached
TRIGGERS (SUSPEND_IMMEDIATELY)Cancel running queries and suspend the warehouse immediately when the threshold is reached

ACCOUNT_USAGE Schema

The snowflake.account_usage schema contains views for analyzing account usage.

  • WAREHOUSE_METERING_HISTORY: Per-warehouse credit consumption history
  • STORAGE_USAGE: Daily storage usage (tables, Time Travel, Fail-safe)
  • LOGIN_HISTORY: User login success/failure history
  • QUERY_HISTORY: Query execution history for the past 365 days
  • ACCESS_HISTORY: Object access history (Enterprise Edition or higher)

ACCOUNT_USAGE views have a data latency of up to 45 minutes to 3 hours (and keep 1 year of history). When you need near-real-time information, use INFORMATION_SCHEMA instead (note that its retention ranges from 7 days to 6 months, depending on the view).

Cost Management

Cost ComponentBilling UnitOptimization
ComputeCredits (warehouse size x runtime)Shorten auto-suspend; right-size warehouses
StorageTB/month (On-Demand or Capacity contract)Tune Time Travel retention; remove unused data
Data transferCross-region / cross-cloud transfer volumeProcess within the same region; optimize replication
ServerlessSnowpipe, tasks, materialized views, etc.Tune Snowpipe ingestion frequency
Cloud ServicesBilled only above the 10% thresholdAvoid excessive SHOW/DESCRIBE calls

Data Governance

  • Dynamic Data Masking: Mask column values based on role (Enterprise Edition or higher)
  • Row Access Policies: Filter returned rows based on role and conditions
  • Object Tags: Attach tags to columns or tables and apply masking policies based on tags
  • Data Classification: Automatically detect PII (personal information) with the EXTRACT_SEMANTIC_CATEGORIES function

Study Strategy

The Administrator exam rewards real operations experience. Focus on these hands-on exercises:

  • Create a network policy and verify how IP restrictions behave
  • Apply a Resource Monitor to a warehouse and verify NOTIFY / SUSPEND action behavior
  • Write queries against ACCOUNT_USAGE views to analyze credit usage, login history, and query history
  • Design a custom role hierarchy and practice the best practice of placing it under SYSADMIN
  • Create a dynamic data masking policy and confirm how the displayed value differs by role

Check Your Understanding

SnowPro Advanced: Administrator

Question 1

In Snowflake, you want to allow access only from a specific IP range while excluding some IPs within that range. How should the network policy be configured?

  1. Set the allowed CIDR range in ALLOWED_IP_LIST and the IPs to exclude in BLOCKED_IP_LIST
  2. Setting the IPs to exclude only in BLOCKED_IP_LIST automatically allows every other IP
  3. ALLOWED_IP_LIST and BLOCKED_IP_LIST cannot be used together, so create two separate policies
  4. Network policies cannot exclude IPs, so handle it at the firewall

Correct answer: A

Define the allowed range with ALLOWED_IP_LIST and specify the IPs to exclude with BLOCKED_IP_LIST. BLOCKED_IP_LIST functions as a subset of ALLOWED_IP_LIST. When only ALLOWED_IP_LIST is set, every IP not in the list is blocked.

Frequently Asked Questions

Are SQL operation questions on the SnowPro Advanced Administrator exam?

Yes, administrative SQL commands are tested. Specifically, role and privilege management with GRANT/REVOKE, CREATE NETWORK POLICY, ALTER ACCOUNT, CREATE RESOURCE MONITOR, SHOW PARAMETERS, and ALTER USER SET/UNSET are all in scope. SELECT-based analytical queries are rare; most scenarios involve querying ACCOUNT_USAGE/INFORMATION_SCHEMA views to inspect resource consumption or login history.

How does the security domain differ between the Administrator and Core exams?

Core focuses on role hierarchies and basic GRANT behavior, while Administrator goes deeper into real operations: network policy design (CIDR ranges and policy precedence), SSO/SAML setup procedures, SCIM provisioning, column-level and row-level security, Tri-Secret Secure, and key rotation policies.

At what granularity can Resource Monitors be set, and how are they tested?

Resource Monitors can be configured at the account level or for individual warehouses. You combine a credit quota, a frequency (DAILY/WEEKLY/MONTHLY/YEARLY/NEVER), and threshold actions (NOTIFY/SUSPEND/SUSPEND_IMMEDIATELY). Typical exam scenarios are like "suspend the warehouse if monthly usage exceeds 100 credits" — you pick the correct configuration. The fact that only the ACCOUNTADMIN role can create Resource Monitors comes up frequently.

Check what you learned with practice questions

Practice with certification-focused question sets

Try free questions
Author

NicheeLab Editorial Team

NicheeLab editorial team focused on data engineering and cloud certification learning. Content is structured around practical study needs and official exam domains.


Related articles
Snowflake

Snowflake Certifications: All 11 Exams Explained (2026)

Every SnowPro certification on Snowflake's official list — C...

Snowflake

Snowflake Exam Difficulty Ranking: All 11 Certs Compared (2026)

All 11 SnowPro exams compared by difficulty in a ranking and...

Snowflake

Snowflake Study Guide: Fastest Pass Route by Exam (2026)

How to pass SnowPro certifications efficiently — official ma...

Snowflake

SnowPro Core (COF-C03): Complete Exam Guide (2026)

Pass the SnowPro Core exam — five domains, scope, sample que...

Snowflake

SnowPro Associate Platform (SOL-C01): Current Status & What to Take Next (2026)

As of October 2026, SnowPro Associate: Platform (SOL-C01) is...

Browse all Snowflake articles (103)
© 2026 NicheeLab All rights reserved.