Answer: Materialized view

The question asks for the term that denotes a pre-computed data set derived from a SELECT query specification and stored for later use. A materialized view (option C) fits this definition precisely, as it stores the result set of a query physically and refreshes it periodically to maintain performance. The community discussion shows 100% consensus on C, with upvoted comments and references to Snowflake documentation confirming this. Option A (View) is a virtual table that doesn't store data. Option B (Secure view) is a view with security features but still virtual. Option D (External table) references data stored outside Snowflake, not a pre-computed result set.

Author: LeetQuiz Editorial Team