SnowPro® Advanced Administrator Recertification Training

Duration: Hours



    Training Mode: Online



    The “SnowPro® Advanced Administrator Recertification Exam Certification Training” is meticulously crafted to equip professionals with an extensive comprehension of Snowflake administration, ensuring they stay abreast of the latest methodologies and techniques. This program serves as a platform for participants to not only refresh their existing knowledge but also to enhance their skills, empowering them to proficiently manage Snowflake environments. Completion of this training reaffirms professionals’ expertise, solidifying their credibility and value in the realm of data management.

    Exam: Renewing and Extending Certification

    The SnowPro® Advanced: Administrator Recertification exam provides an opportunity for candidates with expiring SnowPro Advanced: Administrator Certification to renew their credentials. Successful completion of the SnowPro Advanced: Administrator Recertification extends a candidate’s SnowPro Core Certification + SnowPro Advanced: Administrator status by an additional 2 years from the date of passing the recertification exam. Candidates must possess a valid SnowPro Advanced: Administrator Certification at the time they undertake the recertification exam to be eligible.

    Exam Format:

    1. Exam Version: ADA-R01
    2. Total Number of Questions: 40
    3. Question Types: Multiple Select, Multiple Choice
    4. Time Limit: 85 minutes
    5. Language: English
    6. Registration fee: USD 188
    7. Passing Score: 750 + Scaled Scoring from 0 – 1000

    Unscored Content:

    Exams may include unscored items to gather statistical information for future use. These items are not identified on the form and do not impact your score, and additional time is factored into account for this content.


    SnowPro Core Certified & SnowPro Advanced: Administrator Certified
    Delivery Options:

    1. Online Proctoring
    2. Onsite Testing Centers

    Exam Domain Breakdown:

    This exam guide includes test domains, weightings, and objectives. It is not a comprehensive listing of all the content that will be presented in this examination. The table below lists the main content domains and their weightings.

    DomainDomain Weightings
    1.0 Snowflake Security, RBAC, & User Administration30-35%
    2.0 Account Management & Data Governance20-25%
    3.0 Performance Monitoring & Tuning20-25%
    4.0 Data Sharing, Data Exchange & Snowflake Marketplace10-15%
    5.0 Disaster Recovery, Backup & Data Replication10-15%

    Exam Topics:

    Outlined below are the Domains & Objectives measured on the exam. To view subtopics, download the exam study guide.

    SnowPro® Domain:

    Snowflake Security, Role-Based Access Control (RBAC), and User Administration

    1. Set up and manage Snowflake authentication, adhering to SnowPro® standards.
    2. Set up and manage network and private connectivity.
    3. Set up and manage security administration and authorization.
    4. Given a set of business requirements, establish access control architecture.
    5. Given a scenario, create and manage access control.
    6. Given a scenario, configure access controls.

    Account Management and Data Governance

    1. Manage organizations and accounts.
    2. Manage organizations and access control.
    3. Implement and manage data governance in Snowflake.
    4. Given a scenario, manage account identifiers.
    5. Given a scenario, manage databases, tables, and views.
    6. Perform queries in Snowflake, following SnowPro® best practices.
    7. Given a scenario, stage data in Snowflake.
    8. Given a scenario, manage streams and tasks.

    Performance Monitoring and Tuning

    1. Given business requirements, design, manage, and maintain virtual warehouses.
    2. Monitor Snowflake performance, as per SnowPro® standards.
    3. Manage DML locking and concurrency in Snowflake.
    4. Given a scenario, implement resource monitors.
    5. Interpret and make recommendations for data clustering.
    6. Manage costs and pricing.

    Data Sharing, Data Exchange, and Snowflake Marketplace

    1. Manage and implement data sharing.
    2. Use the Data Exchange.
    3. Use the Snowflake Marketplace.

    Disaster Recovery, Backup, and Data Replication

    1. Manage data replication.
    2. Given a scenario, manage Snowflake Time Travel and Fail-safe.


    Module 1 – Manage and administer Snowflake data security and governance

    1. Controlling Account Access
    2. Monitoring Activity with the Snowflake ACCESS_HISTORY Account Usage View
    3. Object Tagging
    4. Classification
    5. Data Masking
    6. Row Access Policies and Row-Level Security External Tokenization
    7. Secure Views and UDFs
    8. RBAC and granting privileges
    9. Lab: How to do object tagging
    10. Lab: How to data masking
    11. Lab: How to do classification
    12. Lab: How to define row access policies
    13. Lab: How to create secure views
    14. Lab: How to create custom roles
    15. Lab: How to work with privileges

    Module 2 – Manage and maintain database objects

    1. Creating and Managing Snowflake Databases
    2. Creating and Managing Snowflake Schemas
    3. Introduction to Snowflake Tables
    4. Creating and Managing Views
    5. Introduction to Snowflake Stages: File Format Included Extending SQL with Stored Procedures
    6. and UDFs
    7. Snowflake Streams
    8. Snowflake Tasks
    9. Lab: How to create Databases
    10. Lab: How to create Schemas
    11. Lab: How to create tables
    12. Lab: How to create Views
    13. Lab: How to create Snowflake stages
    14. Lab: How to create file format
    15. Lab: How to create a stored procedure
    16. Lab: How to create UDF
    17. Lab: How to create snowflake streams
    18. Lab: How to create Tasks

    Module 3 – Perform database monitoring and tuning

    1. Understanding performance optimization
    2. Exploring Execution times
    3. Optimizing Warehouses for performance
    4. Optimizing Storage for performance
    5. Lab: How to optimize warehouse for performance
    6. Lab: How to optimize storage for performance
    7. Module 4 – Administer disaster recovery, backup, and data replication
    8. Time travel
    9. Fail-safe
    10. Understanding storage cost
    11. Account failover
    12. Introduction to replication
    13. Replication considerations
    14. Replication configuration
    15. Understanding the cost of replication
    16. Lab: How to configure replication

    For more information on SnowPro® Advanced Administrator Recertification Training; please visit here.

    Contact Locus IT support team for further training details.



    There are no reviews yet.

    Be the first to review “SnowPro® Advanced Administrator Recertification Training”

    Your email address will not be published. Required fields are marked *