SOL-C01 practice question 5 of 30
Which command is synonymous with the LIST command in Snowflake?
Full set: 214 questionsCorrect Answer:
A. LS
Explanation
Snowflake defines LS as an exact synonym (alias) of the LIST command for enumerating staged files; both commands share identical syntax and behaviour.
Why Incorrect
B. SHOW is a family of metadata commands, not an alias for LIST.
C. DESC (or DESCRIBE) is used for describing objects, not listing stage contents.
D. LIS is not a recognised Snowflake command.
References
1. Snowflake Documentation – “LIST Command”, note: “Synonym: LS” (docs.snowflake.com, §Syntax, accessed 2024-04-24).
2. Snowflake Documentation – “Commands Not Covered by the SQL Parser” (docs.snowflake.com, confirms command aliases).
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 6Which of the following data format supported to unload semi-structured data from Snowflak…
- Question 7Which of the following file formats can be processed by the PARSE_DOCUMENT function?
