Which object parameter is replicated during replication?

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

Multiple Choice

Which object parameter is replicated during replication?

Explanation:
When a database is replicated, Snowflake copies the metadata that defines how the objects behave in the replicated environment. The data retention time in days sets the Time Travel window for the objects in the replicated database, so keeping this value in sync ensures consistent query results and historical access on the replica. The default warehouse is a runtime, account-level setting and is not automatically carried over to the replica; the object’s name is inherent to its identity and not treated as a replicated parameter; and comments are metadata that may not be guaranteed to copy, whereas Time Travel behavior needs to be consistent across primary and replica.

When a database is replicated, Snowflake copies the metadata that defines how the objects behave in the replicated environment. The data retention time in days sets the Time Travel window for the objects in the replicated database, so keeping this value in sync ensures consistent query results and historical access on the replica. The default warehouse is a runtime, account-level setting and is not automatically carried over to the replica; the object’s name is inherent to its identity and not treated as a replicated parameter; and comments are metadata that may not be guaranteed to copy, whereas Time Travel behavior needs to be consistent across primary and replica.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy