COF-C03: SnowPro Core Certification

Snowflake stores table statistics, including row-count information, in its metadata layer. An unfiltered COUNT(*) on a base table can therefore be returned as a metadata-based result without a full table scan; a query result cache hit would require an eligible previously cached identical result, which is not established.