COF-C03: SnowPro Core Certification

By Snowflake · Question Mode

QuestionQ14

Performance Optimization, Querying & Transformation

Query results contain relatively few rows or columns compared with the base table and have these characteristics:

  1. The results need substantial processing.
  2. The base table is updated infrequently.
  3. The query uses only one large table.

Which data object should be created to improve performance?

Explanation

A materialized view stores a precomputed result set, so it can accelerate expensive queries that return a small subset of a large base table. Snowflake specifically identifies infrequently changing base tables and single-table query acceleration as suitable materialized-view use cases.

Learn more

Community Discussion

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