Snowflake moves data between accounts automatically when replication is configured.

Master the SnowPro Advanced Architect Test with flashcards, multiple-choice questions, and detailed explanations. Prepare thoroughly for your certification!

Multiple Choice

Snowflake moves data between accounts automatically when replication is configured.

Explanation:
Account replication in Snowflake creates a continuous copy of selected objects in a secondary account and keeps them in sync. It does not relocate or remove data from the primary account; the source remains intact while a mirror exists in the other account. The process is asynchronous and requires you to configure which databases, schemas, and objects to replicate, plus bootstrap the initial copy. Because data is copied to the secondary rather than moved, the statement that data moves between accounts automatically when replication is configured is not accurate. The behavior you get is automatic replication of copies, not automatic relocation of the original data.

Account replication in Snowflake creates a continuous copy of selected objects in a secondary account and keeps them in sync. It does not relocate or remove data from the primary account; the source remains intact while a mirror exists in the other account. The process is asynchronous and requires you to configure which databases, schemas, and objects to replicate, plus bootstrap the initial copy. Because data is copied to the secondary rather than moved, the statement that data moves between accounts automatically when replication is configured is not accurate. The behavior you get is automatic replication of copies, not automatic relocation of the original data.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy