SnowPro Advanced: Administrator

Snowflake · SnowPro Certification Prep

Theory

The SnowPro Advanced: Administrator certification, currently exam ADA-C02, is for people who run Snowflake accounts day to day. It covers security and user administration (users, roles, RBAC design, authentication, network policies), account management and data governance (parameters, masking and row access policies, tagging), performance monitoring and tuning (warehouses, resource monitors, query history), data sharing and the Marketplace, and disaster recovery through replication and failover.

Questions test operational judgement, for example how to stop runaway spend on a warehouse without cancelling critical queries, or how to grant a team access with least privilege. Exam versions change, so check the current study guide for domains and weights.

Why we use it

It validates the skills that keep a Snowflake account secure, compliant and cost-controlled, which matters to any company running Snowflake in production.

When to use it

Take it after Core when you manage users, roles, warehouses and costs. If your role is designing the platform rather than operating it, compare it with the Architect exam.

Exam Format & Domains

The current version is ADA-C02. Like the other Advanced exams it requires an active SnowPro Core certification and is built from scenario questions. Snowflake's official ADA-C02 study guide lists the exact domains, weights, question count, time and fee; use it rather than older blog posts.

Highest-Value Topics to Study

User provisioning via SCIM/SSO/SAML/OAuth, network policies and private connectivity, MFA enforcement, RBAC role-hierarchy design, resource monitors and cost control, replication and failover groups, and compliance standards like HIPAA, SOC 2, and PCI DSS.

How to Prepare

Focus on operational judgment questions — how to provision users safely at scale, how to set up alerting before a cost overrun happens — rather than memorizing every SQL DDL option, since this exam is closer to running the platform than writing queries against it.

How it works

  1. Hold an active SnowPro Core certification
  2. Read the current Administrator study guide
  3. Practise role design, resource monitors and network policies
  4. Can you solve access and cost incidents step by step? Yes: Practise scenario questions. No: Rehearse with ACCOUNT_USAGE queries.
  5. Book the exam

Example

-- Self-check: can you design a resource monitor + alerting
-- setup that catches runaway spend before it happens?

Key points

Snowflake topics

Snowflake Fundamentals

Warehouses & Performance

Staging & SnowSQL

Tables & Data Handling

Cloud Integrations

Storage & Optimization

Security & Governance

Views, Pipelines & Automation

Data Types & SQL Fundamentals

Semi-Structured Data Deep Dive

Advanced Features

Data Sharing & Collaboration

Cost Management & Monitoring

Databases, Schemas & Objects

Performance Deep Dive

Advanced Security & Governance

Stored Procedures & UDFs

Ecosystem & Integrations

SnowPro Certification Prep

T
Tech Town
Log InSign Up Free
Home SQL Python DSA Power BI Snowflake Databricks Spark Gen AI Practice Problems Contest Blog

Mastering Snowflake

The modern data cloud, from architecture to SnowPro certification. Click any topic in the sidebar to open it right here.

{{ sectionCount }}
Sections
{{ topicCount }}
Topics
Free
Forever
Hands-on practice Practice Snowflake SQL Sharpen the SQL you use in Snowflake: 150 query problems in a live editor with instant checking. Start practising →
Section {{ sec.num }}

{{ sec.label }}

Snowflake  /  {{ current.sectionLabel }}  /  {{ current.name }}

{{ current.name }}

Theory

{{ current.def }}

Why we use it

{{ rich.why }}

When to use it

{{ rich.when }}

{{ sec.h }}

{{ sec.body }}

{{ sec.body }}

Diagram

{{ rich.dg.caption }}

{{ tb.title }}
{{ c.v }}
{{ rich.dg.op }}
➜
{{ rich.dg.output.title }}
{{ c.v }}
{{ nd.label }}
{{ nd.sub }}
{{ nd.label }}
{{ nd.sub }}
{{ rich.dg.left.title }}
{{ it }}
{{ rich.dg.right.title }}
{{ it }}
On screen — where to click

{{ rich.ui.title }}

{{ u.text }}
  1. {{ st.n }}{{ st.text }}
{{ rich.ui.title }}
{{ u.text }}
Flowchart — how it works
{{ nd.text }}
{{ nd.text }}
◇ {{ nd.text }}
Yes → {{ nd.yes }}
No → {{ nd.no }}
Syntax
{{ current.syntax }}
Example
{{ current.example }}
Want to run this yourself? Unlike the SQL and Python courses, Snowflake needs a real account — there's no in-browser engine for it. Click Copy above, then paste it into a free Snowflake trial (30 days, no card required) and run it in Snowsight.
Key Points — click to check off as you learn
  • {{ pt.mark }} {{ pt.text }}

Share this topic