True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.
True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.
True. Certain queries, particularly those that can be resolved using metadata, do not require an active Virtual Warehouse. This is because the metadata cache, which resides in the Cloud Services Layer, can provide the necessary information without needing to spin up compute resources.
Some aggregate queries are answered thru micro partitions metadata only not requiring any VW spin ups.
Answer is A.
Sorry, just tested it. It is A.
Count min does not require
A is correct
should be A
Below query doesn't need an active warehouse to run for a seond time. SELECT COUNT(*) FROM "SNOWFLAKE_SAMPLE_DATA"."TPCH_SF1"."CUSTOMER";
its A as metadata has aggregate data already
Yes,It is True
correct answer:A
Metadata queries can be done as metadata is stored in the services layer and does not require the compute layer to spin up a vm to access the storage layer.
Since Metadata cache and the Query Result cache are part of the Cloud Services Layer, they can run without the need of an active virtual warehouse
B is correct
Actually, I think one needs active datawarehouse to run the query but it would not use it.
There is metadata cache in the service layer, so answer A is correct.
Answer - B, because metadata has no cache.
If there is no change in query then it will fetch from metadata cache I.e from cloud service layer.