SOL-C01 practice question 20 of 30
Which statement is true regarding internal stages?
Full set: 214 questionsInternal 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.
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.
- 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."
Keep practicing
Take the free SOL-C01 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other SOL-C01 practice questions
- Question 1Which Snowflake object is a logical container for schemas and other database objects?
- Question 2How can Python variable substitution be performed in Snowflake notebooks?
- Question 3Which SQL command is commonly used to load structured data from a stage into a Snowflake …
- Question 4Which command can be used to query the Information Schema in Snowflake to retrieve a list…
- Question 5Which command is synonymous with the LIST command in Snowflake?
- Question 6Which of the following data format supported to unload semi-structured data from Snowflak…
