Description

Overview:

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.

Prerequisites:

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.

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.

TABLE OF CONTENTS

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.