SnowPro Advanced: Data Engineer — Question 4

A Data Engineer is working on a Snowflake deployment in AWS eu-west-1 (Ireland). The Engineer is planning to load data from staged files into target tables using the COPY INTO command.
Which sources are valid? (Choose three.)

Answer options

• A. Internal stage on GCP us-central1 (Iowa)
• B. Internal stage on AWS eu-central-1 (Frankfurt)
• C. External stage on GCP us-central1 (Iowa)
• D. External stage in an Amazon S3 bucket on AWS eu-west-1 (Ireland)
• E. External stage in an Amazon S3 bucket on AWS eu-central-1 (Frankfurt)
• F. SSD attached to an Amazon EC2 instance on AWS eu-west-1 (Ireland)

Correct answer: C, D, E

Explanation

The correct answers C, D, and E are valid sources for loading data into Snowflake. External stages in GCP and S3 buckets in the specified regions are allowed, while internal stages must be within the same cloud provider and region, making options A, B, and F invalid.