SnowPro Core Certification — Question 1171

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?

Answer options

• A. Database Storage
• B. Query Processing
• C. Cloud Services
• D. Compute

Correct answer: C

Explanation

The query will utilize the Cloud Services component of Snowflake architecture because it manages the metadata and query optimization. The Database Storage is not involved in the execution of the query itself, while Query Processing and Compute are related to data manipulation and computation tasks, not the orchestration of the query.