SnowPro Core Certification — Question 722

What is a characteristic of the maintenance of a materialized view?

Answer options

• A. Materialized views cannot be refreshed automatically.
• B. An additional set of scripts is needed to refresh data in materialized views.
• C. A materialized view is automatically refreshed by a Snowflake managed warehouse.
• D. A materialized view can be set up with the auto-refresh feature using the SQL SET command.

Correct answer: C

Explanation

The correct answer is C because materialized views in Snowflake can be automatically refreshed by a managed warehouse, ensuring data is up-to-date without manual intervention. Options A and B are incorrect as they suggest limitations on refreshing, while D is misleading since the auto-refresh capability is inherent to Snowflake's architecture, not just set up via SQL.