Exam SnowPro Core topic 1 question 1106 discussion

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

D is correct, pipes are not supported by db replication

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

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

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

C is correct as it is supported by both database replication and replication groupds.

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.