ADA-C01 Question 424
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 the monthly bill has increased even though warehouse runtime is nearly unchanged. Investigation shows heavy use of Snowpipe for continuous file ingestion, several materialized views on frequently updated tables, and automatic clustering enabled on large fact tables. Leadership asks why credits are increasing when users are not running more queries. Which explanation BEST describes the cause of the increase?
- A
These features consume credits in the cloud services layer because Snowflake performs serverless work such as file ingestion orchestration, maintenance of materialized views, and reclustering without requiring customer-managed warehouse runtime.
- B
The increase must be caused by hidden virtual warehouses that Snowflake automatically creates for Snowpipe, materialized views, and automatic clustering; those warehouses are billed exactly like user warehouses.
- C
Cloud services charges are only incurred when they exceed 10% of total warehouse compute usage, so the observed increase means warehouse usage must also have increased by at least 10%.
- D
Snowpipe, materialized views, and automatic clustering are metadata-only features, so they cannot contribute meaningfully to credit consumption unless Time Travel retention is also increased.
Show answer and explanation
Correct answer: A
Explanation
The best answer is Option 1 because it reflects how Snowflake bills several managed features that perform work outside of user-submitted queries on explicit warehouses. Snowpipe uses Snowflake-managed compute to load data continuously. Materialized views incur maintenance costs when underlying base table data changes. Automatic clustering also consumes credits to maintain clustering depth on tables where it is enabled. As a result, an organization can see increased credit consumption even when user warehouse runtime is flat. From an administrative perspective, the correct response is to analyze account usage views and service-specific consumption patterns, not just warehouse histories. Snowflake documentation on Snowpipe, materialized views, automatic clustering, and cloud services usage explains that these managed services can generate consumption independently of interactive warehouse workloads.
- A. Correct.
Correct. Snowpipe, materialized views, and automatic clustering are examples of Snowflake-managed/serverless activities that can consume credits outside of user-run warehouse queries. Snowpipe uses serverless compute to ingest files, materialized views require background maintenance as base tables change, and automatic clustering uses serverless resources to reorganize micro-partitions. This is a common reason overall credit consumption rises even when warehouse runtime appears stable.
- B. Incorrect.
Incorrect. A common misconception is that Snowflake creates billable hidden customer warehouses for these features. In practice, these capabilities are generally billed as Snowflake-managed serverless/cloud-services-related consumption rather than as standard user warehouses visible and managed like normal virtual warehouses. Administrators should analyze usage views for the specific services rather than assume an unseen warehouse is running.
- C. Incorrect.
Incorrect. The 10% adjustment concept is often misunderstood. Snowflake's cloud services usage can be adjusted relative to compute usage, but this does not mean cloud services credits occur only after warehouse compute rises by 10%, nor does it imply warehouse usage must increase to justify cloud services consumption. Serverless features can increase charges independently of warehouse runtime patterns.
- D. Incorrect.
Incorrect. These features are not merely metadata-only operations. Snowpipe ingestion, materialized view maintenance, and automatic clustering all require background processing that consumes credits. Time Travel affects storage and data retention behavior, but it is not a prerequisite for these services to generate credit usage.