SOL-C01 Question #280: Real Exam Question with Answer & Explanation

Question

A data engineer is trying to create a new internal stage named in Snowflake using the following command: 'CREATE OR REPLACE STAGE FILE FORMAT = (TYPE = CSV COMPRESSION = GZlP)f. After running the command, they receive an error stating 'SQL compilation error: Object does not exist, or operation cannot be performed.'. What is the MOST likely reason for this error?

Options

• AThe user does not have the necessary privileges to create stages in Snowflake.
• BThe specified file format does not exist or is invalid.
• CA stage with the same name already exists and the user does not have permissions to replace it.
• DNo database or schema is currently selected for the session context.
• EInternal stages cannot use the GZIP compression format.

Explanation

The error 'Object does not exist, or operation cannot be performed.' typically occurs when the database and schema are not explicitly specified, and the session context is not set, so Snowflake doesn't know where to create the stage. While permission issues (Option A) can cause errors, the error message is typically different and specifies insufficient privileges. Options B and E are incorrect because CSV with GZIP is a valid file format for internal stages. Option C, while possible, is less likely because the 'CREATE OR REPLACE clause should handle replacing the stage if the user has sufficient permissions.

No community discussion yet for this question.