Which statement accurately describes a characteristic of a materialized view?

Question

Options

• AA materialized view can query only a single table.
• BData accessed through materialized views can be stale.
• CMaterialized view refreshes need to be maintained by the user.
• DQuerying a materialized view is slower than executing a query against the base table of the view.

• A
  6% (2)
• B
  92% (33)
• C
  3% (1)

Explanation

Materialized views store the precomputed result set of a query and are refreshed asynchronously by a background Snowflake service. Because the refresh is not instantaneous, there can be a lag between when the base table changes and when the materialized view reflects those changes-meaning the data can be stale. The other choices are incorrect: materialized views can query multiple tables (though joins have limitations), refreshes are automatically maintained by Snowflake (not manually by the user), and querying a materialized view is typically faster than querying the base table directly, which is the primary purpose of using one.

No community discussion yet for this question.