Which of the following is a valid stage type for loading data into Snowflake?

• A. Named internal stage
• B. Temporary stage in memory
• C. Per-user stage
• D. Shared stage

Answer: (A)

Staging data for Snowflake loads uses stage objects, which are locations where files reside before (or after) loading. A named internal stage is a specific stage object you create inside Snowflake (for example, at the database/schema level) and manage just like a database object. You can upload files into it, reference it in COPY INTO statements, and apply a file format and path patterns to control how data is read. This is the standard, supported way to load data because the stage exists within Snowflake’s own storage and is explicitly defined and granted to users, making it reliable for repeatable loads.

Other concepts like a temporary stage in memory aren’t a recognized, standard stage type for loading data in Snowflake, and terms such as per-user stage or shared stage don’t correspond to a primary, named internal stage used for regular data loading.