SnowPro Core Certification — Question 851

What is used to denote a pre-computed data set derived from a SELECT query specification and stored for later use?

Answer options

• A. View
• B. Secure view
• C. Materialized view
• D. External table

Correct answer: C

Explanation

The correct answer is 'Materialized view' because it specifically refers to a stored pre-computed result set from a query. A 'View' does not store data, a 'Secure view' offers restricted access to data, and an 'External table' refers to data stored outside the database itself, not necessarily pre-computed.