Question 30
A dashboard runs SELECT statements against a designated warehouse. Which layer supplies execution resources?
Explanation
Correct Answer
Correct: warehouse compute executes the query plan. Compute layer of virtual warehouses executes SQL operations using independent elastic compute.
Incorrect Answers
Not the best choice: Cloud services layer coordinates authentication, metadata, transactions, and query optimization; the scenario instead requires warehouse compute executes the query plan.
Not the best choice: SQL client or connector submits requests to Snowflake and consumes result sets; the scenario instead requires warehouse compute executes the query plan.
Database storage layer persists compressed table data independently of warehouse compute, authentication and client driver configuration. The scenario instead selects Compute layer of virtual warehouses, as indicated by the stated operational requirement.