Which Snowflake object is supported by both database replication and replication groups?
Which Snowflake object is supported by both database replication and replication groups?
In Snowflake, pipes are supported by both database replication and replication groups. Pipes are used in the context of Snowpipe, which allows for continuous data ingestion into Snowflake. When you set up database replication or replication groups, pipes can be included in the replication process to ensure that the continuous data loading configurations are replicated along with the data.
Correct Answer: A. Pipes In Snowflake, pipes are supported by both database replication and replication groups. Pipes are used in the context of Snowpipe, which allows for continuous data ingestion into Snowflake. When you set up database replication or replication groups, pipes can be included in the replication process to ensure that the continuous data loading configurations are replicated along with the data.
Pipes are not supported in database replication. https://docs.snowflake.com/en/user-guide/account-replication-considerations
Materialized views are database objects that can be replicated using both database replication and replication groups. This makes sense because materialized views contain actual data and query results that need to be consistent across replicated databases. D
C is correct as it is supported by both database replication and replication groupds.
According to Snowflake documentation both "Pipes" and "Stages" are not replicated with database replication, so which one is correct? Replication and pipes: Snowflake currently supports pipe replication as part of group-based replication (replication and failover groups). Pipe replication is not supported for database replication. Replication and stages: Snowflake currently supports stage replication as part of group-based replication (replication and failover groups). Stage replication is not supported for database replication. https://docs.snowflake.com/en/user-guide/account-replication-considerations
D Pipe : supported by both users: only supported by replication groups stages :supported by replication groups but not by db replication Mat.view : supported by both
D Pipe : supported by both users: only supported by replication groups stages :supported by replication groups but not by db replication Mat.view : supported by both
D is correct, pipes are not supported by db replication
Related to pipes. I have found out in one UDEMY course, that Temporary tables, Stages and Pipes cannot be replicated. All other objects can. Users: I am not sure that an user can be considered an object in SNOWFLAKE or in IT, in general. It remains Materialized views