According to Snowflake documentation and the community consensus (with 100% agreement and multiple upvoted comments), materialized views should be created when: (B) The query consumes many compute resources every time it runs - because materialized views pre-compute results to avoid expensive computations on each query execution, and (E) The results of the query do not change often and are used frequently - because materialized views provide performance benefits when the underlying data is relatively static but the query results are accessed repeatedly. Option A is incorrect because minimal cost queries don't benefit from materialized views. Option C is incorrect because frequently updated base tables make materialized views inefficient due to constant refresh requirements. Option D is incorrect because highly optimized queries that don't consume many resources don't need the overhead of materialized views.