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

Question

You have a Snowflake environment with a database named 'ANALYTICS DB'. You need to load data into a table named 'CUSTOMER DATA' that resides in a schema called 'RAW DATA" within 'ANALYTICS DB'. The data is staged in an internal stage called '@RAW DATA STAGE'. You encounter an error during the 'COPY INTO' command. Identify TWO potential reasons that could be causing this error, assuming the stage exists, the file format is correctly specified, and the data file is present.

Options

• AThe `RAW DATA' schema does not exist within the 'ANALYTICS DB' database.
• BThe role executing the 'COPY INTO' command lacks the SUSAGE' privilege on the 'RAW DATA'
• CThe table has a defined primary key, but the data in the staged file contains duplicate key values.
• DThe user executing the `COPY INTO' command does not have the 'OWNERSHIP' privilege on the
• EThe warehouse associated with the current session has not been resumed, so resources aren't

Explanation

The USAGE privilege on a schema is required to access objects within that schema. If the role lacks this privilege, it will not be able to access theCUSTOMER DATA table for the `COPY INTO' command. If the schema does not exist, then the 'COPY INTO' command can not find it and throws an error. Having no ownership on the stage is not important in this operation; COPY INTO commands need the READ privilege on the stage, not ownership. Option C assumes there is a primary key, and while this could cause failure, it isn't always the reason. If a warehouse is suspended, Snowflake should automatically resume it when a query is run.

No community discussion yet for this question.