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.
its A as metadata has aggregate data already
Below query doesn't need an active warehouse to run for a seond time. SELECT COUNT(*) FROM "SNOWFLAKE_SAMPLE_DATA"."TPCH_SF1"."CUSTOMER";
should be A
A is correct
Count min does not require
If there is no change in query then it will fetch from metadata cache I.e from cloud service layer.
Answer - B, because metadata has no cache.
There is metadata cache in the service layer, so answer A is correct.
Actually, I think one needs active datawarehouse to run the query but it would not use it.
B is correct
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
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.
correct answer:A
Yes,It is True