Free study guide

Snowflake ADA-C02 Study Guide

SnowPro Advanced: Administrator ADA-C02

The SnowPro Advanced: Administrator (ADA-C02) exam is Snowflake's advanced-level certification for administrators who already hold SnowPro Core. It covers security, role-based access control and user administration, account management and data governance, managing warehouses and database objects, performance monitoring and cost control, data sharing and the Snowflake Marketplace, and disaster recovery and replication. It suits Snowflake, database and cloud data administrators with hands-on Snowflake experience.

  • Exam code ADA-C02
  • Advanced level
  • 6 exam domains

This guide is free, with no sign-up. It explains every Snowflake ADA-C02 exam topic in plain English, one chapter at a time. Read them in order or jump straight to the topic you need.

  • 6chapters
  • 71topics
  • 21diagrams and exhibits
  • 5 h 36 minfast track
  • Every topic follows the same simple pattern: what it is, how it works, common mistakes
  • Diagrams and real command output where a picture explains it best
  • Exam tips and worked subnetting and IPv6 practice, with answers

How the exam is weighted

Each domain is worth this share of the exam, so spend your study time in proportion. Select a domain to open its chapter.

Chapters

Open a chapter to see its topics and how long each takes.

1Snowflake Security, RBAC, and User Administration16 topics · 1 h 10 min fast trackAdministrative roles, RBAC design, grants, auditing, authentication, MFA, key pairs, OAuth, networks and SCIM.
2Account Management and Data Governance9 topics · 44 min fast trackOrganizations, accounts, encryption, policies, tags and the Trust Center.
3Data and Object Management11 topics · 53 min fast trackWarehouses, tables, views, stages, Iceberg, tasks, queries and Snowsight sharing.
4Performance Monitoring and Tuning16 topics · 1 h 13 min fast trackQuery Profile, tuning features, caching, locking, resource monitors and event tables.
5Data Sharing and Snowflake Marketplace10 topics · 49 min fast trackShares, reader accounts, clean rooms, listings, usage monitoring and Native Apps.
6Disaster Recovery, Backup and Data Replication9 topics · 47 min fast trackReplication, groups, failover, backups, Time Travel and Fail-safe.

Ready for more practice?

The full Snowflake ADA-C02 question bank has 814 questions, with timed practice exams and an explanation for every answer.

This study guide is independent and is not affiliated with, endorsed by, or sponsored by Snowflake. Vendor names, certification names and exam codes are trademarks of their respective owners and are used for identification only.