Which statement is true about database replication in Snowflake?

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

Multiple Choice

Which statement is true about database replication in Snowflake?

Explanation:
Replication copies a database you own in a primary region to a follower region for disaster recovery. A fundamental limit is that only databases you own can be replicated. A database created from a share isn’t owned by your account; it’s provided by another account through a data share. Because replication relies on owning and managing the database objects to create an exact, writable copy in the target region, a database created from a share cannot be replicated. The other statements mix different Snowflake features or editions and aren’t correct: replication isn’t limited to a specific edition, it doesn’t replicate across cloud providers, and account-level objects can be involved in separate replication features, not just databases.

Replication copies a database you own in a primary region to a follower region for disaster recovery. A fundamental limit is that only databases you own can be replicated. A database created from a share isn’t owned by your account; it’s provided by another account through a data share. Because replication relies on owning and managing the database objects to create an exact, writable copy in the target region, a database created from a share cannot be replicated. The other statements mix different Snowflake features or editions and aren’t correct: replication isn’t limited to a specific edition, it doesn’t replicate across cloud providers, and account-level objects can be involved in separate replication features, not just databases.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy