Reddit

A table named FCT_SALES contains 100 million records.

The following query is executed:

SELECT COUNT(1) FROM FCT_SALES;

SELECT COUNT(1) FROM FCT_SALES;

How does Snowflake process this query?

Exam-Like

A

Query against the result set cache

18.5%

B

Query against a virtual warehouse cache

12.0%

C

Query against the most-recently created micro-partition

10.2%

D

Query against the metadata cache

59.3%

Powered ByGPT-5.2

Snowflake SnowPro Core