
Answer-first summary for fast verification
Answer: Stream, External table
The question asks which objects are contained within a schema in Snowflake. According to Snowflake documentation and the community consensus (100% agreement on BD), Streams (B) and External Tables (D) are schema-level objects. Streams are created within a schema to track changes to tables, and External Tables are defined within a schema to reference external data sources. In contrast, Roles (A) and Warehouses (C) are account-level objects, Users (E) are managed at the account level, and Shares (F) are database-level objects for data sharing. The detailed comment by EmiB with 23 upvotes confirms the object hierarchy: Stream (SCHEMA) and External table (SCHEMA) are correct, while others belong to ACCOUNT or DATABASE levels.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.