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

Question

You are developing a Snowpark Python application that needs to read data from an external stage. You have already created the stage named which points to an AWS S3 bucket containing Parquet files. However, when attempting to read the data using , you encounter an error indicating insufficient privileges. Which of the following actions are necessary to grant the Snowpark application the required permissions to access the data in the external stage? Choose all that apply:

Options

• AGrant the 'USAGE privilege on the stage to the role that executes the Snowpark application.
• BGrant the 'READ privilege on the stage to the role that executes the Snowpark application. (Note:
• CEnsure that the storage integration associated with has the appropriate AWS IAM role configured
• DGrant the 'SELECT privilege on the underlying S3 bucket to the role that executes the Snowpark
• EGrant the 'EXECUTE TASK' privilege on the stage to the role that executes the Snowpark

Explanation

To access data in an external stage, the role executing the Snowpark application needs the `USAGE privilege on the stage itself. Additionally, the storage integration associated with the stage needs to be properly configured with an AWS IAM role that has read access to the underlying S3 bucket. Granting USAGE grants the ability to 'use' the stage object in SQL statements. Without proper configuration of the IAM role and storage integration, Snowflake cannot authenticate with the S3 bucket to retrieve the data.

No community discussion yet for this question.