SnowPro Core Certification — Question 826

What Snowflake database object is derived from a query specification, stored for later use, and can speed up expensive aggregation on large data sets?

Answer options

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

Correct answer: D

Explanation

The correct answer is D, Materialized view, because it stores the result of a query and allows for faster access to data, especially for complex aggregations. Temporary tables and external tables serve different purposes; temporary tables are transient and external tables link to data outside Snowflake. Secure views protect data but do not improve performance like materialized views do.