OpenExamsFREE PRACTICE — ANY EXAM

SnowPro® Advanced: Administrator — Requirements & Free Practice

US · License preparation

100 free questions · Answer explanations · No signup required

Choose what to practice

Start with an exam below. Your examination requirements depend on your application pathway. View licensing requirements

Loading selected examination banks…

Licenses, application pathways and examination requirements

Each license and applicant pathway has its own requirements and exemptions. Choosing practice questions does not determine your eligibility.

SnowPro® Advanced: Administrator

Snowflake certification validating advanced knowledge and skills in data cloud administration using Snowflake and its components.

Licensing authority: Snowflake, Inc. · Application information

Initial by examination
SnowPro Advanced: Administrator
Applicability
The current owner page explicitly identifies ADA-C02 and links the correspondingly coded guide; the guide publication date is not treated as an official effective date. No start or retirement boundary is published in the adopted materials, so calendar validity boundaries remain null.
Completion
Pass the applicable ADA-C02 certification exam to obtain the Administrator certification; the issued certification is valid for two years from passing.
Eligibility
Eligible individuals must hold an active SnowPro Core Certified credential; this is a prior credential qualification, not a requirement to re-sit a particular current Core examination. Candidates must be at least 18 years old, register with their full legal name, present valid government-issued photo ID, and accept Snowflake's certification terms during registration.

SnowPro Advanced: Administrator

Provider
Pearson Vue
Format
Multiple Select, Multiple Choice, Interactive
Exam questions
Total questions: 65.
Time limit
115 minutes
Passing score
750 on a scaled scoring range of 0–1000
Exam fee
$375 USD per attempt (US)
Examination outline
  • Snowflake Security, Role-Based Access Control (RBAC), and User Administration (31%)
    • Manage administrative roles
    • Given a set of business requirements, design access control framework
    • Given a scenario, create and manage access control
    • Given a scenario, fine-tune access controls
    • Set up and manage Snowflake authentication
    • Set up and manage network and private connectivity
    • Set up and manage security administration and authorization
  • Account Management and Data Governance (18%)
    • Manage organizations and accounts
    • Implement and manage data governance in Snowflake
    • Given a scenario, manage account identifiers
  • Data and Object Management (15%)
    • Given business requirements, design, manage, and maintain virtual warehouses
    • Given a scenario, manage databases, tables, and views
    • Given a scenario, stage data in Snowflake
    • Given a scenario, manage tasks
    • Perform queries in Snowflake
  • Performance Monitoring and Tuning (20%)
    • Monitor and analyze Snowflake performance
    • Manage DML locking and concurrency in Snowflake
    • Given a scenario, implement resource monitors
    • Enable and manage logging and tracing
    • Manage and optimize costs
  • Data Sharing and Snowflake Marketplace (7%)
    • Implement and manage data sharing
    • Implement and manage the Snowflake Marketplace
  • Disaster Recovery, Backup, and Data Replication (9%)
    • Manage data replication
    • Given a scenario, manage Snowflake Time Travel and Fail-safe
Examination sources