Temporary tables belong to a specified database and schema?

• A. False
• B. Not applicable
• C. True
• D. Depends on user

Answer: (C)

Temporary tables exist within a database and schema just like regular tables, but their lifetime is limited to your session. You place them in a specific database and schema by naming them with a full qualifier (for example, database.schema.temp_table); if you omit the qualifiers, Snowflake uses the session’s default database and schema. Although they disappear at the end of the session, they still belong to a namespace in a particular database and schema, which makes the statement true.