SnowPro Core Recertification — Question 9

When does a materialized view get suspended in Snowflake?

Answer options

• A. When a column is added to the base table
• B. When a column is dropped from the base table
• C. When a DML operation is run on the base table
• D. When the base table is reclustered

Correct answer: C

Explanation

A materialized view in Snowflake gets suspended when a DML operation occurs on the base table, as this operation can alter the underlying data structure. Adding or dropping columns from the base table or reclustering does not directly affect the materialized view's ability to function.