SOL-C01 Exam Dumps : SnowPro Associate: Platform Certification Exam

LIST @stage_name displays all files present in a stage (internal or external).

PUT uploads local files to an internal stage.

GET downloads files from an internal stage.

COPY INTO loads or unloads data but does not list files.

==================

In Snowflake’s logical hierarchy, tables reside within schemas, and schemas reside within databases. This structured arrangement allows clear organization, access management, and separation of workloads or business domains. A schema functions as a container that holds tables, views, functions, sequences, stages, and file formats. When users reference a table, they typically qualify it using the full three-part name: database.schema.table.

Stages are used to store or reference files, not to hold structured database tables. Virtual warehouses provide compute power for executing queries and performing DML operations but do not store data. File formats define how staged files should be interpreted (CSV, JSON, Parquet, etc.) and are unrelated to where tables physically reside.

Snowflake separates compute and storage, so while compute happens in virtual warehouses, all persistent data—including tables—is managed in Snowflake’s centralized storage layer, organized through schemas and databases. This organization ensures consistency, ease of management, and predictable access control.

==================

Snowflake allows users to list files in a stage using the LIST command, and it provides a shorthand alias: LS. Both commands return identical results, including file name, size, last modified timestamp, and other metadata stored in the stage. This is relevant for internal stages (user, table, named stages) and external stages backed by cloud storage. SHOW and DESC are unrelated commands—SHOW lists Snowflake metadata objects such as tables, schemas, or roles, while DESC describes object structures. “LIS” is not a Snowflake command. Therefore, LS is the exact shorthand synonym for LIST and is used identically in queries.

=======================================