Which statement accurately describes a characteristic of a materialized view?
Which statement accurately describes a characteristic of a materialized view?
A materialized view is an optimized, non-volatile copy of data that can be queried similarly to a regular view but with one significant difference: the data within a materialized view can become stale because it does not automatically stay synchronized in real-time with the base table. Periodic refreshes are necessary to keep the materialized view current, which can lead to temporary data staleness.
Can query only a single table
A There is no join in materialized view. Hence Single queries.
https://docs.snowflake.com/en/user-guide/views-materialized#label-limitations-on-creating-materialized-views
A- Can query only a single table No join, no multiple tables, no aggregations , auto-refreshed
A is correct answer. The materialized view is maintained by SF in Enterprise version and above and it can refer to only one table.
Obviously A is a correct answer， but also B seems to be correct as far as I can see．