Exam SnowPro Core All QuestionsBrowse all questions from this exam
Question 858

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

    Correct Answer: D

    A materialized view is a Snowflake database object derived from a query specification, stored for later use, and can enhance performance by speeding up expensive aggregation on large data sets.

Discussion
HeetecOption: D

D correct - https://docs.snowflake.com/en/user-guide/views-materialized