- Identify the various aspects of compute and storage management
- Illustrate administrative tasks within the detailed architecture of Snowflake
- Review Snowflake best practices & considerations for managing load operations and performance
- Describe data governance in Snowflake, including column-level data security using secure views and agile data masking features
- Manage multiple accounts across the Organization
- Describe the DDL operations that work with fundamental database objects
- Discuss transaction and concurrency models and DML considerations
- Employ recovery methods and agile development with Time Travel & Cloning
- Implement advanced techniques for Snowflake performance-tuning methodologies
- Design and develop secure access to objects in Snowflake with Role-Based Access Control (RBAC)
- Recommend the Snowflake best practices for management, monitoring, and optimization
- Use data replication for data sharing across accounts and for failover scenarios
Responsibilities
- Understand Snowflake usage and cost consumption
- Manage Snowflake warehouses.
- Set up and view details about resource monitors.
- Manage users and roles.
- Administer Snowflake accounts in your organization.
- Administer network policies and monitor session activity.
- Monitor platform performance