SnowPro Core Recertification — Question 1

Streams can be configured to query change data on which Snowflake objects? (Choose two.)

Answer options

• A. Pipe
• B. Stage
• C. Secure view
• D. Materialized view
• E. Shared table

Correct answer: C, E

Explanation

The correct choices, Secure view and Shared table, are the only Snowflake objects that can utilize streams to monitor and query change data. The other options, Pipe, Stage, and Materialized view, do not support this functionality in the same manner.