During a refresh, are the materialized view definitions replicated to the secondary database?

• A. Not applicable
• B. Only data
• C. Not sure
• D. Yes

Answer: (D)

When Snowflake replicates a database to a secondary region, it carries over not just the data but the object definitions as well. Materialized view definitions are part of that metadata, so they are replicated to the secondary database. The refresh on the primary recalculates the MV’s data, and the replication process ensures the secondary keeps the same MV definition in sync. This means the secondary can support the same materialized view structure if you fail over, with the actual MV data staying in sync through the replication mechanics and subsequent refreshes as needed.