Exam facts (full table)
| Attribute | Details |
|---|---|
| Exam Code | ADA-C01 |
| Format | Multiple-choice, multiple-select |
| Number of Questions | 65 |
| Time Limit | 115 minutes |
| Passing Score | 750/1000 |
| Cost | $375 USD |
| Prerequisite | 2+ years Snowflake administrative experience (recommended) |
| Language | English |
| Delivery | Online proctored |
| Retirement Status | Retiring - Replaced by ADA-C02 |
About
The SnowPro Advanced: Administrator (ADA-C01) is an expert-level certification designed for experienced Snowflake platform administrators and architects. This certification validates advanced knowledge and hands-on expertise in managing enterprise-scale Snowflake deployments, including account management, security architecture, performance optimization, cost management, and data governance.
The exam tests real-world decision-making skills through scenario-based questions rather than simple knowledge recall. It is designed for professionals with substantial experience administering Snowflake in production environments.
Important Note: The ADA-C01 exam version is retiring and is being replaced by SnowPro Advanced: Administrator (ADA-C02).
Domain context
The SnowPro Advanced: Administrator certification validates expertise across the complete Snowflake administration stack:
- Enterprise Account Management: Multi-account hierarchies, organization structures, database design at scale
- Security & RBAC: Role-based access control design, authentication mechanisms, encryption strategies
- Performance Optimization: Query optimization, warehouse sizing and scaling, clustering strategies
- Cost Optimization: Usage monitoring, compute cost reduction, storage tiering strategies
- Data Governance: Replication, disaster recovery, data sharing governance, compliance frameworks
- Networking: Snowflake networking, connectivity options, network policies, private connectivity
- Monitoring & Administration: Query performance analysis, resource monitors, system tables, troubleshooting
Topics covered
Security, RBAC, and User Administration (30-35%)
- Authentication setup (native, SAML, OAuth, MFA)
- Role and privilege hierarchy design
- RBAC best practices for enterprise environments
- Password policies and session management
- Network policies and IP whitelisting
- Data masking and dynamic policies
- User provisioning and deprovisioning
Database Design and SQL Administration (15-20%)
- Snowflake schema design patterns
- Secure data sharing design
- Database replication and failover
- Performance considerations for large-scale deployments
- ANSI SQL and Snowflake extended SQL features
Warehouse Management and Performance Tuning (20-25%)
- Warehouse provisioning and sizing
- Auto-scaling and auto-suspend policies
- Query optimization techniques
- Clustering keys and micro-partitions
- Performance monitoring and analysis
- Materialized views and caching strategies
Resource Management and Cost Optimization (15-20%)
- Resource monitors and credit allocation
- Compute cost reduction strategies
- Storage optimization
- Data lifecycle management
- Usage tracking and billing analysis
Data Replication, Disaster Recovery, and Data Sharing (10-15%)
- Snowflake Replication and Failover (SF Replication)
- Disaster recovery planning
- Data sharing setup and governance
- Multi-region deployments
- Secure data exchange patterns
Common job-ready skills
- Design and implement enterprise-scale Snowflake architectures
- Configure and manage RBAC for multi-team organizations
- Optimize query performance and warehouse efficiency
- Implement cost management and cost allocation strategies
- Design disaster recovery and business continuity plans
- Implement data governance and compliance frameworks
- Monitor and troubleshoot Snowflake deployments
- Design secure data sharing and collaboration patterns
- Manage account hierarchies and organizational structures
- Implement network policies and private connectivity solutions
Recommended courses
- Snowflake University - SnowPro Advanced: Administrator preparation (Official)
- SnowPro Advanced Administrator Bootcamp (3-4 days)
- Advanced Snowflake Administration Workshop (Training providers)
- Snowflake Data Sharing and Governance Course
- Snowflake Performance Optimization Deep Dive
- Enterprise Snowflake Architecture Design
Practice exams
- Official Snowflake sample questions (via training.snowflake.com)
- VMExam practice tests
- CertificationPractice.com ADA-C01 practice exams
- Udemy courses with practice exams
- Custom lab environments (hands-on practice)
Books
- "Mastering Snowflake" - Gareth Eagar & Kel Varnsen
- "Snowflake: Advanced Administration and Security" (various vendor training materials)
- Snowflake official documentation and best practices guides
- Exam study guides from certification training providers
Job titles
- Senior Snowflake Administrator
- Snowflake Solutions Architect
- Enterprise Data Platform Administrator
- Cloud Data Platform Engineer
- Data Warehouse Administrator (Snowflake)
- Snowflake DevOps Engineer
- Cloud Infrastructure Manager (Data)
- Data Governance Manager
Salary (USD / ZAR×18 / GBP / EUR / AUD)
| Region | Estimated Annual Salary |
|---|---|
| United States | $140,000 - $190,000 |
| South Africa (ZAR×18) | R2,520,000 - R3,420,000 |
| United Kingdom | £100,000 - £150,000 |
| Europe | €110,000 - €160,000 |
| Australia | AUD $170,000 - AUD $240,000 |
Note: Salaries vary significantly based on location, company size, and experience level. Senior roles with this certification command higher compensation in tech hubs.
Skills validated
✓ Advanced Snowflake platform administration
✓ Enterprise security architecture and RBAC design
✓ Query performance optimization and tuning
✓ Cost optimization and resource management
✓ Disaster recovery and business continuity planning
✓ Data governance and compliance implementation
✓ Secure data sharing and collaboration
✓ Multi-account and organization management
✓ Production troubleshooting and monitoring
✓ Enterprise-scale deployment experience
Related certs
- SnowPro Core - Entry-level Snowflake certification
- SnowPro Advanced: Data Engineer - Engineering focus (ADA-E01)
- SnowPro Advanced: Administrator (ADA-C02) - Replacement for ADA-C01
- dbt Certification - Complementary for data transformation
- AWS Certified Data Analytics - Cloud data platform knowledge
- Azure Administrator Expert - Cloud administration fundamentals