GET_OBJECT_REFERENCES returns which types of objects?

• A. Views (including secure views) and Tables
• B. Materialized views
• C. UDFs
• D. Streams

Answer: (A)

GET_OBJECT_REFERENCES is about the kinds of objects that a given object can depend on in its definition. In Snowflake, a view is built from a query that typically references base tables, and it can also reference other views (including secure views). Therefore, the types of objects that can be referenced are tables and views, with secure views included as a subtype of views. Materialized views, UDFs, and streams aren’t the primary reference types surfaced by this function in this context, so they aren’t listed as the reference types it returns. This is why the correct interpretation is that GET_OBJECT_REFERENCES returns views (including secure views) and tables.