Snowflake SnowPro Core Certification Study Guide

Chapter 10Account and Resource Management

THE SNOWPRO CORE EXAM TOPICS COVERED IN THIS CHAPTER INCLUDE THE FOLLOWING:

• 1.0 Domain: Account and Security
• 1.1 Explain how to manage Snowflake accounts.
  • Account usage
  • Information schema
• 1.5 Outline Data Governance capabilities in Snowflake
  • Account usage views
• 2.0 Domain: Virtual Warehouses
• 2.1 Outline compute principles.
  • Credit usage & billing
• 2.2 Explain Virtual Warehouse best practices.
  • Management/monitoring
• 4.0 Domain: Performance Management
• 4.2 Outline best practices for Snowflake performance management on virtual warehouses.
  • Query history
• 5.0 Domain: Snowflake Overview & Architecture
• 5.3 Explain how Snowflake is different compared to legacy warehouse solutions.
  • Account Management
• 6.0 Domain: Storage and Protection
• 6.1 Outline Snowflake Storage concepts.
  • Storage Monitoring

Snowflake provides prebuilt views and table functions that enable users to keep track of their Snowflake credit and storage usage. In addition to this tracking, Snowflake provides resource monitors through which you can track credit usage and take actions such as suspending virtual warehouses and notifying administrators when credit usage crosses defined thresholds. This chapter describes these views in detail, explains how to use resource monitors, and provides several hands-on exercises to reinforce learning. Finally, the chapter discusses Snowflake release management processes.

Resource Monitors

In Snowflake, resource monitors help ...