SnowPro Core Certification — Question 873

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: B

Explanation

A materialized view gets suspended in Snowflake when a column is dropped from the base table, as this change affects the structure of the view. The other options involve actions that do not alter the base table's structure in a way that impacts the materialized view's validity.