ADA-C01 Question 423
Single answerAnalyze how Snowflake credits are consumed by the cloud services layer (such as Snowpipe, materialized views, and automatic clustering)A Snowflake administrator notices that daily credit consumption has increased even though warehouse sizes and query volume have remained relatively stable. The account recently introduced continuous data loading through Snowpipe, created several materialized views on frequently queried tables, and enabled automatic clustering on two large fact tables. Management wants to know which statement best explains how these features affect credit usage and where the administrator should investigate first.
Which statement is MOST accurate?
- A
The additional credits are likely coming only from virtual warehouses, because Snowpipe, materialized view maintenance, and automatic clustering require a running warehouse to consume credits.
- B
The additional credits can come from the cloud services layer, because Snowpipe, materialized view maintenance, and automatic clustering are serverless features that can consume credits outside of user-managed warehouses.
- C
Only Snowpipe consumes cloud services credits; materialized views and automatic clustering consume credits only when queries access the underlying tables.
- D
Cloud services charges apply only when the daily cloud services usage exceeds 10% of that day's warehouse compute usage, so these new features cannot increase the total bill unless warehouses also scale up.
Show answer and explanation
Correct answer: B
Explanation
The best answer is Option 2. In Snowflake, some features are serverless and are billed independently from user-managed virtual warehouses. Snowpipe uses Snowflake-managed compute to load data continuously. Materialized views consume credits for background maintenance as underlying data changes. Automatic clustering also uses Snowflake-managed resources to reorganize micro-partitions over time. As a result, an account can see increased credits even when warehouse usage appears unchanged.
For exam purposes, candidates should recognize the distinction between warehouse compute and Snowflake-managed serverless/cloud-services-related consumption. In a real environment, an administrator would review Account Usage or Organization Usage views such as billing/usage history and feature-specific usage views where available to determine whether Snowpipe, materialized view maintenance, or automatic clustering is driving the increase.
Relevant Snowflake documentation areas include:
- Snowpipe cost and billing behavior
- Materialized views and maintenance costs
- Automatic clustering cost considerations
- Account usage and billing history views for analyzing credit consumption
- Cloud services usage and adjustments in billing documentation
A key best practice is to monitor serverless features after rollout, especially on large, frequently updated tables, because background maintenance can become a meaningful portion of total daily credits.
- A. Incorrect.
Incorrect. This reflects a common misconception that all compute in Snowflake must be tied to a user-managed warehouse. Snowpipe, materialized view maintenance, and automatic clustering are serverless capabilities. They do not require the administrator to start or size a warehouse for their background work, and they can consume credits independently of warehouse usage.
- B. Correct.
Correct. Snowpipe, materialized view maintenance, and automatic clustering are examples of Snowflake-managed, serverless operations that can consume credits through the cloud services/serverless billing model rather than through customer-managed virtual warehouses. When these features are introduced, credit consumption can rise even if warehouse sizes and query volume stay flat. The administrator should investigate usage views and billing history for these serverless features first.
- C. Incorrect.
Incorrect. Snowpipe is not the only relevant source of serverless credit usage. Materialized views require background maintenance as base tables change, and automatic clustering reclusters table data in the background to maintain clustering depth. Both can consume credits even without direct user queries triggering the work in a warehouse.
- D. Incorrect.
Incorrect. The statement misapplies Snowflake's cloud services adjustment concept. While Snowflake applies a daily adjustment related to cloud services usage versus warehouse usage, that does not mean these features cannot increase billed credits unless warehouses scale up. Serverless features can still materially contribute to credit consumption, and the administrator must review actual billing/usage data rather than assume no impact.