Answer-first summary for fast verification
Answer: A materialized view is automatically refreshed by a Snowflake managed warehouse.
The correct answer is C because materialized views in Snowflake are automatically and transparently maintained by Snowflake's background service, which updates them after changes to the base table. This eliminates the need for manual scripts or commands, making it efficient and reliable. Option A is incorrect as materialized views can be refreshed automatically. Option B is wrong because no additional scripts are required for refresh. Option D is incorrect because the auto-refresh feature is inherent and not set up using the SQL SET command. The community discussion, with 100% consensus and upvoted comments, strongly supports C, emphasizing Snowflake's managed maintenance.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
What is a characteristic of maintaining a materialized view?
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.