
Answer-first summary for fast verification
Answer: Materialized view, Clustered table
The question asks which Snowflake objects incur both storage and compute charges. Materialized views (A) incur storage costs for storing the pre-computed results and compute costs for refreshing the data when underlying tables change. Clustered tables (E) incur storage costs for storing the table data and compute costs for automatic clustering maintenance operations that reorganize data for better performance. While transient tables (D) also incur both storage and compute costs, the community consensus (86% selecting AE with the highest upvotes) and the fact that clustering is a feature applied to tables (making clustered tables valid objects) support AE as the optimal answer. Sequences (B) and secure views (C) do not incur storage costs as they are metadata objects without physical data storage.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.