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

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

• A1. Create the storage integration with appropriate IAM roles. 2. Create the external stage
• B1. Create the external stage specifying the S3 bucket URL and credentials. 2. Create a file format
• C1. Create the storage integration with appropriate IAM roles. 2. Use the 'LIST @stage' command to
• D1. Create the storage integration with appropriate IAM roles. 2. Create the external stage
• E1. Create the external stage specifying the S3 bucket URL and credentials. 2. Create a file format

Explanation

Options A and D are correct. The correct and secure approach involves using storage integrations with IAM roles. Creating the storage integration first establishes trust between Snowflake and AWS. The stage then references this integration. The 'COPY INTO' command (Option A) is used for loading data into Snowflake tables. External tables (option C) are read-only and designed for querying data in place, not loading it. Option D Corrects A by including the file format, which is generally required. Option B does not use storage integrations, which is more secure . Option E Requires credential in stage definition, which is not encouraged.

No community discussion yet for this question.