Answer: Regular table, Materialized view

The question asks which Snowflake objects use storage, requiring selection of two options. Based on Snowflake documentation and the community discussion consensus (AD with 75% support and higher upvotes), the correct answers are A (Regular table) and D (Materialized view). Regular tables store data physically in Snowflake's internal storage, consuming storage space. Materialized views precompute and store query results, also consuming storage. Option B (Regular view) does not store data - it's just a saved query definition. Option C (Cached query result) refers to Snowflake's result cache for queries, which doesn't count as persistent storage consumption. Option E (External table) only stores metadata and pointers to external cloud storage, not the actual data within Snowflake. The community discussion highlights that the documentation confirms tables and materialized views use storage, while cached query results do not.

Author: LeetQuiz Editorial Team