Are reclustering operations performed on the primary database also applied automatically to the replicated database?

• A. Yes
• B. No
• C. Sometimes
• D. Only if enabling cross-database clustering

Answer: (B)

Reclustering is a maintenance task that reorganizes how data is laid out on disk for a table. In Snowflake, replication copies data and schema to the replicated database, but it does not carry over the clustering state or the results of a recluster. So, when you recluster on the primary, that work isn’t automatically reflected on the replica. If you want the replicated database to be similarly optimized, you’d need to recluster there as well (or enable automatic clustering on the replica so it maintains clustering independently).