A user needs to know the maximum value of a date field in a table, and runs the following query:
select max(o_orderdate) from ORDERS;
Which part of Snowflake architecture will this query use?
A user needs to know the maximum value of a date field in a table, and runs the following query:
select max(o_orderdate) from ORDERS;
Which part of Snowflake architecture will this query use?
First of all, Compute does not exist. Second, the way the question is addressed can take us to the thought of Metadata Cache. Metadata Cache, stores statistics and Metadata about Objects, such as Max/Min values for a column. Hence, I reply C. Metadata Cache is stored on Cloud Services, based on what I found in the courses.