SnowPro Core Certification — Question 724

Which statement accurately describes a characteristic of a materialized view?

Answer options

• A. A materialized view can query only a single table.
• B. Data accessed through materialized views can be stale.
• C. Materialized view refreshes need to be maintained by the user.
• D. Querying a materialized view is slower than executing a query against the base table of the view.

Correct answer: A

Explanation

The correct option is A, which states that a materialized view can query only a single table; however, this is incorrect as materialized views can aggregate data from multiple tables. Option B is incorrect because while data can be stale, it does not define a characteristic of materialized views specifically. Option C is also wrong because materialized view refreshes can be automated. Lastly, option D is inaccurate since querying a materialized view is typically faster than querying the base table.