Course Description

This course prepares Snowflake administrators to take the SnowPro Advanced Administrator exam. They are equipped with the skills and knowledge required to manage and administer Snowflake accounts, maintain security, optimize performance, and ensure high availability.

Duration	Delivery Method	Mandatory Prerequisites	Who Should Attend
3 days	Virtual – Intructor led	Attendees should have: Completed the Snowflake Fundamentals training or have equivalent experience. Ideally, achieved the SnowPro Core Certification. Ideally, advanced Snowflake SQL knowledge.	The audience for this class is Snowflake Administrators/Snowflake, Data Cloud Administrators, Database Administrators, Cloud Infrastructure Administrators, Cloud Data Administrators.

Course Objectives:

Attendees will focus on hands-on management and coding of various domains, including security, governance, monitoring, and more.

They also learn to:

• Manage and administer Snowflake accounts.
• Manage and administer Snowflake data security and governance.
• Manage and maintain database objects.
• Manage and maintain virtual warehouses.
• Perform database monitoring and tuning.
• Perform data sharing and use the Data Exchange and Snowflake
• Marketplace Administer disaster recovery, backup, and data replication.

Agenda:

Snowflake Security, Role-Based Access Control (RBAC), and User Administration Authentication Network and Private Connectivity Security Administration and Authorization Access Control (RABC) Security and Access Scenarios Custom and user defined roles Account Management and Data Governance Organizations and accounts Organization level security and access Data Governance Database, tables, views, and queries Staging data Database streams and tasks

Performance Monitoring and Tuning Design, manage and maintenance Monitoring performance (query performance, explain) DML locking and concurrency Data clustering and partitioning Cost management Data Sharing, Data Exchange, and Snowflake Marketplace Data sharing Data exchange Snowflake Marketplace Disaster Recovery, Backup, and Data Replication Disaster recovery Data replication Backups Retention period