Question

You set up a Snowflake account, choosing AWS as your cloud platform provider. What stages can you use to load data files? 1. USER 2. TABLE 3. NAMED INTERNAL 4. NAMED EXTERNAL - using S3 Buckets 5. NAMED EXTERNAL - using Azure BLOB storage 6. NAMED EXTERNAL - using GCS/GCP Buckets

Answer 1

In setting up a Snowflake data warehouse on AWS, you can use 1) USER stages, 2) TABLE stages, 3) NAMED INTERNAL stages, and 4) NAMED EXTERNAL stages linked to S3 Buckets to load data files.

Step-by-step explanation:

When setting up a Snowflake data warehouse using AWS as your cloud platform, you have several stages to choose from to load data files. These include:

• USER stages which are private stages tied to specific Snowflake user accounts.
• TABLE stages that are tied to specific tables in which data files can be temporarily staged during a COPY operation.
• NAMED INTERNAL stages that are Snowflake managed locations for staging files prior to loading into tables.
• NAMED EXTERNAL stages using S3 Buckets, which refer to specific Amazon S3 buckets where data files are stored.

In the context of this question, stages 5 and 6 pertaining to Azure BLOB storage and GCS/GCP Buckets respectively are not applicable since the cloud platform provider chosen is AWS.