Which database object is not replicated to the secondary database during replication?

• A. Temporary Tables
• B. External Tables
• C. Stages
• D. Pipes

Answer: (D)

Pipes are not replicated because replication copies persistent database objects and their data, not runtime ingestion pipelines. A pipe defines a Snowpipe ingestion workflow that ties a stage to a target table and often depends on environment-specific settings; these ingestion configurations aren’t carried over to the secondary automatically. If you want the same ingestion on the replica, you would recreate the pipe and its related components there. Temporary tables are session-scoped and not meant to persist across environments, while external tables and stages are metadata definitions that describe access to external data sources, and these are typically replicated so the secondary can reference the same data sources.