Answer-first summary for fast verification
Answer: Cloud Services
The query SELECT MAX(o_orderdate) FROM ORDERS retrieves metadata about the maximum value of a column, which is stored in Snowflake's Metadata Cache. This cache is part of the Cloud Services layer, which handles metadata management, query optimization, and coordination. The community discussion confirms this, with 100% consensus on option C and an explanation that Metadata Cache stores statistics like max/min values and resides in Cloud Services. Option A (Database Storage) is incorrect as it stores actual table data, not metadata. Option B (Query Processing) is incorrect as it refers to virtual warehouses that execute queries but don't store metadata. Option D (Compute) is invalid as it is not a standard Snowflake architecture component.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
A user executes the following query to find the maximum value of a date field in a table:
SELECT MAX(o_orderdate) FROM ORDERS;
SELECT MAX(o_orderdate) FROM ORDERS;
Which component of Snowflake's architecture is utilized by this query?
A
Database Storage
B
Query Processing
C
Cloud Services
D
Compute