Snowflake
SOL-C01 · Question #298
You are working with a Snowflake Notebook to process data from an external stage (AWS S3). You need to access the S3 stage using a named stage object and a storage integration configured with IAM role
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #298. The question stem and answer options stay visible for context.
Data Loading and Unloading
Question
You are working with a Snowflake Notebook to process data from an external stage (AWS S3). You need to access the S3 stage using a named stage object and a storage integration configured with IAM roles. Which of the following options represents the correct sequence of steps and Snowflake SQL commands within the notebook to achieve this?
Options
- A
- Create the storage integration with appropriate IAM roles. 2. Create the external stage
- B
- Create the external stage specifying the S3 bucket URL and credentials. 2. Create a file format
- C
- Create the storage integration with appropriate IAM roles. 2. Use the 'LIST @stage' command to
- D
- Create the storage integration with appropriate IAM roles. 2. Create the external stage
- E
- Create the external stage specifying the S3 bucket URL and credentials. 2. Create a file format
Unlock SOL-C01 to see the answer
You've previewed enough free SOL-C01 questions. Unlock SOL-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Storage Integration#External Stage#AWS S3#Data Loading