Exam SOL-C01 Topic 1 Question 195 Discussion

Actual exam question for Snowflake's SOL-C01 exam
Question #: 195
Topic #: 1

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:

A. Grant the 'USAGE privilege on the stage to the role that executes the Snowpark application. B. Grant the 'READ privilege on the stage to the role that executes the Snowpark application. (Note:
READ is not a real Snowflake Privilege on Stages) C. Ensure that the storage integration associated with has the appropriate AWS IAM role configured with read access to the S3 bucket. D. Grant the 'SELECT privilege on the underlying S3 bucket to the role that executes the Snowpark application. (Note: You can't GRANT privileges on S3 Buckets via Snowflake) E. Grant the 'EXECUTE TASK' privilege on the stage to the role that executes the Snowpark application.

Suggested Answer: A,C Vote an answer

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.

by Ingram at Oct 13, 2025, 03:21 PM

Limited Time Offer

15%

Off

Get Premium SOL-C01 Questions as Interactive Self Test Engine or PDF

Comments

0 Satisfied Customers

0 Shares

0 Demo Downloads

10 Years in Business