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.
1
- 1Administrative Roles - ORGADMIN, ACCOUNTADMIN and System Role Hierarchy5 min
- 2Access Control Frameworks - DAC, RBAC and UBAC and Designing the Framework4 min
- 3Custom Security Roles, Role Inheritance and Aligning Access to Business Functions4 min
- 4Object Privileges, Granting Through Inheritance and SHOW GRANTS Commands4 min
- 5Future Grants, Managed Access Schemas, Cloned Objects and Warehouse Grants4 min
- 6Database Roles and Primary and Secondary Roles4 min
- 7Auditing User and Query Activity, Fine-Tuning Access and Billing Visibility4 min
- 8Account-Level Permissions and Access Control for AI and ML Models4 min
- 9Snowflake Authentication, Federated SSO and Identity Provider Setup4 min
- 10Passwords, Password Policies, MFA Enrollment and User Types4 min
- 11Key-Pair Authentication, Programmatic Access Tokens and Rotation5 min
- 12OAuth 2.0 in Snowflake - Snowflake OAuth, External OAuth and Custom Clients4 min
- 13Network Rules and Network Policy Precedence5 min
- 14Private Connectivity, Internal Stages and the SQL API5 min
- 15Security Administration and SCIM Provisioning5 min
- 16Exfiltration Controls, Service Authentication and AI Access5 min
2
- 1Organizations and the Organization Account5 min
- 2Accounts, Names and Account Identifiers4 min
- 3Encryption, Key Management and Tri-Secret Secure5 min
- 4Account Parameters and Enabling Cortex AI5 min
- 5Data Masking and External Tokenization5 min
- 6Row Access Policies and Secure Views5 min
- 7Access History, Tagging and Tag-Based Masking5 min
- 8Data Classification and Governance in Snowsight5 min
- 9Trust Center, Horizon Catalog, Universal Search and Lineage5 min
3
- 1Virtual Warehouses - Design, Sizing, Properties and Session Use5 min
- 2Multi-Cluster Warehouses - Use Cases, Scaling Policy and Monitoring5 min
- 3Databases, Tables and Table Types - Design and Management5 min
- 4External Tables and Iceberg Tables4 min
- 5Views, Secure Views, Materialized Views and Cloning5 min
- 6Staging Data, Storage Integrations and Data Exfiltration Controls5 min
- 7External Volumes for Iceberg Tables and the Polaris Open Catalog5 min
- 8Tasks - Configure, Schedule and Set Permissions5 min
- 9Tasks - Troubleshooting, Use Cases and Serverless Versus User-Managed4 min
- 10Queries, Sequences, Persisted Results, Cancelling and Query History5 min
- 11Snowsight Charts, Dashboards, Sharing and Recovery5 min
4
- 1Monitoring Performance and Reading the Query Profile4 min
- 2Query Profile Steps, Operator Tree, Nodes and Operator Types5 min
- 3Efficient Queries - Compile and Runtime Optimization, Joins, Grouping and Sorting5 min
- 4Troubleshooting Spilling, Pruning, Timeouts and EXPLAIN5 min
- 5Caching - Result, Local Disk (Warehouse) and Metadata Caches5 min
- 6Performance Improvements - Materialized Views, Search Optimization, External Tables and Query Acceleration5 min
- 7DML Locking, Concurrency and Transaction Monitoring4 min
- 8Resource Monitors and Cost Dashboards4 min
- 9Event Tables - Logging, Metrics and Tracing Setup4 min
- 10Analyzing Event Tables - Health, Security Monitoring, Alerts and Trace Analysis4 min
- 11Organization Costs and the Usage Views4 min
- 12Data Transfer, Replication, Storage and Credit Costs5 min
- 13ACCOUNT_USAGE Against INFORMATION_SCHEMA4 min
- 14Warehouse Costs, Suspend and Resume, and Idle Time5 min
- 15Budgets, Warehouse Monitoring and Automatic Clustering Cost5 min
- 16Serverless, AI and Notebook Costs5 min
5
- 1Implementing Data Sharing, Sharing Models and Editions5 min
- 2Cross-Region and Cross-Cloud Sharing, Replication and Auto-Fulfillment6 min
- 3Programmatic Sharing, Shareable Objects, Context Functions and Providers5 min
- 4Outbound Shares, Secure Views and Secure UDFs5 min
- 5Reader Accounts - Create, Users, Resource Monitors and Objects5 min
- 6Inbound Data Shares and Installing Snowflake Data Clean Rooms5 min
- 7Clean Rooms - Bringing Users In and Managing Collaborators4 min
- 8Snowflake Marketplace - Access, Internal versus Public Listings, Becoming a Provider4 min
- 9Provider Profiles, Creating Listings and Managing Listing Requests5 min
- 10Monitoring Data Sharing Usage and Managing Native Apps5 min
6
- 1Replication Basics - Primary, Secondary, Objects and Access Control5 min
- 2Account Replication, Schedules, Replication Groups and Failover Groups5 min
- 3Replication and Editions, Lower Edition Targets and Key Considerations5 min
- 4Replication Impact on Clustering, Materialized Views, External Tables and Policies5 min
- 5Replication Impact on Streams, Tasks, Stages, Pipes, History and Iceberg5 min
- 6Database Failover, Failback on Schemas and Client Redirect6 min
- 7Disaster Recovery Plans, Failover Procedures and Backups6 min
- 8Time Travel, Fail-safe, Retention Periods and Historical Queries5 min
- 9Restore Dropped Objects, Disable Time Travel and Edition Implications5 min
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.