Snowflake
COF-R02 · Question #52
True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.
The correct answer is A. True. Some aggregate queries are answered thru micro partitions metadata only not requiring any VW
Querying and Performance
Question
True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.
Options
- ATrue
- BFalse
How the community answered
(38 responses)- A84% (32)
- B16% (6)
Explanation
Some aggregate queries are answered thru micro partitions metadata only not requiring any VW
Topics
#metadata cache#query optimization#virtual warehouse#result cache
Community Discussion
No community discussion yet for this question.