Answer: Pipe, File format

In Snowflake, schema objects are database objects that exist within a schema and contain or represent data. According to Snowflake documentation and the community consensus (100% agreement with upvoted comments), PIPE and FILE FORMAT are schema objects. Pipes are used for continuous data loading via Snowpipe, and FILE FORMAT defines the structure of external files for loading/unloading data. Other options are not schema objects: RESOURCE MONITOR is an account-level object for managing credit usage, STORAGE INTEGRATION is a security object for external cloud storage, and VIRTUAL WAREHOUSE is a compute resource independent of schemas.

Author: LeetQuiz Editorial Team