SOL-C01 practice question 20 of 30

Which statement is true regarding internal stages?

Full set: 214 questions
Answer options
A: Internal stages can only be used for semi-structured data
B: Internal stages are accessed with external cloud provider credentials
C: Internal stages are managed and stored within Snowflake Correct answer
D: Internal stages can only be used for structured data
Correct Answer:
C. Internal stages are managed and stored within Snowflake
Explanation

Internal stages are locations within a Snowflake account used for temporarily storing data files before loading them into tables (or after unloading them). Snowflake fully manages the storage for these stages, allocating space within its own cloud storage infrastructure associated with the account. This means users do not need to provide or manage credentials for an external cloud provider (like AWS S3, Azure Blob Storage, or Google Cloud Storage) to use them. All files within an internal stage are automatically encrypted and secured by Snowflake.

Why Incorrect

A. Internal stages can store files of any format, including structured (e.g., CSV), semi-structured (e.g., JSON, Avro), and unstructured data.
B. Accessing external stages requires external cloud provider credentials. Internal stages are accessed using Snowflake's own security and roles.
D. Internal stages are format-agnostic and are not limited to storing only structured data files.

References

- Snowflake Documentation. (n.d.). Choosing a Stage for Local Files. Retrieved from docs.snowflake.com. Under "Internal stages," it states, "Internal stages store data files internally within Snowflake."

- Snowflake Documentation. (n.d.). Internal Stages. Retrieved from docs.snowflake.com. This section clarifies, "Snowflake secures and manages all files in internal stages... An internal stage is a good option if you only plan to use the files in Snowflake."

Scroll to Top