COF-C03: SnowPro Core Certification

By Snowflake · Question Mode

QuestionQ92

Performance Optimization, Querying & Transformation

Which Snowflake objects enable fast result retrieval for queries that include aggregate functions?

Choose two
Explanation

Materialized views precompute query results and can speed up expensive aggregation operations. Dynamic tables materialize the results of specified queries and are designed for extremely fast result retrieval while supporting transformations that include aggregations.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!