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

Question

You are tasked with creating a Snowflake Notebook that reads data from an external stage (AWS S3), transforms it using Python, and then loads the transformed data into a Snowflake table. The external stage requires authentication using AWS IAM roles. Which of the following steps are necessary to configure the connection and access the data from the external stage within your Snowflake Notebook using Python? (Choose all that apply.)

Options

• ACreate a Snowflake storage integration object that defines the AWS IAM role ARN and the S3
• BGrant the necessary privileges (e.g., USAGE, READ) on the storage integration object to the
• CConfigure the AWS IAM role to trust the Snowflake account and grant it access to the S3 bucket.
• DUse the AWS SDK for Python (bot03) within the Snowflake Notebook to assume the IAM role and
• ECreate a Snowflake external table that points to the S3 bucket and uses the storage integration.

Explanation

Options A, B, C, and E are essential. To access data in an external stage secured with IAM roles, you need a Snowflake storage integration object (A) that defines the connection to S3. You must grant privileges on this integration to the appropriate Snowflake role (B). The IAM role must be configured to trust Snowflake (C). Finally, you typically create an external table (E) that uses the storage integration to access the data in S3. Using bot03 directly (D) is generally not necessary and bypasses Snowflake's security and governance mechanisms for accessing external stages.

No community discussion yet for this question.