OpenExamsFREE PRACTICE — ANY EXAM

SnowPro Advanced: Administrator — Information & Free Practice

US · Examination information

100 free questions · Answer explanations · No signup required

Start free practice →

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

Related license preparation

This examination may be required or accepted as an alternative, depending on the license and application pathway.