Every new database in Snowflake is automatically created with a PUBLIC schema. Its primary purpose is to serve as a shared area for objects accessible to all users who have privileges on the database, typically via the PUBLIC role. It also acts as a default location for new objects when a user's session has a current database set but no specific schema is in use, simplifying object creation for common use cases.

A. The PUBLIC schema is intended for shared resources, not for data specific to a single user.

C. Account-level metadata is stored in the SNOWFLAKE shared database, primarily within the ACCOUNTUSAGE schema.

1. Snowflake Documentation. (2024). Databases, Schemas, and Objects. Retrieved from https://docs.snowflake.com/en/sql-reference/ddl-database. The section "Database Objects" notes that every database contains a PUBLIC schema by default.

2. Snowflake Documentation. (2024). Schema Object Resolution. Retrieved from https://docs.snowflake.com/en/sql-reference/name-resolution. This page explains how Snowflake resolves object names, including the fallback to the PUBLIC schema of the current database.