Do reclustering operations performed on the primary database apply to the replicated database for performance improvement?

• A. Yes
• B. Only for replicated tables
• C. No
• D. Only if configured

Answer: (C)

Reclustering is about reorganizing a table’s data to align with its clustering keys, so Snowflake can prune more efficiently and speed up queries. When you replicate a database, Snowflake creates a separate copy that lives independently of the primary. While data changes are propagated to the replica, maintenance actions like reclustering aren’t automatically shared across to the replicated copy. So, reclustering the primary doesn’t apply to the replicated database. To gain the same performance benefits on the replica, you’d recluster the replicated database separately (or enable automatic clustering on that replica if supported).