Snowpro Associate Platform · Free Practice Question Easy
Question 15
- A CREATE NAMED STAGE
- B CREATE @STAGE
- C CREATE INTERNAL STAGE
Reveal correct answer
Correct answer:
Explanation
✅ CREATE STAGE
Explanation:
The correct command to create a named internal stage in Snowflake is simply CREATE STAGE. By default, this creates an internal stage unless you explicitly specify external stage parameters. You can also include options like file format, encryption, and comments.
Example:
- CREATE STAGE my_internal_stage
- FILE_FORMAT = (TYPE = 'CSV');
❌ Why the other options are incorrect?
CREATE INTERNAL STAGE → Not valid syntax; Snowflake doesn’t use this phrasing.
CREATE NAMED STAGE → Also invalid; “named” is a descriptive term, not part of the command.
CREATE @STAGE → Incorrect syntax;
@is used to reference a stage, not to create one.
You can explore the full syntax in Snowflake’s CREATE STAGE documentation.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
