Answer: True

The correct answer is True (A) because Snowflake's architecture includes a metadata cache in the Cloud Services Layer that stores information about micro-partitions, including aggregate data like row counts. Queries that can be answered using this metadata (e.g., COUNT(*) on unchanged tables) do not require spinning up a virtual warehouse, as confirmed by community members who tested this behavior and cited Snowflake documentation. The community discussion shows strong consensus (90% selected A, with multiple upvoted comments explaining that metadata queries run without VW activation), while the few B selections were either corrected or based on incorrect assumptions about metadata caching.

Author: LeetQuiz Editorial Team