Streams cannot be created to query change data on which of the following objects? [Select All that Apply]

Streams cannot be created to query change data on which of the following objects? [Select All that Apply]
A . Standard tables, including shared tables.
B . Views, including secure views
C . Directory tables
D . Query Log Tables
E . External tables

View Answer

Answer: B,D,E

Explanation:

Streams capture DML changes (INSERT, UPDATE, DELETE) made to the underlying table. You can’t create streams on objects that do not directly store data or do not support DML operations, such as views and external tables.

Query log tables in Snowflake are system-generated views that give you insights into the queries executed. You cannot create streams on these tables because they are system-managed and don’t support direct DML operations.